Hello, Looks like the issue is not in multi statements in one request. Manually creating DB schema helped and everything started up. I will continue testing
Also in code I see such construction: > switch_cache_db_execute_sql(dbh, "begin;delete from channels where > hostname='';delete from channels where hostname='';commit;", &err); Anyone can explain why to do such delete twice and in transaction? Thanks. Saturday, November 21, 2009 1:41:06 PM, you wrote: MT> Hello Folks, MT> I'm interesting in completely moving away from sqlite and use MT> postgresql everywhere including core ( switch_core.c ) MT> All other applications can use odbc without issues (sofia, limit, MT> fifo etc), but as I see in core only sqlite3 supported. MT> I correctly set 'core-db-dsn' parameter, but looks like the problem MT> that latest psqlodbc_08_04_0100 don't support multiple statements in MT> one request that is often used in switch_core_sqldb.c: >> sql = switch_mprintf( >> "update channels set uuid='%q' where uuid='%q' and hostname='%q';" >> "update calls set caller_uuid='%q' where caller_uuid='%q' and >> hostname='%q';" >> "update calls set callee_uuid='%q' where callee_uuid='%q' and >> hostname='%q'", >> switch_event_get_header_nil(event, "unique-id"), >> ... SKIP ... MT> So, does anyone have any clue how to us postgresql in the FS core? MT> Thanks. MT> -- MT> Mike Tkachuk -- Mike Tkachuk _______________________________________________ FreeSWITCH-users mailing list [email protected] http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
