On Wed, Jul 15, 2020 at 10:52:04AM +0100, James King wrote:
> Hi Bruce,
>
> Thanks for taking a look at this.
>
> This is really about making a limitation obvious. In other parts of the
> documentation, like table partitioning, limitations are really spelled out,
> good solid health warnings for
n the website:
> >
> > Page: https://www.postgresql.org/docs/12/plpgsql-transactions.html
> > Description:
> >
> > Hello,
> >
> > We are looking to use transaction management and have run into a
> limitation
> > when the procedure is sec
On Tue, Jul 7, 2020 at 10:46:59AM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/12/plpgsql-transactions.html
> Description:
>
> Hello,
>
> We are looking to use transac
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/plpgsql-transactions.html
Description:
Hello,
We are looking to use transaction management and have run into a limitation
when the procedure is security definer. There doesn't appe
On Mon, Dec 30, 2019 at 10:15:35AM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html
> Description:
>
> It's worth mentioning that "Tran
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html
Description:
It's worth mentioning that "Transaction Management" requires "Autocommit" to
be ON. Otherwise you get an error.
Hello, Bruce. (We met at the OUGN conference last March on the Oslo-Kiel
ferry.) Thanks for your reply.
1. About AUTOCOMMIT
It’s very hard to get a clear account of what AUTOCOMMIT really is. So consider
the example from the docs section that I cited, and run these psql commands at
its prompt
On Mon, Sep 30, 2019 at 04:11:47AM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html
> Description:
>
> This chapter fails to state:
>
> (1) If a PL/pgSQL procedure issue
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html
Description:
This chapter fails to state:
(1) If a PL/pgSQL procedure issues "commit" then it must be called with
AUTOCOMMIT set to On. This is counter-intuitive
