Re: Attempting to delete excess rows from table with BATCH DELETE - Mailing list pgsql-general

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tuesday, January 27, 2026, Gus Spier <gus.spier@gmail.com> 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