Re: BUG #14148: postgres does not support GST timezone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ziyun(dot)wang(at)ericsson(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14148: postgres does not support GST timezone
Date: 2016-05-18 17:24:06
Message-ID: 14010.1463592246@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2016-05-18 17:31:49 Re: BUG #14148: postgres does not support GST timezone
Previous Message ziyun.wang 2016-05-18 16:36:49 BUG #14148: postgres does not support GST timezone