27 Aug
2013
27 Aug
'13
11:49 a.m.
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/