From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: Gus Spier <gus.spier@gmail.com>,
        pgsql-general <pgsql-general@lists.postgresql.org>
Subject: Re: Attempting to delete excess rows from table with BATCH DELETE
In-reply-to: <CAKFQuwbudVTMKedFTuR+GXntRM=oZ=sCgyp1Ztg2=DUciuEbQA@mail.gmail.com>
References: <CAG8xnif_jmRYAGUvtoQNsHA8UqGRDkwuSffO55-3wGMLQArA8g@mail.gmail.com> <CAKFQuwbudVTMKedFTuR+GXntRM=oZ=sCgyp1Ztg2=DUciuEbQA@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Tue, 27 Jan 2026 20:39:03 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <729684.1769572320.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Tue, 27 Jan 2026 22:52:00 -0500
Message-ID: <729685.1769572320@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/729685.1769572320%40sss.pgh.pa.us>
Precedence: bulk

"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