The following bug has been logged online:
Bug reference: 5488
Logged by: Hartmut Goebel
Email address: h.goebel@goebel-consult.de
PostgreSQL version: 8.3 / 8.4
Operating system: all
Description: pg_dump does not quote column names -> pg_restore may
fail when upgrading
Details:
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.
This is a generic problem with pg_dump. Since it does not quote all column
names, pg_restore may fail whenever migrating to a new version.
Solution: pg_dump should quote *all* column-names, no matter if they are
keywords or not.
