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
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
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