Re: Attempting to delete excess rows from table with BATCH DELETE

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Gus Spier <gus(dot)spier(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Attempting to delete excess rows from table with BATCH DELETE
Date: 2026-01-28 03:39:03
Message-ID: CAKFQuwbudVTMKedFTuR+GXntRM=oZ=sCgyp1Ztg2=DUciuEbQA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday, January 27, 2026, Gus Spier <gus(dot)spier(at)gmail(dot)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:

https://www.postgresql.org/docs/current/xproc.html

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

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2026-01-28 03:52:00 Re: Attempting to delete excess rows from table with BATCH DELETE
Previous Message David G. Johnston 2026-01-28 03:31:22 Re: Attempting to delete excess rows from table with BATCH DELETE