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

From Neil Conway
Subject Re: pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...
Date
Msg-id 1049322247.18811.3.camel@tokyo
Whole thread Raw
In response to Re: pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...
List pgsql-committers
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


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pgsql-server/ /configure /configure.in rc/Make ...
Next
From: momjian@postgresql.org (Bruce Momjian - CVS)
Date:
Subject: pgsql-server/doc TODO