The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/plpgsql-control-structures.html Description:
42.6.8.1. Obtaining Information About An Error
This example omits raise notice code:
DECLARE
text_var1 text;
text_var2 text;
text_var3 text;
BEGIN
-- some processing which might cause an exception
...
EXCEPTION WHEN OTHERS THEN
GET STACKED DIAGNOSTICS text_var1 = MESSAGE_TEXT,
text_var2 = PG_EXCEPTION_DETAIL,
text_var3 = PG_EXCEPTION_HINT;
END;
