From: | "Gloria W" <strangest(at)comcast(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2350: Timezone string fails in a certain context (see below). |
Date: | 2006-03-21 16:33:13 |
Message-ID: | 200603211633.k2LGXDLl079280@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2350
Logged by: Gloria W
Email address: strangest(at)comcast(dot)net
PostgreSQL version: 8.1.2
Operating system: Red Hat 2.6.9-11.ELsmp #1 SMP Fri May 20 18:26:27 EDT
Description: Timezone string fails in a certain context (see below).
Details:
This statement works just fine:
insert into tasks (client_id, task_id, scheduled_time,
scheduled_time_required) values(699,4,('2006-03-20 09:06:00 PST' at time
zone 'US/Eastern'),'2006-03-20 06:00:00');
INSERT 0 1
But this one fails:
lii_hardware=# insert into tasks (client_id, task_id, scheduled_time,
scheduled_time_required) values(699,4,('2006-03-20 09:06:00 US/Pacific' at
time zone 'US/Eastern'),'2006-03-20 06:00:00');
ERROR: invalid input syntax for type timestamp with time zone: "2006-03-20
09:06:00 US/Pacific"
The only difference between the two is the PST timezone string was replaced
with a longer, also correct, timezone string.
Thank you in advance for your help.
Gloria
From | Date | Subject | |
---|---|---|---|
Next Message | Rafael Jorge Sierra Goncales | 2006-03-21 20:21:55 | BUG #2352: Bug with Pl/Python |
Previous Message | Magnus Hagander | 2006-03-21 16:06:45 | Re: BUG #2343: Silent installers fails |