| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
| Cc: | 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 11:41:38 |
| Message-ID: | 20060223114138.GE28530@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dragan Matic | 2006-02-23 13:15:07 | Is there a way to check which indexes are being used for a table |
| Previous Message | Martijn van Oosterhout | 2006-02-23 11:15:07 | Re: How do I use the backend APIs |