Function for Exception Logging

From: Patrick FICHE <Patrick(dot)Fiche(at)aqsacom(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Function for Exception Logging
Date: 2018-10-29 17:13:15
Message-ID: VI1PR0501MB25747CEE9D197D4C2EF31725EFF30@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

Patrick Fiche
Database Engineer, Aqsacom Sas.
c. 33 6 82 80 69 96
e. patrick(dot)fiche(at)aqsacom(dot)com<mailto:patrick(dot)fiche(at)aqsacom(dot)com>

[01-03_AQSA_Main_Corporate_Logo_JPEG_White_Low.jpg]<http://www.aqsacom.com/>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-10-29 17:40:51 Re: rw_redis_fdw: SQL Errors when statement is within a function
Previous Message Patrick FICHE 2018-10-29 17:02:12 Function for Exception Logging