[asterisk-bugs] [Asterisk 0012576]: PgSQL Search on SIP table for SIP Channel

[noreply at bugs.digium.com]

The following issue has been RESOLVED. 
====================================================================== 
http://bugs.digium.com/view.php?id=12576 
====================================================================== 
Reported By:                elbriga
Assigned To:                file
====================================================================== 
Project:                    Asterisk
Issue ID:                   12576
Category:                   Resources/res_config_pgsql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     resolved
Asterisk Version:           1.4.19 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
Resolution:                 no change required
Fixed in Version:           
====================================================================== 
Date Submitted:             05-02-2008 20:32 CDT
Last Modified:              05-05-2008 09:09 CDT
====================================================================== 
Summary:                    PgSQL Search on SIP table for SIP Channel
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.
====================================================================== 

---------------------------------------------------------------------- 
 file - 05-05-08 09:09  
---------------------------------------------------------------------- 
This is not a bug, it is the way the devicestate core currently works. It
may be improved in the future. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
05-05-08 09:09  file           Status                   new => resolved     
05-05-08 09:09  file           Resolution               open => no change
required
05-05-08 09:09  file           Assigned To               => file            
05-05-08 09:09  file           Note Added: 0086405                          
======================================================================