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
