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?