| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bricklen Anderson <BAnderson(at)PresiNET(dot)com> |
| Cc: | "Magnus Hagander" <mha(at)sollentuna(dot)net>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] 8.1beta timezone question |
| Date: | 2005-09-08 18:01:11 |
| Message-ID: | 17716.1126202471@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Bricklen Anderson <BAnderson(at)PresiNET(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Peter | 2005-09-08 18:03:10 | Re: back references using regex |
| Previous Message | Chris Travers | 2005-09-08 17:27:59 | Re: How to write jobs in postgresql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2005-09-08 18:04:14 | Re: pg_config/share_dir |
| Previous Message | Tom Lane | 2005-09-08 17:40:43 | Re: initdb profiles |