Обсуждение: Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1

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@postgresql.org wrote:
> 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

I just talked to Josh and he retracts this bug report.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026