Re: [BUGS] now() gives the time of the last commit, not the time it

2002-10-23 Thread Bruce Momjian
Yes, this is a known issue with now(). We discussed it at great length and decided to keep it the same in 7.3. There is timeofday for current time, but that can change during the query. I think 7.4 will have a parameter to now() which you can get the statement time, which is probably what you w

Re: [BUGS] now() gives the time of the last commit, not the time it

2002-10-23 Thread Stephan Szabo
On Wed, 16 Oct 2002, Talja Ari wrote: > Postgres version: 7.2.1 > Platform: Server on Linux, (java-)client on HP-UX.11 and SunOS 5.8 > JDBC drivers: For PostgreSQL 7.2, JDK 1.3 > JDK version: 1.3.1 > Autocommit off for each connection > Special server flags: -i to allow the connections from differ

[BUGS] now() gives the time of the last commit, not the time it is called

2002-10-23 Thread Talja Ari
Postgres version: 7.2.1 Platform: Server on Linux, (java-)client on HP-UX.11 and SunOS 5.8 JDBC drivers: For PostgreSQL 7.2, JDK 1.3 JDK version: 1.3.1 Autocommit off for each connection Special server flags: -i to allow the connections from different host The program is a java server, which updat