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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Hartmut Goebel" <h(dot)goebel(at)goebel-consult(dot)de>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Date: 2010-06-03 13:43:55
Message-ID: 4C076B4B0200002500031E3A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Hartmut Goebel" <h(dot)goebel(at)goebel-consult(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hartmut Goebel 2010-06-03 14:00:49 Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Previous Message Hartmut Goebel 2010-06-03 13:26:55 BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading