>> ... 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?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com