[PATCH] Filter error log statements by sqlstate

From: Oskari Saarenmaa <os(at)ohmu(dot)fi>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [PATCH] Filter error log statements by sqlstate
Date: 2014-01-09 19:26:40
Message-ID: 52CEF7F0.80000@ohmu.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Allow the default log_min_error_statement to be overridden per sqlstate
to make it possible to filter out some error types while maintaining a
low log_min_error_statement or enable logging for some error types when
the default is to not log anything.

I've tried to do something like this using rsyslog filters, but that's
pretty awkward and doesn't work at all when the statement is split to
multiple syslog messages.

https://github.com/saaros/postgres/compare/log-by-sqlstate

src/backend/utils/error/elog.c | 183
++++++++++++++++++++++++++++++++++++++++-
src/backend/utils/misc/guc.c | 14 +++-
src/include/utils/guc.h | 4 +
src/include/utils/guc_tables.h | 1 +
4 files changed, 199 insertions(+), 3 deletions(-)

/ Oskari

Attachment Content-Type Size
0001-Filter-error-log-statements-by-sqlstate.patch text/x-patch 9.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Claudio Freire 2014-01-09 19:30:40 Re: [ANNOUNCE] IMCS: In Memory Columnar Store for PostgreSQL
Previous Message knizhnik 2014-01-09 19:24:59 Re: [ANNOUNCE] IMCS: In Memory Columnar Store for PostgreSQL