<div dir="ltr">Hello Guys,
<div><div style="font-size:12.8000001907349px">I'm using dispatcher module with postgres database. The ds_select_dst function in the script file is used like this:</div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">ds_select_dst("$(var(ds_set){<a href="http://s.int/" target="_blank">s.int</a>})","8");<br></div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">that is, using "8" algorithm (first entry in set is chosen) because I need to use always the same destination in the set while it is up. If not, then the backup destination (next in the set) is used.</div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">The problem I've found is that when the sets are read from database (opensips restart or fifo ds_reload), the select hasn't a "order" directive in the sql statement, so the order is defined depending of the last tuple update. The postgres log shows this when doing a fifo ds_reload:</div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">2015-08-14 11:36:53 ART [23684]: [1-1] LOG: duration: 0.582 ms statement: select setid,destination,socket,state,weight,attrs from sbc.dispatcher<br></div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">And the syslog & debug=6 shows:</div><div style="font-size:12.8000001907349px"><br></div><div><span style="font-size:12.8000001907349px">DBG:db_postgres:db_postgres_submit_query: 0x7f4344987010 PQsendQuery(select setid,destination,socket,state,weight,attrs from sbc.dispatcher )</span><br></div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">So, any sql update in any column will change the order in the set because we don't have the "order by priority" for example.</div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">Is there any way to use the weight, priority or the id to have a fixed order in the set(s) destination?</div></div><div><br></div><div><br></div><div>Many Thanks!</div><div>Federico</div></div>