Re: [GENERAL] How to get an exception detail in a function called in exception handler

error logging function could get the previous exception details somehow. Thanks, Shakti Singh On Tue, Jan 24, 2017 at 11:13 AM, Tom Lane wrote: > Shakti Singh writes: > > In oracle sqlcode and sqlerrm can be accessed in a function called from > an > > exception block. >

[GENERAL] How to get an exception detail in a function called in exception handler

STICS the_sqlerrormessage = MESSAGE_TEXT, the_sqlcode = RETURNED_SQLSTATE, INSERT into "myschema"."error_trace"( errorCode, error_messaage) VALUES ( the_sqlcode, the_sqlerrormessage); END; $$ LANGUAGE plpgsql; Thanks, Shakti Singh

Re: [GENERAL] PostgreSQL 9.6.1: Debug window does not load function sql

Thanks Adrian, This is exactly what I am experiencing. I will track these issues for resolution. Shakti Singh On Wed, Dec 14, 2016 at 2:59 PM, Adrian Klaver wrote: > On 12/14/2016 09:38 AM, Shakti Singh wrote: > >> Thanks Adrian, >> >> Yes, I did all this. The OS i

Re: [GENERAL] PostgreSQL 9.6.1: Debug window does not load function sql

er by restarting the service "postgresql-x64-9.6 - PostgreSQL Server 9.6" Here is the screenshot of the right hand pane when: 1. I select a plpgsql function 2. right click and select Debugging > Debug 3. Fill in the parameter values in the pop up [image: Inline image 1] Thanks, Sha

[GENERAL] PostgreSQL 9.6.1: Debug window does not load function sql

. Thanks Shakti Singh