On 2011-11-15 v46 01.43, Josh Berkus wrote:
... somehow the query to dump the sequences is getting mangled. Any
clue how?
Seems you have a sequence called "new"; seems we don't handle that
well.
So, tested this some more. For some reason, 8.4's pg_dump would
recognize NEW as a reserved word and quote it before dumping. 9.0 and
later pg_dump does not. Any ideas?
Funny, I was about to write a bug report regarding this...
'new' was reserved in 8.4, but not in 9.0/9.1. It's reserved in SQL
1999, 2003 & 2008.
(http://www.postgresql.org/docs/9.1/interactive/sql-keywords-appendix.html)
You can have a 8.4 DB with a 'new' column and dump it with 8.4 tools.
You can have a 9.x DB with a 'new' column and dump it with 9.x tools.
However, it fails when you use 9.x pg_dump against 8.4 with a 'new' column.
//Andreas
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
