From: | Ruslan A Dautkhanov <rusland(at)scn(dot)ru> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | date/time compatible problems in 7.2 |
Date: | 2002-02-18 07:50:56 |
Message-ID: | 3C70B260.B8B13270@scn.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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;
INSERT INTO akka VALUES ('akka');
INSERT INTO akka SELECT tm::text FROM akka; -- *
Last SQL processed well 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2002-02-18 09:44:37 | [Fwd: Re: Errors with building PG 7.2 on Mandrake 8.0] |
Previous Message | Nicolas Bazin | 2002-02-18 06:09:31 | Fw: cross-platform packaging in native format. |