Re: Cannot dump 8.4.8 database using later versions

>> ... 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