Thread: Removing CONTEXT from RAISE EXCEPTION messages from triggers

Hello,

Is it possible to avoid seeing a CONTEXT notice from error messages
returned by the server due to a RAISE EXCEPTION within a trigger?

--
Regards,
Peter Geoghegan

Hello

2010/6/3 Peter Geoghegan <peter.geoghegan86@gmail.com>:
> Hello,
>
> Is it possible to avoid seeing a CONTEXT notice from error messages
> returned by the server due to a RAISE EXCEPTION within a trigger?
>

yes

\set VERBOSITY terse

regards
Pavel Stehule


> --
> Regards,
> Peter Geoghegan
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

>
> \set VERBOSITY terse
>

Well, I actually didn't mean through psql, but I see I can set
verbosity though a call to PQsetErrorVerbosity().

Maybe this would work better as a GUC that can be set per session?
That way, we wouldn't have to worry about downstream driver authors
supporting it.

--
Regards,
Peter Geoghegan

Excerpts from Peter Geoghegan's message of jue jun 03 16:23:07 -0400 2010:
> >
> > \set VERBOSITY terse
> >
>
> Well, I actually didn't mean through psql, but I see I can set
> verbosity though a call to PQsetErrorVerbosity().
>
> Maybe this would work better as a GUC that can be set per session?
> That way, we wouldn't have to worry about downstream driver authors
> supporting it.

This is a client setting, not a server setting, so a GUC doesn't make
much sense.  The server always sends everything.  It's up to the client
to filter according to the user's preferences.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support