From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug #885: Trouble with timestamps after vacuuming |
Date: | 2003-01-24 19:07:53 |
Message-ID: | 20030124190753.6916A47723B@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Marcelo (marsosa(at)tangobroker(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Trouble with timestamps after vacuuming
Long Description
I had a table in which one field is a timestamp:
CREATE TABLE blabla (
[...]
"update_time" timestamp with time zone
[...]
)
I did a pg_dump of the table and then i wanted to re create it and it gives me the following error:
Query failed: ERROR: Bad timestamp external representation '06/05/2002 11:42:10 ART'
I had to take out the " ART" part (sed s/" ART"/""/ did the trick)
But if i do a pg_dump again, the same happens, so i can't have a backup ready-to-go.
Is it a bug? a feature? or some setting somewhere?
PostgreSQL 7.2.3 on i586-pc-linux-gnu, compiled by GCC 2.96 (redhat 7.2, postgres installed from sources)
Thanks,
Marcelo.
Sample Code
INSERT INTO "indices" ("ind_nombre","cierre_ant","precio_ult","update_time") VALUES ('MERVAL','525.0900','524.9500','02/01/2003 11:08:02 ART');
No file was uploaded with this report
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-01-24 19:12:01 | No migration path for MONEY |
Previous Message | pgsql-bugs | 2003-01-24 17:37:06 | Bug #884: Schema access not inherited by functions declared SECURITY DEFINER |