MIME-Version: 1.0
In-Reply-To: <CAG8xnif_jmRYAGUvtoQNsHA8UqGRDkwuSffO55-3wGMLQArA8g@mail.gmail.com>
References: <CAG8xnif_jmRYAGUvtoQNsHA8UqGRDkwuSffO55-3wGMLQArA8g@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 27 Jan 2026 20:39:03 -0700
Message-ID: <CAKFQuwbudVTMKedFTuR+GXntRM=oZ=sCgyp1Ztg2=DUciuEbQA@mail.gmail.com>
Subject: Re: Attempting to delete excess rows from table with BATCH DELETE
To: Gus Spier <gus.spier@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004f148d06496a7b5c"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbudVTMKedFTuR%2BGXntRM%3DoZ%3DsCgyp1Ztg2%3DDUciuEbQA%40mail.gmail.com>
Precedence: bulk

--0000000000004f148d06496a7b5c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=99t tested to be sure but this doesn=E2=80=99t seem like a comm=
unity edition
limitation. I don=E2=80=99t see any mention of this here at least:

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

You=E2=80=99d have to move the logic to a proper client application that ex=
ecutes
top-level commands.

David J.

--0000000000004f148d06496a7b5c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tuesday, January 27, 2026, Gus Spier &lt;<a href=3D"mailto:gus.spier@gma=
il.com">gus.spier@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex=
"><br>
I write a procedure to accomplish all this work but it persists in<br>
returning a error to the effect that a COMMIT is not valid in a block<br>
tht tries to DELETE data.<br>
</blockquote><div><br></div><div>Haven=E2=80=99t tested to be sure but this=
 doesn=E2=80=99t seem like a community edition limitation. I don=E2=80=99t =
see any mention of this here at least:</div><div><br></div><div><a href=3D"=
https://www.postgresql.org/docs/current/xproc.html">https://www.postgresql.=
org/docs/current/xproc.html</a><br></div><div><br></div><div>You=E2=80=99d =
have to move the logic to a proper client application that executes top-lev=
el commands.</div><div><br></div><div>David J.</div><div><br></div>

--0000000000004f148d06496a7b5c--