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

From: "Jodi Escalante" <jescalante(at)assistgroup(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5281: Timestamp fields not inserting from 8.3 to 8.4
Date: 2010-01-15 17:23:02
Message-ID: 201001151723.o0FHN2sb094760@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: 5281
Logged by: Jodi Escalante
Email address: jescalante(at)assistgroup(dot)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 trying to insert some data from one table in an 8.3 instance to
the same table in an 8.4 instance. (I am actually using an ETL tool but get
the same error with the tool or using pgAdmin. Everything is the same in
both tables.

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)

ERROR: syntax error at or near "15"
SQL state: 42601
Character: 545

"15" is the time section of the date field.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2010-01-15 17:35:14 Re: BUG #5281: Timestamp fields not inserting from 8.3 to 8.4
Previous Message Robert Haas 2010-01-15 16:51:34 Re: Failed to run initdb - not resolved bug 5130