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

On Wed, 2007-03-14 at 12:12 -0400, Tom Lane wrote:
> Jaime Silvela <JSilvela@Bear.com> writes:
> > ... before doing that I'd like to find out what's the
> > problem with the DST not taking.
>
> > The timezone is 'EST5EDT', and
>
> 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

>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend