[sr-dev] broken constraint on postgres schema for location table (usrloc)

[E. Schmidbauer]

Hello,
We noticed the constraint in
   utils/kamctl/postgres/usrloc-create.sql
is broken, causing only 1 user location ever to be saved because server_id
is always 1 and connection_id is always -1

We had to remove the constraint to fix the issue.
This is the specific line inside the CREATE TABLE

    CONSTRAINT location_connection_idx UNIQUE (server_id, connection_id)

Thanks,
Emmanuel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20160323/e04bdb7c/attachment.html>