[Pljava-dev] R: R: select CURRENT_TIMESTAMP is wrong

Stefano Bianchi stefano.bianchi at iskranet.net
Wed Feb 20 09:07:38 UTC 2008


Hi there,

i try to compile from cvs, but my env may be wrong and i fail.

Question is: 
Linux i386: pljava-i686-pc-linux-gnu-pg8.3-1.4.0.tar.gz linked at
http://wiki.tada.se/display/pljava/Download+Page is currently update to cvs,
so I never need to compile from source to fix my problem ?

Thanks in advance

Stefano Bianchi 

-----Messaggio originale-----
Da: pljava-dev-bounces at pgfoundry.org
[mailto:pljava-dev-bounces at pgfoundry.org] Per conto di Kris Jurka
Inviato: venerdì 1 febbraio 2008 6.09
A: Lucas Madar
Cc: pljava-dev at pgfoundry.org
Oggetto: Re: [Pljava-dev] R: select CURRENT_TIMESTAMP is wrong



On Fri, 25 Jan 2008, Kris Jurka wrote:

> On Fri, 25 Jan 2008, Lucas Madar wrote:
>
>> I didn't post this to the list by mistake, but I found a solution. It
appears
>> that some precision is being lost with certain compilers. The culprit is
>> this:
>>       mSecs += EPOCH_DIFF * 1000;                     /* Adjust for diff
>> between Postgres and Java (Unix) */
>>

This is not compiler dependent, it just depends on whether this code is 
used or not.  This function is only used when running against a server 
built with integer datetimes.

Fixed in CVS.

Kris Jurka
_______________________________________________
Pljava-dev mailing list
Pljava-dev at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pljava-dev




More information about the Pljava-dev mailing list