Re: [GENERAL] Duplicate Key violation on dump&reload using pg_restore

2008-04-04 Thread Markus Wollny
Tom Lane wrote: > Maybe there actually is a duplicate key in the source DB --- have you > checked? There were some bugs in early 8.2.x releases that could > possibly allow that to happen. Thanks, I was hoping there would be an easy explanation like that. I guess I'll have to do a little reading

Re: [GENERAL] Duplicate Key violation on dump&reload using pg_restore

2008-04-04 Thread Markus Wollny
Quick update: Seems like removing that tuple has solved the issue, dump and import of that table went fine, everything is where is should be - but there shouldn't have been an issue there in the first place however, with the primary key constraint present in the source database. I'm still curiou

Re: [GENERAL] Duplicate Key violation on dump&reload using pg_restore

2008-04-04 Thread Tom Lane
"Markus Wollny" <[EMAIL PROTECTED]> writes: > I'm currently trying to migrate one of our databases from PostgreSQL 8.2.4 to > PostgreSQL 8.3.1. I have worked around the Tsearch2 migration (we used the > contrib module) without too much hassle, but find myself stuck at an > unexpected point - I g

[GENERAL] Duplicate Key violation on dump&reload using pg_restore

2008-04-04 Thread Markus Wollny
Hello! I'm currently trying to migrate one of our databases from PostgreSQL 8.2.4 to PostgreSQL 8.3.1. I have worked around the Tsearch2 migration (we used the contrib module) without too much hassle, but find myself stuck at an unexpected point - I get a duplicate key violation for the primar