in reply to Re^3: 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
Thank you for your suggestion.
I realise I probably did not explain fully enough my goal.
Let's say I have 10 columns in my table (excluding the PK).
I only want to store a data row into the table if the combination of all 10 values is a unique combination set.
Example with a 3 column table:
I realise I probably did not explain fully enough my goal.
Let's say I have 10 columns in my table (excluding the PK).
I only want to store a data row into the table if the combination of all 10 values is a unique combination set.
Example with a 3 column table:
INSERT Row 1: A,A,A <== OK! Value set unique INSERT Row 2: A,D,A <== OK! Value set unique INSERT Row 3: D,T,G <== OK! Value set unique INSERT Row 4: D,A,A <== OK! Value set unique INSERT Row 5: A,D,A <== COLLISION with Row 2! Set not unique; skip IN +SERT
In Section
Seekers of Perl Wisdom