Summary:ASTERISK-11964: PgSQL Search on SIP table for SIP Channel
Reporter:Gabriel Ortiz Lour (elbriga)Labels:
Date Opened:2008-05-02 20:32:58Date Closed:2011-06-07 14:08:16
Versions:Frequency of
Description:My Asterisk 1.4.19 instalation is using teh PostgreSQL RealTime, and it tries to do a select on the SIP table looking for a SIP channel. I remebmber have seen this issue on the MySQL driver some time ago.

Is this a bug?

With debug on it shows:
SELECT * FROM sip WHERE name = 'cac01-0827e8d0' AND host = 'dynamic'

It happens after I register the "cac01" account and call the "6000" extension, (statically) configured for playing MOH.
Comments:By: Joshua C. Colp (jcolp) 2008-05-05 09:09:52

This is not a bug, it is the way the devicestate core currently works. It may be improved in the future.