| From: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 8.0 -> 8.1 dump duplicate key problem? |
| Date: | 2005-11-11 06:30:42 |
| Message-ID: | Pine.LNX.4.44.0511110721300.26817-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 10 Nov 2005, Tom Lane wrote:
> > 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.
>
> That's pretty bizarre. What's the datatype of the key column(s)?
There was one guy on IRC that had the same problem. We didn't get that
much info about it and suggested that he check the original database for
corruption (rebuilding indexes) to make sure it's in a proper state.
Either this is the same guy or/and we might have a bigger problem. The guy
on irc also had an integer PK.
--
/Dennis Björklund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fredrik Olsson | 2005-11-11 07:36:05 | Re: Underlying view columns? |
| Previous Message | Bruno Wolff III | 2005-11-11 05:56:09 | Re: Comments from a Firebird user via Borland |