Re: Strange primary key error on insertion - Mailing list pgsql-general

On 06/10/11, Filip Rembiałkowski (plk.zuber@gmail.com) wrote:
> 2011/10/6 Rory Campbell-Lange <rory@campbell-lange.net>
> > => insert into s_tbls (select * from s_tbl_import);
> >
> >    ERROR:  duplicate key value violates unique constraint "s_tbls_pkey"
> >
> >
> Looks like you had duplicates in s_tbl_import. Try this:
> SELECT * FROM s_tbl_import WHERE n_id IN (
>     SELECT n_id from s_tbl_import group by n_id HAVING count(*)>1
> );

Hi Filip

You were right! Thanks for catching my silly error.

Rory