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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs