Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Date
Msg-id 4C076B4B0200002500031E3A@gw.wicourts.gov
Whole thread Raw
In response to BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading  ("Hartmut Goebel" <h.goebel@goebel-consult.de>)
Responses Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
List pgsql-bugs
"Hartmut Goebel" <h.goebel@goebel-consult.de> wrote:

> Description:        pg_dump does not quote column names ->
>                     pg_restore may fail when upgrading

> If a 8.3 table contains a column named "window", the dump can not
> be restored into a 8.4 database. Reasons: a) "window" is a new
> keyword in 8.4 b) pg_dump does not quote column names.

Note that the documentation recommends always running pg_dump using
the executable from the target version, not the source version.  Are
you using the pg_dump executable from 8.4?

-Kevin

pgsql-bugs by date:

Previous
From: "Hartmut Goebel"
Date:
Subject: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #5364: citext behavior when type not in public schema