Re: Cannot dump 8.4.8 database using later versions

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Cannot dump 8.4.8 database using later versions
Date: 2011-11-15 00:43:41
Message-ID: 4EC1B5BD.9010901@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andreas Lange 2011-11-15 08:36:18 Re: Cannot dump 8.4.8 database using later versions
Previous Message Josh Berkus 2011-11-14 23:20:03 Re: Cannot dump 8.4.8 database using later versions