[OpenSIPS-Users] Location table info

[Bogdan-Andrei Iancu]

It is DB related issue, why do you want to do it from opensips ? simply 
put a trigger.

Regards,
Bogdan

Premalatha Kuppan wrote:
> Thats what i was thinking too...i dono whether it can be done at 
> opensips.cfg file level or code level ?
>
> On Mon, Aug 2, 2010 at 2:38 AM, Bogdan-Andrei Iancu 
> <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> wrote:
>
>     Hi Premalatha,
>
>     What about using DB triggers on DELETE event (on location table) to
>     delete the record in your table also ?
>
>     Regards,
>     Bogdan
>
>     Premalatha Kuppan wrote:
>     > Hi Bogdan,
>     >
>     > I have a question on location table.
>     >
>     > I have added a table to OPENSIPS DB. This table entry should get
>     > deleted when the corresponding entries in location table is deleted.
>     >
>     > say for example: user xxxx is registerd and its info is stored in
>     > location table. When it crashes, entries gets deleted from location
>     > table, when this entry isn't found i have to delete that
>     > corresponding entry from my created table.
>     >
>     > How to do this ?
>     >
>     > Thanks,
>     > Premalatha
>     >
>     ------------------------------------------------------------------------
>     >
>     > _______________________________________________
>     > Users mailing list
>     > Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>     >
>
>
>     --
>     Bogdan-Andrei Iancu
>     OpenSIPS Bootcamp
>     20 - 24 September 2010, Frankfurt, Germany
>     www.voice-system.ro <http://www.voice-system.ro>
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
OpenSIPS Bootcamp
20 - 24 September 2010, Frankfurt, Germany
www.voice-system.ro