Transaction control in SECURITY DEFINER procedures

From: Chris Sterritt <chris(dot)sterritt(at)yobota(dot)xyz>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Transaction control in SECURITY DEFINER procedures
Date: 2020-07-07 11:13:42
Message-ID: c1ec321d-8dea-0fed-a40b-1ce18ef964b5@yobota.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Inder 2020-07-07 11:40:55 Basic question about structuring SQL
Previous Message Ishan Joshi 2020-07-07 10:50:46 Auto vacuum not reclaiming the space and disk utilization spike to 100%