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

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1
Date: 2002-04-18 00:08:44
Message-ID: 200204180008.g3I08ij29901@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org wrote:
> 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

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

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

In response to

pgsql-bugs by date

Next:From: Warwick HunterDate: 2002-04-18 00:20:22
Subject: lo_unlink documentation error
Previous:From: pgsql-bugsDate: 2002-04-17 23:57:55
Subject: Bug #634: PG_DUMP Files do not restore on PostgreSQL 7.2.1

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