Re: Function for Exception Logging

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: Tony Shelver <tshelver(at)gmail(dot)com>, Patrick(dot)Fiche(at)aqsacom(dot)com
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Function for Exception Logging
Date: 2018-11-05 13:26:36
Message-ID: 7f8ac4f2-4ddb-1566-e0b4-3c083252d073@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcio Meneguzzi 2018-11-05 13:45:04 pgAgent on Windows
Previous Message Tatsuo Ishii 2018-11-05 12:48:09 Re: Code of Conduct plan,Re: Code of Conduct plan,Re: Code of Conduct plan,Re: Code of Conduct plan