Re: now() time off

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: now() time off
Дата
Msg-id 20060223222119.GE2068@pervasive.com
обсуждение исходный текст
Ответ на Re: now() time off  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Re: now() time off  (Michael Fuhr <mike@fuhr.org>)
Список 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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How I changed the encoding of template1 after the fact
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: ExclusiveLock without a relation in pg_locks