Postgres Pro
Downloads
Home   >   mailing lists

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

From Ziyun Audrey Wang
Subject Re: BUG #14148: postgres does not support GST timezone
Date
Msg-id 863714784A31A145844D361F189C6E6844C2D0BE@eusaamb107.ericsson.se
Whole thread Raw
In response to Re: BUG #14148: postgres does not support GST timezone  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses ALTER TABLE can NOT use set (OIDS=true)
List pgsql-bugs
Tree view 
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@sss.pgh.pa.us]=20
Sent: May-18-16 1:24 PM
To: Ziyun Audrey Wang
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #14148: postgres does not support GST timezone

ziyun.wang@ericsson.com writes:
> got error:
> ERROR:  invalid input syntax for type timestamp with time zone: "Wed=20
> 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 a=
ccording to the IANA timezone database.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Ziyun Audrey Wang
Date:
Subject: Re: BUG #14148: postgres does not support GST timezone
Next
From: 自己
Date:
Subject: ALTER TABLE can NOT use set (OIDS=true)