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/>
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 |