8.1beta timezone question
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.
_______________________________
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