Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? - Mailing list pgsql-general

From Luca Ferrari
Subject Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
Date
Msg-id CAKoxK+6BvHHKaS1GVE6Meyf-U7CYNkGYWHknaKs=6-+YN5krXQ@mail.gmail.com
Whole thread Raw
In response to Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?  (Benedict Holland <benedict.m.holland@gmail.com>)
List pgsql-general
On Wed, Aug 7, 2019 at 11:36 PM Benedict Holland
<benedict.m.holland@gmail.com> wrote:
>
> Also, I have never seen a rollback at the start of a proc. A pure hypothetical is that it is doing nothing or
definitelynot what you think it is.
 

That's my point, thanks.

Luca



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Guidance needed on an alternative take on common prefix SQL
Next
From: Thomas Kellerer
Date:
Subject: lead() with arrays - strange behaviour