Re: Win32 timezone matching - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Win32 timezone matching
Date
Msg-id n2o9837222c1004071010zfa84936bj4892269ce18c562b@mail.gmail.com
Whole thread Raw
In response to Re: Win32 timezone matching  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Win32 timezone matching  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-hackers
On Wed, Apr 7, 2010 at 7:04 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Wed, Apr 7, 2010 at 12:20 PM, Stefan Kaltenbrunner
> <stefan@kaltenbrunner.cc> wrote:
>> Tom Lane wrote:
>>>
>>> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
>>>>
>>>> hmm all that code makes me wonder a bit about a more general issue - is
>>>> the "fallback to GMT if we fail to actually make sense of the right imezone
>>>> to use" actually a good idea?
>>>
>>> What alternative are you proposing?  Failing to start the server doesn't
>>> seem like an attractive choice.
>>
>> why not? we do error out in a lot of other cases as well... Personally I
>> find a hard and clear "something is wrong please fix" much more convinient
>> than defaulting to something that is more or less completely arbitrary but
>> well...
>
> While I can understand why someone might want that behavior in some
> cases, in other cases it might be a severe overreaction.

I think the dangerous scenario is if it worked, and then stopped
working. In that case, the database will change it's behavior and it
might go unnoticed. If it's wrong on first install, it'll likely get
noticed..

-- Magnus HaganderMe: http://www.hagander.net/Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Thoughts on pg_hba.conf rejection
Next
From: Robert Haas
Date:
Subject: Re: Streaming replication and a disk full in primary