Re: BUG #2350: Timezone string fails in a certain context (see below).

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gloria W" <strangest(at)comcast(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2350: Timezone string fails in a certain context (see below).
Date: 2006-03-22 17:13:21
Message-ID: 17553.1143047601@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Gloria W" <strangest(at)comcast(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-03-22 17:15:22 Re: BUG #2353: Temporary tables created within trigger function still exist after abend
Previous Message Mike Haller 2006-03-22 16:27:23 BUG #2354: No admin rights, but still refuses to run