Skip site navigation (1) Skip section navigation (2)

Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1
Date: 2002-04-17 23:57:55
Message-ID: 20020417235755.9660F475872@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Josh Berkus (josh(at)agliodbs(dot)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 created with 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


Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2002-04-18 00:08:44
Subject: Re: Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1
Previous:From: Matt OlsonDate: 2002-04-17 18:04:49
Subject: FATAL 2: XLogWrite: write request 3/39000000 is past end of log 3/38FC2000 (fwd)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group