Function for Exception Logging

From: Patrick FICHE <Patrick(dot)Fiche(at)aqsacom(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Function for Exception Logging
Date: 2018-10-29 17:02:12
Message-ID: VI1PR0501MB2574AC24FD43A67E5F4C6CCDEFF30@VI1PR0501MB2574.eurprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi community,

I would like to implement a function that would log managed Exceptions into a dedicated table.
For example, I have some code like :
BEGIN
Code generation exception
EXCEPTION
WHEN OTHERS THEN Log_Error();
END;

The Log_Error function would be able to get the exception context / parameters to log the exception parameters into a table.
Is there any way to manage this without providing the Exception parameters as parameters to the Log_Error function ?

Thanks,
Patrick

Browse pgsql-general by date

  From Date Subject
Next Message Patrick FICHE 2018-10-29 17:13:15 Function for Exception Logging
Previous Message Igor Korot 2018-10-29 16:56:55 Re: Log file