On Tuesday, January 27, 2026, Gus Spier <[email protected]> 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.
