The following bug has been logged online: Bug reference: 5488 Logged by: Hartmut Goebel Email address: h.goe...@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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
