Re: Win32 timezone matching

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Cc: Magnus Hagander <magnus@hagander.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-04-07T15:57:44Z
Lists: pgsql-hackers
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.

> I would consider the failure to make sense of the registry on windows or 
>   failure to figure timezone information out a more serious issue than a 
> mere "WARNING" because depending on how you look at the issue it might 
> actually cause silent data corruption.

Somehow, if you're running a database on windoze, I doubt your data
integrity standards are that high.  In any case I'd rather get a bleat
about "why is the server running in GMT" than "my database won't start".
The former will be a lot easier to narrow down.

			regards, tom lane