Guy Fraser <guy@incentre.net> writes:
> On Wed, 2007-03-14 at 12:12 -0400, Tom Lane wrote:
>> Is it really 'EST5EDT', or 'est5edt' ? 8.1 is case sensitive about this.
> /usr/local/share/postgresql/timezone/EST5EDT
> /usr/local/share/postgresql/timezone/SystemV/EST5EDT
> /usr/share/zoneinfo/EST5EDT
> /usr/share/zoneinfo/SystemV/EST5EDT
Yeah, that's why it makes a difference. 'est5edt' doesn't match any of
those and so it gets taken as a POSIX-rule timezone spec.
regression=# set timezone = 'EST5EDT';
SET
regression=# select now();
now
-------------------------------
2007-03-14 12:52:41.798348-04
(1 row)
regression=# set timezone = 'est5edt';
SET
regression=# select now();
now
------------------------------
2007-03-14 11:52:46.21214-05
(1 row)
regression=#
regards, tom lane