Postgres Pro
Downloads
Home   >   mailing lists

Re: execute a procedure from another procudure? - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: execute a procedure from another procudure?
Date
Msg-id 1a281089-1cb6-7e69-645a-050505a45a88@2ndquadrant.com
Whole thread Raw
In response to execute a procedure from another procudure?  (Pepe TD Vo <pepevo@yahoo.com>)
Responses Re: execute a procedure from another procudure?  (Pepe TD Vo <pepevo@yahoo.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: Re: query can't merge into table of the other schema
Next
From: Guillaume Lelarge
Date:
Subject: Re: query can't merge into table of the other schema