Re: now() time off - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: now() time off
Date
Msg-id 20060223114138.GE28530@svana.org
Whole thread Raw
In response to Re: now() time off  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: now() time off  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-general
On Wed, Feb 22, 2006 at 06:35:55PM -0600, Jim C. Nasby wrote:
> On Wed, Feb 22, 2006 at 04:46:35PM -0600, Scott Marlowe wrote:
> > Sounds like a time zone issue.  I'd start looking there.
>
> I've been bitten by this before as well. I'd be in favor of adding an
> option such that postmaster would refuse to start if TZ was something
> other than UTC; I'd much rather that then have a bunch of data get
> screwed up...

Alternativly you could just set the "timezone" parameter in the
postgresql configuration...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: How do I use the backend APIs
Next
From: Dragan Matic
Date:
Subject: Is there a way to check which indexes are being used for a table