Re: DST failing on 8.1.3 - Mailing list pgsql-general

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