Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2350: Timezone string fails in a certain context (see below). - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2350: Timezone string fails in a certain context (see below).
Date
Msg-id 17553.1143047601@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2350: Timezone string fails in a certain context (see below).  ("Gloria W" <strangest@comcast.net>)
Responses Re: BUG #2350: Timezone string fails in a certain context
List pgsql-bugs
Tree view 
"Gloria W" <strangest@comcast.net> writes:
> ERROR:  invalid input syntax for type timestamp with time zone: "2006-03-20
> 09:06:00 US/Pacific"

That is not currently supported, sorry.  Timestamp input can only use
the timezone names known to the "date token table", which basically
is the short abbreviations like PST.  It'll get fixed eventually but
it's a feature enhancement not a bug.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Mike Haller"
Date:
Subject: BUG #2354: No admin rights, but still refuses to run
Next
From: Tom Lane
Date:
Subject: Re: BUG #2353: Temporary tables created within trigger function still exist after abend