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