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


in reply to Re^4: 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,

Add to your DB schema:

unique key all_cols_uk (every, column, name, in, the, table),

https://www.w3schools.com/sql/sql_unique.asp

Hope this helps!


The way forward always starts with a minimal test.
  • Comment on Re^5: Create parallel database handles or SQL statements for multi-threaded/process access to Postgres DB using DBI, DBD::Pg and Parallel::ForkManager
  • Download Code

Replies are listed 'Best First'.
Re^6: Create parallel database handles or SQL statements for multi-threaded/process access to Postgres DB using DBI, DBD::Pg and Parallel::ForkManager
by erix (Parson) on May 08, 2020 at 18:52 UTC

    On that page postgres is not mentioned; in postgresql-SQL, that'd become, I think:

    create unique index all_cols_uk on tablename (every, column, name, in, + the, table) ;

    See: CREATE INDEX in the fine manual