"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