Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot dump 8.4.8 database using later versions - Mailing list pgsql-bugs

From Josh Berkus
Subject Re: Cannot dump 8.4.8 database using later versions
Date
Msg-id 4EC1B5BD.9010901@agliodbs.com
Whole thread Raw
In response to Re: Cannot dump 8.4.8 database using later versions  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Cannot dump 8.4.8 database using later versions  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: Cannot dump 8.4.8 database using later versions  (Andreas Lange <andreas.lange@liu.se>)
List pgsql-bugs
Tree view 
>> ... 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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Cannot dump 8.4.8 database using later versions
Next
From: "David Pinheiro"
Date:
Subject: BUG #6292: java.sql.PreparedStatement.setNull() throws PSQLException