Re: DST failing on 8.1.3

Guy Fraser <guy(at)incentre(dot)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