"Wang, Mary Y" <mary.y.wang@xxxxxxxxxx> writes: > Because the current value is 6818, during the restore process, it > complained about "duplicate key value violates unique constraint > "bug_pkey, because the value of bug_pk_seq for a insert has been > already been used. So what is the best way to resolve this? Should I > set the value for bug_pk_seq to be 1 in the beginning of the dump > file? > > Any suggestions? See the following article: http://tapoueh.org/articles/blog/_Resetting_sequences._All_of_them,_please!.html Regards, -- dim -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general