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

"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