Request a Demo
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Attempting to delete excess rows from table with BATCH DELETE
Date
Msg-id CAKFQuwbudVTMKedFTuR+GXntRM=oZ=sCgyp1Ztg2=DUciuEbQA@mail.gmail.com
Whole thread Raw
In response to Attempting to delete excess rows from table with BATCH DELETE  (Gus Spier <gus.spier@gmail.com>)
Responses Re: Attempting to delete excess rows from table with BATCH DELETE
List pgsql-general
Tree view
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. I don’t see any mention of this here at least:


You’d have to move the logic to a proper client application that executes top-level commands.

David J.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Attempting to delete excess rows from table with BATCH DELETE
Next
From: Tom Lane
Date:
Subject: Re: Attempting to delete excess rows from table with BATCH DELETE