The following bug has been logged online:
Bug reference: 5488Logged by: Hartmut GoebelEmail address: h(dot)goebel(at)goebel-consult(dot)dePostgreSQL version: 8.3 / 8.4Operating system: allDescription: pg_dump does not quote column names -> pg_restore mayfail when upgradingDetails:
If a 8.3 table contains a column named "window", the dump can not berestored into a 8.4 database. Reasons: a) "window" is a new keyword in 8.4b) pg_dump does not quote column names.
This is a generic problem with pg_dump. Since it does not quote all columnnames, pg_restore may fail whenever migrating to a new version.
Solution: pg_dump should quote *all* column-names, no matter if they arekeywords or not.