[OpenSIPS-Devel] [ opensips-Bugs-2819246 ] opensipsctl add broken for Postgres

[SourceForge.net]

Bugs item #2819246, was opened at 2009-07-09 23:59
Message generated for change (Comment added) made by iulia_bublea
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2819246&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: tools
Group: trunk
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: Gordon Ross (gordonross)
Assigned to: Iulia Bublea (iulia_bublea)
Summary: opensipsctl add broken for Postgres

Initial Comment:
With the latest code from the trunk, if you try and add a user/subscriber to the DB (when using the Postgres backend) you are unable to. You get the message that the entry already exists in aliases. Yet the aliases tables are empty. Reverting back to the 1.5.1 source tarball, and things work fine.

I suspect that the error is in the way the code is handling the return from the count() SQL function which is used to ascertain is the entry already exists.

----------------------------------------------------------------------

>Comment By: Iulia Bublea (iulia_bublea)
Date: 2009-07-13 19:05

Message:
Problem encountered due to the use of concat function, which is not
Postgres compatible. Issue was fixed

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2819246&group_id=232389