[Pljava-dev] ResultSet from trigger screwy with timestamp type

Thomas:
It appears that the error I am getting is isolated to when postgresql is compiled with the 'integer_datetimes' option (i.e. integer_datetimes = on). When I recompiled postgresql without integer_datetimes (leaving out '--enable-integer-datetimes' ) the date returned from the ResultSet method 'getTimestamp()' works fine.

Thanks in advance
John Burtenshaw

-----Original Message-----
From: pljava-dev-bounces at gborg.postgresql.org on behalf of Thomas Hallgren
Sent: Fri 9/2/2005 11:31 AM
To: Burtenshaw, John J.
Cc: pljava-dev at gborg.postgresql.org
Subject: Re: [Pljava-dev] ResultSet from trigger screwy with timestamp type

Burtenshaw, John J. wrote:

>
> Thomas:
> Thanks for your reply. Sorry for the confustion with gcj. I am using
> the following 'binary' from the pljava home site:
>
> pljava-i686-pc-linux-gnu-pg8.0-1.1.0.tar.gz
>
> I believe it is PLJava 1.1. I am also using Postgresql 8.0.3. Is
> there a way of determining if the debian package of postgresql that I
> have installed is compiled with the integer/timestamp support? I'm
> guessing that we want integer/timestamp support for PLjava to work
> properly.
>
As I said earlier, PL/Java _should_ dynamically adapt to how the
PostgreSQL binary is compiled. But considering the error you get, it
would be of great value if you could verify what the setting is, and if
the result is different if PostgreSQL is compiled differently.

Regards,
Thomas Hallgren

_______________________________________________
Pljava-dev mailing list
Pljava-dev at gborg.postgresql.org
http://gborg.postgresql.org/mailman/listinfo/pljava-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050902/d3b5af38/attachment.html>