[asterisk-bugs] [Asterisk 0019115]: Duplicate columns retireved for CEL/PostgreSQL & multiple schemas

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=19115 
====================================================================== 
Reported By:                amessina
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   19115
Category:                   CEL/cel_pgsql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.8.3.2 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2011-04-13 11:16 CDT
Last Modified:              2011-04-14 08:25 CDT
====================================================================== 
Summary:                    Duplicate columns retireved for CEL/PostgreSQL &
multiple schemas
Description: 
When connecting to PostgreSQL which has separate schemas (one per asterisk
host, in my case), but identical CEL tables, the following duplication of
columns occurs in Asterisk 1.8.3.2:

[Apr 12 13:44:50] ERROR[26844] cel_pgsql.c: Connection may have been
lost... attempting to reconnect.
[Apr 12 13:44:50] ERROR[26844] cel_pgsql.c: Connection reestablished.
[Apr 12 13:44:50] ERROR[26844] cel_pgsql.c: HARD ERROR!  Attempted
reconnection failed.  DROPPING CALL RECORD!
[Apr 12 13:44:50] ERROR[26844] cel_pgsql.c: Reason: ERROR:  column "id"
specified more than once
LINE 1: INSERT INTO chicago.cel ("id","id","eventtype","eventtype","...
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
related to          0016655 [patch] Double fields in SQL query
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-04-14 08:25 lmadsen        Severity                 major => minor      
======================================================================