[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:                     closed
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:              
Resolution:                 no change required
Fixed in Version:           
====================================================================== 
Date Submitted:             2008-12-11 03:46 CST
Last Modified:              2008-12-15 12:09 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 )

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

---------------------------------------------------------------------- 
 (0096405) svnbot (reporter) - 2008-12-15 12:09
 http://bugs.digium.com/view.php?id=14058#c96405 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 164349

U   trunk/cdr/cdr_pgsql.c

------------------------------------------------------------------------
r164349 | tilghman | 2008-12-15 12:09:53 -0600 (Mon, 15 Dec 2008) | 4
lines

When querying for the structure of the CDR table, remove the schema, if it
exists.
(Closes issue http://bugs.digium.com/view.php?id=14058)

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=164349 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-12-15 12:09 svnbot         Note Added: 0096405                          
======================================================================