[asterisk-bugs] [Asterisk 0014058]: cdr_pgsql does not work in asterisk 1.6.0.x

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=14058 
====================================================================== 
Reported By:                navis
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   14058
Category:                   CDR/cdr_pgsql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.0 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             2008-12-11 03:46 CST
Last Modified:              2008-12-12 02:28 CST
====================================================================== 
Summary:                    cdr_pgsql does not work in asterisk 1.6.0.x
Description: 
cdr_pgsql not write data to the table. Clearly, the request is not formed
correctly

[Dec 11 11:31:07] ERROR[7770]: cdr_pgsql.c:309 pgsql_log: cdr_pgsql:
Failed to insert call detail record into database!
[Dec 11 11:31:07] ERROR[7770]: cdr_pgsql.c:310 pgsql_log: cdr_pgsql:
Reason: ERROR:  syntax error at or near ")"
LINE 1: INSERT INTO public.cdr ) VALUES )

====================================================================== 

---------------------------------------------------------------------- 
 (0096302) navis (reporter) - 2008-12-12 02:28
 http://bugs.digium.com/view.php?id=14058#c96302 
---------------------------------------------------------------------- 
Thank you for a help.  A problem appeared in that in the file of
cdr_pgsql.conf the name of table was indicated in the format of
schema_name.table_name. In asterisk 1.4 it worked normally. I replaced
table=public.cdr on table=cdr and all works fine. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-12-12 02:28 navis          Note Added: 0096302                          
======================================================================