Re: pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...

On Wed, 2003-04-02 at 13:37, Tom Lane wrote:
> > Log message:
> >     Add start time to pg_stat_activity
>
> Why did this patch declare pg_stat_activity.query_start as timestamp
> without time zone?  Meseems it should be timestamp with time zone.
> The other datatype isn't really intended to represent the times of
> real-world events.

Woops, my mistake.

> I also note that the displayed time is off about five hours (my offset
> from GMT), which I suspect has a lot to do with this error ...

Can you fix it, or should I? I'm pretty swamped at the moment, so I
probably won't be able to get to it for a little while...

Cheers,

Neil