[asterisk-bugs] [JIRA] (ASTERISK-24967) Problem support schema for pgsql on CEL

[Rodrigo Ramirez Norambuena (JIRA)]

Rodrigo Ramirez Norambuena created ASTERISK-24967:
-----------------------------------------------------

             Summary: Problem support schema for pgsql on CEL
                 Key: ASTERISK-24967
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24967
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: CEL/cel_pgsql
    Affects Versions: 13.3.2, 11.17.1
            Reporter: Rodrigo Ramirez Norambuena
            Severity: Minor


If do you have two table called with the same name for cel on distint schemas the log for fail failed.

The reason of the problem is query on get name columns for table.


The log is 

{code}
[Apr 15 01:55:45] DEBUG[12894]: cel_pgsql.c:330 pgsql_log: Inserting a CEL record: [INSERT INTO cel ("id","id","eventtype","eventtype","eventtime","eventtime","userdeftype","userdeftype","cid_name","cid_name","cid_num","cid_num","cid_ani","cid_ani","cid_rdnis","cid_rdnis","cid_dnid","cid_dnid","exten","exten","context","context","channame","channame","appname","appname","appdata","appdata","amaflags","amaflags","accountcode","accountcode","peeraccount","peeraccount","uniqueid","uniqueid","linkedid","linkedid","userfield","userfield","peer","peer") VALUES (DEFAULT,DEFAULT,'HANGUP','HANGUP','2015-04-15 04:55:45.002747','2015-04-15 04:55:45.002747','','','','','','','','','','','700','700','700','700','parkedcalls','parkedcalls','Console/dsp','Console/dsp','','','','',3,3,'','','','','1429073742.18','1429073742.18','1429073742.18','1429073742.18','','','','')].
[Apr 15 01:55:45] WARNING[12894]: cel_pgsql.c:355 pgsql_log: Failed to insert call detail record into database!

{code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)