"David G. Johnston" <[email protected]> writes:
> On Tuesday, January 27, 2026, Gus Spier <[email protected]> wrote:
>> I write a procedure to accomplish all this work but it persists in
>> returning a error to the effect that a COMMIT is not valid in a block
>> tht tries to DELETE data.
> Haven’t tested to be sure but this doesn’t seem like a community edition
> limitation.
Yeah, you can definitely do that in standard Postgres (at least since
we invented procedures). Sounds like Aurora is behind the times.
I know that their storage engine is fundamentally different from ours;
perhaps it has problems with this idea.
> You’d have to move the logic to a proper client application that executes
> top-level commands.
Yup.
regards, tom lane
