OK, have done. Issue ID 0015963. Steve Hindmarch BT Design
> -----Original Message----- > From: [email protected] [mailto:asterisk-users- > [email protected]] On Behalf Of Tilghman Lesher > Sent: 24 September 2009 15:11 > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: Re: [asterisk-users] Error When Using Postgresql Schema > WithRealtime Sip > > On Thursday 24 September 2009 05:06:02 [email protected] wrote: > > I have investigated further and found that it is a bug in ODBC, not > > Asterisk. The SQLColumns function, which asterisk uses to describe > the > > table, does not return any columns when the table name includes the > > schema specification. You can show this by using isql to do "help > table" > > which returns info about all the columns, and then "help > public.table" > > which returns nothing. As chan_sip seems to be the only application > that > > tests the structure of the table before writing to it this is why > > REGISTER fails. > > > > When I have time I will chase up ODBC and see if the issue is tracked > > there. Do you still want me to raise it as an issue on bugtracker? > > Yes, I want you to raise this on the bugtracker, and no, this is not a > bug > in ODBC, but a deficiency in my code. Since you tracked this down to > the > code in res_odbc.c, I might as well tell you that the first two NULL > sets of > arguments (NULL, 0) are for specifying the catalog and schema, > respectively, > of the database table, and it is because I never bothered parsing the > schema > out of the tablename that this does not work. > > -- > Tilghman Lesher > Digium, Inc. | Senior Software Developer > twitter: Corydon76 | IRC: Corydon76-dig (Freenode) > Check us out at: www.digium.com & www.asterisk.org > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > AstriCon 2009 - October 13 - 15 Phoenix, Arizona > Register Now: http://www.astricon.net > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
