Search Postgresql Archives

Re: now() time off

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Feb 23, 2006 at 12:41:38PM +0100, Martijn van Oosterhout wrote:
> 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...

Wow, didn't know that was there... was it added fairly recently or have
I just been blind?
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@xxxxxxxxxxxxx
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux