Request a Demo
Home   >   mailing lists

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

From Tom Lane
Subject Re: Attempting to delete excess rows from table with BATCH DELETE
Date
Msg-id 731539.1769573201@sss.pgh.pa.us
Whole thread Raw
In response to Re: Attempting to delete excess rows from table with BATCH DELETE  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Attempting to delete excess rows from table with BATCH DELETE
List pgsql-general
Tree view 
Ron Johnson <ronljohnsonjr@gmail.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

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Attempting to delete excess rows from table with BATCH DELETE
Next
From: Olivier Gautherot
Date:
Subject: Re: Attempting to delete excess rows from table with BATCH DELETE