Re: execute a procedure from another procudure?

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Pepe TD Vo <pepevo(at)yahoo(dot)com>, Pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: execute a procedure from another procudure?
Date: 2018-11-08 08:59:42
Message-ID: 1a281089-1cb6-7e69-645a-050505a45a88@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 07/11/2018 15:12, Pepe TD Vo wrote:
> and I converted it to Postgres Pragma autonomous_transaction and I'm not
> sure its corrected but it didn't give any error.

PostgreSQL does not support autonomous transactions. Some people use
dblink as a workaround.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2018-11-08 09:16:06 Re: query can't merge into table of the other schema
Previous Message Pepe TD Vo 2018-11-07 22:52:01 Re: query can't merge into table of the other schema