Postgres Pro
Downloads
Home   >   mailing lists

Re: procedures and transactions - Mailing list pgsql-general

From David G. Johnston
Subject Re: procedures and transactions
Date
Msg-id CAKFQuwYdbkOv3HAGo=heMDQB9zs5_31mK2FR05sYVHXmq4u+Pg@mail.gmail.com
Whole thread Raw
In response to procedures and transactions  (Rob Nikander <rob.nikander@gmail.com>)
Responses Re: procedures and transactions  (Rob Nikander <rob.nikander@gmail.com>)
List pgsql-general
Tree view
On Tuesday, February 19, 2019, Rob Nikander <rob.nikander@gmail.com> wrote:
 Are procedures not allowed to commit/rollback if they are called within in an outer transaction?


Also, I tried putting a `start transaction` command in the procedure. I got another error: `unsupported transaction command in PL/pgSQL`. Are procedures not allowed to start transactions? Or is there another command?


David J.

pgsql-general by date:

Previous
From: Rob Nikander
Date:
Subject: procedures and transactions
Next
From: Adrian Klaver
Date:
Subject: Re: procedures and transactions