Re: [SQL] Monitoring a Query - Mailing list pgsql-general

From Tom Lane
Subject Re: [SQL] Monitoring a Query
Date
Msg-id 22827.1032800742@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] Monitoring a Query  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: [SQL] CURRENT_TIMESTAMP  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-general
Manfred Koizar <mkoi-pg@aon.at> writes:
> This has been discussed before and I know I'm going to get flamed for
> this, but IMHO having now() (which is a synonym for CURRENT_TIMESTAMP)
> return the start time of the current transaction is a bug, or at least
> it is not conforming to the standard.

As you say, it's been discussed before.  We concluded that the spec
defines the behavior as implementation-dependent, and therefore we
can pretty much do what we want.

If you want exact current time, there's always timeofday().

            regards, tom lane

pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: [SQL] Monitoring a Query
Next
From: Vernon Wu
Date:
Subject: How to i18n work with jdbc?