8.1beta timezone question

Started by Bricklen Andersonover 20 years ago3 messages
#1Bricklen Anderson
BAnderson@PresiNET.com

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

The tzname still works fine, though:
SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Canada/Pacific';
timezone
-------------------------
16/02/2001 20:38:40 PST

Or maybe there is a setting that I neglected to adjust to make this work on
8.1beta1? The same error occurs with several other timezone abbreviations that I
tried.

Cheers,

Bricklen
--
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bricklen Anderson (#1)
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

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tom Lane (#2)
Re: [GENERAL] 8.1beta timezone question

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