Re: procedures and transactions

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rob Nikander <rob(dot)nikander(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: procedures and transactions
Date: 2019-02-19 20:38:55
Message-ID: CAKFQuwYdbkOv3HAGo=heMDQB9zs5_31mK2FR05sYVHXmq4u+Pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday, February 19, 2019, Rob Nikander <rob(dot)nikander(at)gmail(dot)com> wrote:

> Are procedures not allowed to commit/rollback if they are called within
> in an outer transaction?
>

https://www.postgresql.org/docs/11/sql-call.html

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?
>

https://www.postgresql.org/docs/11/plpgsql-transactions.html

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-02-19 20:41:03 Re: procedures and transactions
Previous Message Rob Nikander 2019-02-19 20:31:16 procedures and transactions