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

2010-01-15 Thread Chris Travers
On Fri, Jan 15, 2010 at 9:38 AM, Kevin Grittner wrote: > "Jodi Escalante" wrote: > >> 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, >> ) VALUE

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

2010-01-15 Thread Kevin Grittner
"Jodi Escalante" wrote: > 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

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

2010-01-15 Thread Heikki Linnakangas
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

[BUGS] BUG #5281: Timestamp fields not inserting from 8.3 to 8.4

2010-01-15 Thread Jodi Escalante
The following bug has been logged online: Bug reference: 5281 Logged by: Jodi Escalante Email address: jescala...@assistgroup.com PostgreSQL version: 8.3 and 8.4 Operating system: Linux Description:Timestamp fields not inserting from 8.3 to 8.4 Details: Hi - I am tr