[SR-Users] cleanup database

[Alex Balashov]

On 08/27/2013 11:49 AM, Sebastian Grosse wrote:

> The problem is, that with a trigger for a table I can't delete rows from
> the same table:
> ERROR 1442: Can’t update table ‘sip_capture′ in stored function/trigger
> because it is already used by statement which invoked this

Oh.  Well, that's primitive.  I didn't realise MySQL has that 
limitation.  I only use Postgres and it is certainly quite possible there...

-- 
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/