Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...
Date
Msg-id 22145.1049308640@sss.pgh.pa.us
Whole thread Raw
In response to pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...  (momjian@postgresql.org (Bruce Momjian - CVS))
Responses Re: pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...  (Neil Conway <neilc@samurai.com>)
List pgsql-committers
Tree view 
> 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.

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

            regards, tom lane

pgsql-committers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: pgsql-server/src/backend/utils/adt formatting.c
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql-server/src/backend/libpq ip.c