"Hartmut Goebel" <h.goe...@goebel-consult.de> writes: > 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 one of the cases where it's helpful to use the newer version's pg_dump. > Solution: pg_dump should quote *all* column-names, no matter if they are > keywords or not. That was considered and rejected long ago. Readability of the dump script is something that we put a nonzero value on. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs