Re: [GENERAL] 8.1beta timezone question - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] 8.1beta timezone question
Date
Msg-id 17716.1126202471@sss.pgh.pa.us
Whole thread Raw
Responses Re: [GENERAL] 8.1beta timezone question
List pgsql-hackers
Bricklen Anderson <BAnderson@PresiNET.com> writes:
> I may have missed it in the docs, but were certain timestamp abbreviations
> phased out between 8.0.3 and 8.1 beta1?

> eg.
> (8.0.3)
> #SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'PST';
>         timezone
> -------------------------
>  16/02/2001 20:38:40 PST


> (8.1beta1)
> #SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'PST';
> ERROR:  time zone "PST" not recognised

This is not good.  We put in code to support the zic timezone names,
but we weren't supposed to be removing anything that worked before.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Attention PL authors: want to be listed in template table?
Next
From: Andrew Dunstan
Date:
Subject: Re: pg_config/share_dir