[OpenSIPS-Devel] [OpenSIPS/opensips] e3be4a: sipcapture: Fix primary key issues with PostgreSQL

Liviu Chircu liviu at opensips.org
Tue Aug 22 12:32:26 EDT 2017


  Branch: refs/heads/master
  Home:   https://github.com/OpenSIPS/opensips
  Commit: e3be4a13d36898998beafd4acf89ef0c2520749c
      https://github.com/OpenSIPS/opensips/commit/e3be4a13d36898998beafd4acf89ef0c2520749c
  Author: Liviu Chircu <liviu at opensips.org>
  Date:   2017-08-22 (Tue, 22 Aug 2017)

  Changed paths:
    M modules/sipcapture/sipcapture.c

  Log Message:
  -----------
  sipcapture: Fix primary key issues with PostgreSQL

Postgres handles zero-value auto-increment columns which are part of
composite primary keys differently than MySQL. Omitting the column
altogether from the INSERT statements rather than setting it to
zero leads to the expected behavior on both platforms
(i.e. "always try to insert a unique id").

Thanks to Jennifer Hashimoto for reporting and troubleshooting




More information about the Devel mailing list