Re: BUG #2350: Timezone string fails in a certain context

From: Gloria <strangest(at)comcast(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org, Kiren Karra <kiren(at)livingindependently(dot)com>
Subject: Re: BUG #2350: Timezone string fails in a certain context
Date: 2006-03-22 17:47:37
Message-ID: 44218DB9.8060107@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thank you. I appreciate this quick response.
Gloria

>"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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-03-22 17:49:57 Re: BUG #2352: Bug with Pl/Python
Previous Message Tom Lane 2006-03-22 17:15:22 Re: BUG #2353: Temporary tables created within trigger function still exist after abend