date/time compatible problems in 7.2
От | Ruslan A Dautkhanov |
---|---|
Тема | date/time compatible problems in 7.2 |
Дата | |
Msg-id | 3C70B260.B8B13270@scn.ru обсуждение исходный текст |
Список | pgsql-hackers |
Hello, I has pg_dump my DB in 7.1.3 and try ro pg_restore it in 7.2 version. Almost all is clear, but restore of some tables generate messages like this: psql:/.../dbdump/.dbrestore.tmp:1624094: ERROR: copy: line 1, Bad timestamp external representation 'Fri 25 Jan 23:59:59 2002 KRAT' psql:/.../dbdump/.dbrestore.tmp:1624094: lost synchronization with server, resetting connection ....... And in a postmaster log I have for each pg_restore error like above: 2002-02-07 14:36:05 ERROR: copy: line 1, Bad timestamp external representation 'Wed 06 Feb 00:00:00 2002 KRAT' 2002-02-07 14:36:05 FATAL 1: Socket command type *** unknown ....... where *** is char in (1,2,3,7,8,-,/). What this mean? I can't upgrade PostgreSQL from 7.1.3 to 7.2 since following incompatibles exists: 1. Function time(datetime) don't exists in 7.2? SELECT time('now'); processed ok in 7.1.3, but 7.2 says: parser: parse error at or near "'". 2. CREATE TABLE akka (tm TIMESTAMP WITH TIME ZONE); SET datestyle TO postgresql,european; INSERTINTO akka VALUES ('akka'); INSERT INTO akka SELECT tm::text FROM akka; -- * Last SQL processedwell in 7.1.3, but in 7.2 didn't: ERROR: Bad timestamp external representation 'Thu 07 Feb 16:36:50.730499 2002 KRAT' I has tried to CREATE TABLE akka with timestamp(0) column, but this does not help. When I use WITHOUT TIME ZONE query(*) proceed good, but I can't use it since my pg_dump'ed DB saved with timezone info. Any ideas?
В списке pgsql-hackers по дате отправления: