Re: Problem with stored procedure and nested transactions

2018-11-03 Thread Peter Eisentraut
On 30/10/2018 15:03, p.piero...@mmbb.it wrote: > I thought that the “BEGIN/END” block was used to create new transactions > and that each of them could be managed individually. In PL/pgSQL, BEGIN/END just create syntactic blocks, they don't manage transactions. COMMIT and ROLLBACK manage

Re: Problem with stored procedure and nested transactions

2018-10-30 Thread Adrian Klaver
On 10/30/18 7:03 AM, p.piero...@mmbb.it wrote: Hi everyone, I have problems with stored procedures introduced in version 11. I do not understand how to create a nested transaction, in this semplified example: *create**or**replace**procedure*tst_prc(*inout*p_cod *text*) *language*plpgsql