Bug #885: Trouble with timestamps after vacuuming
От | pgsql-bugs@postgresql.org |
---|---|
Тема | Bug #885: Trouble with timestamps after vacuuming |
Дата | |
Msg-id | 20030124190753.6916A47723B@postgresql.org обсуждение исходный текст |
Ответы |
Re: Bug #885: Trouble with timestamps after vacuuming
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: