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

Liviu Chircu liviu at opensips.org
Fri Sep 1 06:24:29 EDT 2017


  Branch: refs/heads/2.3
  Home:   https://github.com/OpenSIPS/opensips
  Commit: 935fd57e6c4b71beb5f28c56781e1ba9957c8997
      https://github.com/OpenSIPS/opensips/commit/935fd57e6c4b71beb5f28c56781e1ba9957c8997
  Author: Liviu Chircu <liviu at opensips.org>
  Date:   2017-09-01 (Fri, 01 Sep 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

(cherry picked from commit e3be4a13d36898998beafd4acf89ef0c2520749c)




More information about the Devel mailing list