Re: BUG #14148: postgres does not support GST timezone - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14148: postgres does not support GST timezone
Date
Msg-id 14010.1463592246@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14148: postgres does not support GST timezone  (ziyun.wang@ericsson.com)
Responses Re: BUG #14148: postgres does not support GST timezone
List pgsql-bugs
ziyun.wang@ericsson.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

pgsql-bugs by date:

Previous
From: ziyun.wang@ericsson.com
Date:
Subject: BUG #14148: postgres does not support GST timezone
Next
From: John R Pierce
Date:
Subject: Re: BUG #14148: postgres does not support GST timezone