Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1 - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1
Date
Msg-id 20020417235755.9660F475872@postgresql.org
Whole thread Raw
Responses Re: Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Josh Berkus (josh@agliodbs.com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
PG_DUMP Files do not restore on PostgreSQL 7.2.1

Long Description
This bug was originally reported by Phillip Jourdan on the NOVICE list.

It seems that PostgreSQL 7.2.1 is no longer recognizing \N as NULL for COPY commands.  As a result, pg_dump files
createdwith earlier versions of PostgreSQL will not restore to PostgreSQL 7.2.1 using the psql database < file.pg_dump
method. This has left several upgraders unable to restore their databases after an upgrade.
 

-Josh Berkus

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Matt Olson
Date:
Subject: FATAL 2: XLogWrite: write request 3/39000000 is past end of log 3/38FC2000 (fwd)
Next
From: Bruce Momjian
Date:
Subject: Re: Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1