Re: Use of ?get diagnostics'? - Mailing list pgsql-general

From Thiemo Kellner
Subject Re: Use of ?get diagnostics'?
Date
Msg-id 20190926054418.Horde.JG3i7Er5VDQBFQF4uEfhCVR@webmail.gelassene-pferde.biz
Whole thread Raw
In response to Re: Use of ?get diagnostics'?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Use of ?get diagnostics'?
List pgsql-general
Hello Adrian

Quoting Adrian Klaver <adrian.klaver@aklaver.com>:

> To get above I believe you will need to use GET CURRENT DIAGNOSTICS  
> PG_CONTEXT:

I actually use "get stacked diagnostics" to retrieve the exception  
place. And it works. I am not sure why I did no see it.

However, I noticed, that the stack does not include the error place in  
dynamic SQL executed by the "execute" command. Maybe I am missing  
something again.

Kind regards

Thiemo

-- 
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Handys: +41 78 947 36 21 | +49 1578 772 37 37
Tox-Id:  
B7282A9E31D944DDAD1ECC5B33C36AAE80B32D119AB7391D602C937A65E8CA0625C495C5322B




pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Re: updating sequence value for column 'serial'
Next
From: Ekaterina Amez
Date:
Subject: Re: Upgrading old server