| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, John McCawley <nospam(at)hardgeus(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: now() time off |
| Date: | 2006-02-23 22:21:19 |
| Message-ID: | 20060223222119.GE2068@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-02-23 22:21:22 | Re: ExclusiveLock without a relation in pg_locks |
| Previous Message | Tom Lane | 2006-02-23 21:52:36 | Re: How I changed the encoding of template1 after the fact |