From: | Ziyun Audrey Wang <ziyun(dot)wang(at)ericsson(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #14148: postgres does not support GST timezone |
Date: | 2016-05-18 18:37:39 |
Message-ID: | 863714784A31A145844D361F189C6E6844C2D0BE@eusaamb107.ericsson.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi Tom
Thanks for the info.
By adding the GST definition it works now.
Thanks!
Best Regards
Audrey
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: May-18-16 1:24 PM
To: Ziyun Audrey Wang
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #14148: postgres does not support GST timezone
ziyun(dot)wang(at)ericsson(dot)com writes:
> got error:
> ERROR: invalid input syntax for type timestamp with time zone: "Wed
> May 18
> 09:40:25 GST 2016"
You can adjust the set of zone abbreviations Postgres recognizes:
http://www.postgresql.org/docs/9.3/static/datetime-config-files.html
GST isn't in the default set because there are multiple possible meanings according to the IANA timezone database.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | 自己 | 2016-05-19 06:47:38 | ALTER TABLE can NOT use set (OIDS=true) |
Previous Message | Ziyun Audrey Wang | 2016-05-18 18:23:02 | Re: BUG #14148: postgres does not support GST timezone |