Re: Use of ?get diagnostics'?

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Use of ?get diagnostics'?
Date: 2019-09-26 05:44:18
Message-ID: 20190926054418.Horde.JG3i7Er5VDQBFQF4uEfhCVR@webmail.gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Adrian

Quoting Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ekaterina Amez 2019-09-26 05:51:16 Re: Upgrading old server
Previous Message Matthias Apitz 2019-09-26 05:12:46 Re: updating sequence value for column 'serial'