The documentation for CREATE PROCEDURE informs us "A SECURITY DEFINER
procedure
cannot execute transaction control statements (for example, COMMIT
and ROLLBACK
, depending
on the language)."
Can anyone let me know why this is so and are there any plans to remove this restriction in future releases?
Regards,
Chris Sterritt