Re: 8.0 -> 8.1 dump duplicate key problem? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.0 -> 8.1 dump duplicate key problem?
Date
Msg-id 12871.1131665401@sss.pgh.pa.us
Whole thread Raw
In response to 8.0 -> 8.1 dump duplicate key problem?  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: 8.0 -> 8.1 dump duplicate key problem?
List pgsql-hackers
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> When the dump gets to the point where the indexes/keys are built, the
> primary key fails to build due to duplicate key constraint failure.
> However, after dump is complete, I can create the p-key without any
> modification to the table and everything is fine.

That's pretty bizarre.  What's the datatype of the key column(s)?

Can you reduce it to a smaller test case, or perhaps send me the full
dump off-list?  (270m is a bit much for email, but web or ftp would
work ... also, presumably only the pkey column is needed to generate
the error ...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: generic builtin functions
Next
From: Olivier Thauvin
Date:
Subject: Module incompatibility detection between 8.0 and 8.1