[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