http://qs321.pair.com?node_id=11115500


in reply to Re^2: Create parallel database handles or SQL statements for multi-threaded/process access to Postgres DB using DBI, DBD::Pg and Parallel::ForkManager
in thread Create parallel database handles or SQL statements for multi-threaded/process access to Postgres DB using DBI, DBD::Pg and Parallel::ForkManager

Hi again, maybe what you need is an no-op "upsert", implemented in Postgres with INSERT ON CONFLICT ?

Something like 

INSERT INTO myTable (foo, bar)
VALUES ('baz', 'qux') 
ON CONFLICT (foo) 
DO NOTHING;

[download]
... where foo is your column that has a unique key constraint.

Hope this helps!


The way forward always starts with a minimal test.

In Section Seekers of Perl Wisdom