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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Gus Spier <gus(dot)spier(at)gmail(dot)com>, 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 04:06:41
Message-ID: 731539.1769573201@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron Johnson <ronljohnsonjr(at)gmail(dot)com> writes:
> Hmm. Must have been START TRANSACTION which I remember causing issues in DO
> blocks.

Too lazy to test, but I think we might reject that. The normal rule
in a procedure is that the next command after a COMMIT automatically
starts a new transaction, so you don't need an explicit START.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Olivier Gautherot 2026-01-28 07:32:03 Re: Attempting to delete excess rows from table with BATCH DELETE
Previous Message Ron Johnson 2026-01-28 04:03:46 Re: Attempting to delete excess rows from table with BATCH DELETE