8.1beta timezone question

From: Bricklen Anderson <BAnderson(at)PresiNET(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 8.1beta timezone question
Date: 2005-09-08 14:38:12
Message-ID: 43204CD4.1050808@PresiNET.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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.
_______________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-09-08 14:40:19 Re: pg_restore - authentication failed?
Previous Message Michael Fuhr 2005-09-08 14:35:51 Re: Partial commit within the trasaction

Browse pgsql-hackers by date

  From Date Subject
Next Message aly.dharshi 2005-09-08 14:46:50 Re: initdb profiles
Previous Message Dave Cramer 2005-09-08 14:05:42 Re: Attention PL authors: want to be listed in template table?