Re: BUG #4901: Column name "window" breaks pg_dump/pg_restore - Mailing list pgsql-bugs

"Steve Purcell" <steve@sanityinc.com> writes:
> The DB schema for openx (openx.org) contains a table with a column called
> "window", which now causes a syntax error if unquoted.  pg_dump doesn't
> quote the column, so pg_restore/psql fail on the pg_dump output.

This is one of the reasons why it's recommended that you use the later
version's pg_dump to perform a cross-version dump and restore.  8.4's
pg_dump knows that "window" is a reserved word, but 8.3's could hardly
be expected to.

            regards, tom lane