R: Problem with stored procedure and nested transactions

2018-10-30 Thread p.pierotti
Thanks, I had already read it. What I cannot find is how to get the behavior I described, is there a way? Paolo Pierotti Viale Lombardia, 4 Lodi (LO) M: +39 328 9035851 P: +39 075 8556435 W: www.mmbb.it -Messaggio originale- Da: Adrian Klaver Inviato: martedì 30 ottobre 2018 15

Problem with stored procedure and nested transactions

2018-10-30 Thread p.pierotti
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 as $procedure$ begin p_cod := 'a'; begin