Search Postgresql Archives

Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
From: Luca Ferrari <fluca1978@xxxxxxxxx>
Date: Thu, 8 Aug 2019 10:19:59 +0200
Cc: "David G. Johnston" <david.g.johnston@xxxxxxxxx>, Bryn Llewellyn <bryn@xxxxxxxxxxxx>, Adrian Klaver <adrian.klaver@xxxxxxxxxxx>, pgsql-general list <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAD+mzozOQ3==74Gup098D_KJcf3SdrNnLrGwvj12mF9kRnRXiw@mail.gmail.com>
References: <9E141BBF-29E8-4825-9E7D-5F96BAD4365B@yugabyte.com> <c864806b-6df5-5a28-4969-35f9ae36e360@aklaver.com> <EE6D19C1-1CA6-424B-91AC-63A1A64A5921@yugabyte.com> <CAKoxK+4=G+1Fb_0Yu-Zbrz8WsyiFDKd4EphkYYusavPtF_DSUQ@mail.gmail.com> <EB82F064-FCB4-4101-A511-8ACD7AA5BF76@yugabyte.com> <CAKoxK+5_p-xMFhi2=7L10xZiDrjVTEN28HZbUBr1-aLz7UT=pA@mail.gmail.com> <CAKFQuwbpgKx-m-NaWAYOsJ5syie8vJ4Yj2cPOiWXV4ADb7Nc+Q@mail.gmail.com> <CAD+mzozOQ3==74Gup098D_KJcf3SdrNnLrGwvj12mF9kRnRXiw@mail.gmail.com>

On Wed, Aug 7, 2019 at 11:36 PM Benedict Holland
<benedict.m.holland@xxxxxxxxx> wrote:
>
> Also, I have never seen a rollback at the start of a proc. A pure hypothetical is that it is doing nothing or definitely not what you think it is.

That's my point, thanks.

Luca

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
  - From: Bryn Llewellyn
- Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
  - From: Adrian Klaver
- Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
  - From: Bryn Llewellyn
- Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
  - From: Luca Ferrari
- Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
  - From: Bryn Llewellyn
- Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
  - From: Luca Ferrari
- Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
  - From: David G. Johnston
- Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
  - From: Benedict Holland

Prev by Date: Re: Guidance needed on an alternative take on common prefix SQL
Next by Date: lead() with arrays - strange behaviour
Previous by thread: Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
Next by thread: Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]