Thread: Re: [GENERAL] 8.1beta timezone question

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

I wrote:
> 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.

I've committed a fix for this.
        regards, tom lane