date/time compatible problems in 7.2

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?

Responses

Browse pgsql-hackers by date

  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.