"Wang, Mary Y" <mary.y.wang@xxxxxxxxxx> writes: > Actually I got that type of error during the restore process( I used pg_dump --insert option when doing the dump). But the interesting thing is that even though it flagged as an error, those rows of inserts still made to the table with the correct bug_id. So I'm not too worried about it right now. > I've always suspected that the database was inconsistent state. OK, what probably happened was that the data was loaded okay and then you got these errors from the commands that attempted to create unique indexes. So aside from the problem that your data is inconsistent, you now also lack indexes. You probably ought to see about fixing the duplications so that you can establish the indexes. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
