Re: [BUGS] CURRENT_TIMESTAMP not work correctly insinde a transaction.

2002-02-22 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Thomas Lockhart writes: >> This is not a bug, but the behavior required by SQL9x afaicr. > AFAIK, this is PostgreSQL bugward compatibility. SQL says that > current_timestamp returns the "current timestamp", which you can interpret > any way you want

Re: [BUGS] CURRENT_TIMESTAMP not work correctly insinde a transaction.

2002-02-22 Thread Peter Eisentraut
Thomas Lockhart writes: > > In a transaction until you commit your transaction through a jdbc > > connection, each time you use the Current_timestamp (or 'now'), the > > timestamps is always the same, and when your transaction is very long you > > have undesirable effect. > > This is not a bug, b

Re: [BUGS] CURRENT_TIMESTAMP not work correctly insinde a transaction.

2002-02-22 Thread Thomas Lockhart
> In a transaction until you commit your transaction through a jdbc > connection, each time you use the Current_timestamp (or 'now'), the > timestamps is always the same, and when your transaction is very long you > have undesirable effect. This is not a bug, but the behavior required by SQL9x af