Bug #885: Trouble with timestamps after vacuuming

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

Responses

Browse pgsql-bugs by date

  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