[Pljava-dev] PLJAVA is returning wrong Timestamp (patch is attached)

Lists: PostgreSQL : PostgreSQL 메일 링리스트 : 2011-07-24 이후 스포츠 토토 결과Dev 16:57
From: michalek(dot)petr at gmail(dot)com ( Petr Michálek )
To:
Subject: [Pljava-dev] PLJAVA is returning wrong Timestamp (patch is attached)
Date: 2011-07-24 16:57:10
Message-ID: CAHs4H_z5=RtYPSwezZuy-r8ouvTQAcOWO9f9ZfXdSbFo2ra-tA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: PostgreSQL : PostgreSQL 메일 링리스트 : 2011-07-24 이후 스포츠 토토 결과Dev 16:57

Hi,

I found, that pljava is returning wrong Timestamp value (using
preparedStatement and executeQuery)

Returned value: 2008-09-25 12:53:50.000557
Value stored in DB: 2008-09-25 12:53:50.558557+02

Please, is anybody able to commit attached patch and check behaviour of
Timestamp in other cases (update, etc.)?

Thanks in advance!

Petr Mich?lek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110724/4885848b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: timestamp.diff
Type: text/x-patch
Size: 410 bytes
Desc: not available
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110724/4885848b/attachment.bin>


From: johann at 2ndquadrant(dot)com (Johann 'Myrkraverk' Oskarsson)
To:
Subject: [Pljava-dev] PLJAVA is returning wrong Timestamp (patch is attached)
Date: 2011-07-28 12:46:23
Message-ID: x6d3gu1skg.fsf@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pljava-dev

Petr Mich?lek <michalek.petr at gmail.com> writes:

> Please, is anybody able to commit attached patch and check behaviour
> of Timestamp in other cases (update, etc.)?

I'll be doing that today.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/


From: johann at 2ndquadrant(dot)com (Johann 'Myrkraverk' Oskarsson)
To:
Subject: [Pljava-dev] PLJAVA is returning wrong Timestamp (patch is attached)
Date: 2011-08-02 17:23:17
Message-ID: x6oc07pw1m.fsf@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pljava-dev

Petr Mich?lek <michalek.petr at gmail.com> writes:

> Hi,
>
> I found, that pljava is returning wrong Timestamp value (using
> preparedStatement and executeQuery)

Fixed in CVS as of src/C/pljava/type/Timestamp.c 1.23

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/