avoiding CONTEXT messages

Lists: pgsql-general
From: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: avoiding CONTEXT messages
Date: 2012-05-11 14:09:46
Message-ID: CAP_rww=pq5eEMtCp6O431vMxTRSO5FfsvfMpOZf1csebVpn-bA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hi,

I am using PostgreSQL 9.0 and I want to suppress CONTEXT part of error
message for selected user defined Pl/PgSQL functions.
Is this possible?

http://www.postgresql.org/docs/9.0/static/runtime-config-logging.html#GUC-LOG-ERROR-VERBOSITYsuggests
it is...
My function is running on superuser account.
I tried log_error_verbosity but it seems to not affect client messages.

create or replace function test() returns void language plpgsql as 'begin
drop table if exists daddyiamnothere; end' ;
select test();
set log_error_verbosity to terse;
select test();

Thanks

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: avoiding CONTEXT messages
Date: 2012-05-11 14:17:49
Message-ID: CAFj8pRBQgzN2FYGy-EPRSE8GFjvFNS9fTDmX7u5bnYPK6=1ZuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

2012/5/11 Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>:
> Hi,
>
> I am using PostgreSQL 9.0 and I want to suppress CONTEXT part of error
> message for selected user defined Pl/PgSQL functions.
> Is this possible?

probably no.

context is detected before filtering is applyed

Pavel

>
> http://www.postgresql.org/docs/9.0/static/runtime-config-logging.html#GUC-LOG-ERROR-VERBOSITY
> suggests it is...
> My function is running on superuser account.
> I tried log_error_verbosity but it seems to not affect client messages.
>
> create or replace function test() returns void language plpgsql as 'begin
> drop table if exists daddyiamnothere; end' ;
> select test();
> set log_error_verbosity to terse;
> select test();
>
>
> Thanks
>

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: avoiding CONTEXT messages
Date: 2012-05-11 14:41:58
Message-ID: 20120511144158.GA12339@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Fri, May 11, 2012 at 09:09:46AM -0500, Filip Rembiałkowski wrote:
> I am using PostgreSQL 9.0 and I want to suppress CONTEXT part of error
> message for selected user defined Pl/PgSQL functions.
> Is this possible?

it's up to application to hide it.

for example - in psql, you do it by setting:
\set VERBOSITY terse

but I agree, it should be configurable in server.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/

From: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
To: depesz(at)depesz(dot)com
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: avoiding CONTEXT messages
Date: 2012-05-11 14:58:08
Message-ID: CAP_rww=7djbbE=AYTapE1q0Gc79hpkT-UKRUvUpfuWCa6gb6hA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Fri, May 11, 2012 at 9:41 AM, hubert depesz lubaczewski <
depesz(at)depesz(dot)com> wrote:

> On Fri, May 11, 2012 at 09:09:46AM -0500, Filip Rembiałkowski wrote:
> > I am using PostgreSQL 9.0 and I want to suppress CONTEXT part of error
> > message for selected user defined Pl/PgSQL functions.
> > Is this possible?
>
> it's up to application to hide it.
>
> for example - in psql, you do it by setting:
> \set VERBOSITY terse
>

oh, great, this one helped (we run psql from bash scripts) - thanks.