Function for Exception Logging - Mailing list pgsql-general

From Patrick FICHE
Subject Function for Exception Logging
Date
Msg-id VI1PR0501MB2574AC24FD43A67E5F4C6CCDEFF30@VI1PR0501MB2574.eurprd05.prod.outlook.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Fwd: Log file
Next
From: Patrick FICHE
Date:
Subject: Function for Exception Logging