:-) I see the error in the code now. I am fixing it, and maybe by the time you get this, it will be available at
http://svn.asteriskdocs.org/res_data The issue is that the Default SQL I changed code to a little while back has a SELECT *, but the code to read the fields is positional for that data_pgsql function Eventually, it will scan the row for the field name it needs, and this will make it more able to handle queries of this sort. Rob ----- Original Message ----- From: "Dmitri Pavlenkov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 16, 2004 2:57 PM Subject: [Asterisk-Dev] ast_data pgsql I think everything's setup correctly, and yet extension lookup is not working: iptel1=> \d extensions Table "public.extensions" Column | Type | Modifiers -------------+------------------------+--------------------------------- -------------- context | character varying(40) | not null default 'default'::character varying extension | character varying(20) | not null priority | integer | not null default 1 application | character varying(20) | not null args | character varying(100) | not null default ''::character varying Indexes: extensions_pkey primary key btree (context, extension, priority) iptel1=> select * from extensions iptel1-> ; context | extension | priority | application | args ---------+-----------+----------+-------------+----------------- dbtest | s | 1 | Festival | test successful im1 | 999 | 1 | Goto | dbtest|s|1 (2 rows) paska*CLI> show data pgsql status ======================================================================== ====== Database: [EMAIL PROTECTED]:5432 Queries Handled: EXTENSION_LOOKUP ID In/Out Reads Writes Deletes Status 1 In 8 0 0 Connected 0 days, 00:03:48 2 In 0 0 0 Connected 0 days, 00:03:48 3 In 0 0 0 Connected 0 days, 00:03:48 ======================================================================== ====== == Request: == ==== Packet Dump ==== == Query Type: SIP_FIND_USER == (100)Name = (STR)"dmitri" == ==== End of Packet Dump ==== == Response: == Request: == ==== Packet Dump ==== == Query Type: SIP_FIND_USER == (100)Name = (STR)"dmitri" == ==== End of Packet Dump ==== == Response: == Request: == ==== Packet Dump ==== == Query Type: SIP_FIND_USER == (100)Name = (STR)"dmitri" == ==== End of Packet Dump ==== == Response: == Request: == ==== Packet Dump ==== == Query Type: EXTENSION_LOOKUP == (114)Extension = (STR)"999" == (110)Context = (STR)"im1" == (115)Priority = (INT)1 == (134)Action = (INT)0 == ==== End of Packet Dump ==== == Response: == ==== Packet Dump ==== == Query Type: EXTENSION_LOOKUP == (20)DataSource = (STR)"pgsql" == (10)ErrorNumber = (INT)-9 == (11)ErrorMessage = (STR)"Not found" == ==== End of Packet Dump ==== == Request: == ==== Packet Dump ==== == Query Type: EXTENSION_LOOKUP == (114)Extension = (STR)"999" == (110)Context = (STR)"im1" == (115)Priority = (INT)1 == (134)Action = (INT)3 == ==== End of Packet Dump ==== == Response: == ==== Packet Dump ==== == Query Type: EXTENSION_LOOKUP == (20)DataSource = (STR)"pgsql" == (114)Extension = (STR)"im1" == (116)Application = (STR)"999" == (117)Arguments = (STR)"1" == (10)ErrorNumber = (INT)0 == (11)ErrorMessage = (STR)"OK" == ==== End of Packet Dump ==== == Request: == ==== Packet Dump ==== == Query Type: SIP_FIND_USER == (100)Name = (STR)"dmitri" == ==== End of Packet Dump ==== == Response: Dmitri Pavlenkov Technical Support Im1 Web Hosting _______________________________________________ Asterisk-Dev mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-dev To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-dev _______________________________________________ Asterisk-Dev mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-dev To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-dev
