Re: Function for Exception Logging - Mailing list pgsql-general

From Alexey Bashtanov
Subject Re: Function for Exception Logging
Date
Msg-id 7f8ac4f2-4ddb-1566-e0b4-3c083252d073@imap.cc
Whole thread Raw
In response to Re: Function for Exception Logging  (Tony Shelver <tshelver@gmail.com>)
List pgsql-general
> Even more difficult in PG functions as they have no commit / rollback 
> capability.  I haven't played with stored procedures in in PG11 yet.

You can simulate oracle autonomous transaction feature in postgres by 
connecting to the same db using dblink.

As for implicit passing of error parameters, I don't think it's possible.

Best, Alex


pgsql-general by date:

Previous
From: pavan95
Date:
Subject: Re: Password management in PostgreSQL
Next
From: Marcio Meneguzzi
Date:
Subject: pgAgent on Windows