Re: Transaction control in SECURITY DEFINER procedures

2020-07-22 Thread Bruce Momjian
On Tue, Jul 7, 2020 at 12:13:42PM +0100, Chris Sterritt wrote: > 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

Transaction control in SECURITY DEFINER procedures

2020-07-07 Thread Chris Sterritt
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 rele