BUG #2350: Timezone string fails in a certain context (see below).
От | Gloria W |
---|---|
Тема | BUG #2350: Timezone string fails in a certain context (see below). |
Дата | |
Msg-id | 200603211633.k2LGXDLl079280@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #2350: Timezone string fails in a certain context (see below).
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2350 Logged by: Gloria W Email address: strangest@comcast.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
В списке pgsql-bugs по дате отправления: