Re: pg_stat_statements : how to catch non successfully finished statements ?

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_stat_statements : how to catch non successfully finished statements ?
Date: 2018-05-09 22:06:16
Message-ID: 1525903576324-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Here is a patch that :
- adds a new guc: pg_stat_statements.track_errors boolean (default to true),
- capture of DML, DDL, PL/PGSQL commands in error into pgss.

There is always a risk that new code used in PG_CATCH (mainly pgss_store)
gives an error.
I'm not able to tell when it could occur and what would be the impact ...

see
pgss_with_errors.patch
<http://www.postgresql-archive.org/file/t348768/pgss_with_errors.patch>

pgss_with_errors.txt
<http://www.postgresql-archive.org/file/t348768/pgss_with_errors.txt>

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-05-09 23:20:28 Re: Error creating plpython3u extension
Previous Message Antonio Silva 2018-05-09 21:47:25 Re: issues when installing postgres