On 06/10/11, Filip RembiaĆkowski (plk.zu...@gmail.com) wrote: > 2011/10/6 Rory Campbell-Lange <r...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general