Why is insert_update doing nothing in Kamailio db insert_update ?
As explained in the following article the design of "UPSERT" in PostgreSQL requires to be explicit about the constraint on which we accept to do update modification to Kamailio database framework/API would be required to expose which specific key constraint should be handled as an update
http://pgeoghegan.blogspot.com/2015/10/avoid-naming-constraint-directly-when...
In this first step, DO NOTHING is providing the simple feature to ignore error on insert when facing a constraint violation You can view, comment on, or merge this pull request online at:
https://github.com/kamailio/kamailio/pull/1039
-- Commit Summary --
* db_postgress: insert_update() with DO NOTHING
-- File Changes --
M src/modules/db_postgres/db_postgres.c (1) M src/modules/db_postgres/db_postgres.h (2) M src/modules/db_postgres/km_dbase.c (83) M src/modules/db_postgres/km_dbase.h (5) M src/modules/db_postgres/km_pg_con.c (4) M src/modules/db_postgres/pg_mod.c (4)
-- Patch Links --
https://github.com/kamailio/kamailio/pull/1039.patch https://github.com/kamailio/kamailio/pull/1039.diff