I have a strange issue (postgres 8.4) trying to insert old rows back
into the s_tbls table. A check on the primary key (n_id) between
s_tbl_import and s_tbls yields no matches, yet the index on s_tbls.n_id
yields an error when attempting to insert:
= select n_id from s_tbl_import where n_id IN (
2011/10/6 Rory Campbell-Lange r...@campbell-lange.net
I have a strange issue (postgres 8.4) trying to insert old rows back
into the s_tbls table. A check on the primary key (n_id) between
s_tbl_import and s_tbls yields no matches, yet the index on s_tbls.n_id
yields an error when attempting
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.