Marcelo (marsosa@tangobroker.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/200311:08:02 ART');
No file was uploaded with this report