Re: BUG #5281: Timestamp fields not inserting from 8.3 to 8.4

Jodi Escalante wrote:
> I am erroring out on record number one on the first timestamptz field. I
> have tested several different tables and they all error out on the
> timestamptz field. Below is a sample SQL.
>
> I downloaded the most recent JDBC driver and that did not help.
>
> INSERT INTO assessment (id, created, taken, current_weight, note,
> assessment_type, stay_id,
> contact_id, estimated_discharge_date,
> cond_chf, cond_pulm_heart, cond_endocrine_other, cond_skin_temp, )
> VALUES ( 50, 2008-01-11 15:06:40.257000 -07:00:00,
> 2008-01-11 00:00:00.000000 -07:00:00, 2000.0, NULL, Initial, 3452,
> 2147, NULL, N, N, N, N)

Not a bug. You need to quote those timestamps. As in:

INSERT INTO assessment (id, created, taken, current_weight, note,
assessment_type, stay_id,
contact_id, estimated_discharge_date,
cond_chf, cond_pulm_heart, cond_endocrine_other, cond_skin_temp, )
VALUES ( 50, '2008-01-11 15:06:40.257000 -07:00:00',
'2008-01-11 00:00:00.000000 -07:00:00', 2000.0, NULL, Initial, 3452,
2147, NULL, N, N, N, N)

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com