Re: PL/pgSQL, RAISE and error context - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: PL/pgSQL, RAISE and error context
Date
Msg-id CAASwCXcbOhsTdi8iEGcdbv=G=3PnAFxQ9G_kX3MJHeg4rvUAGw@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL, RAISE and error context  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: PL/pgSQL, RAISE and error context
List pgsql-hackers
On Fri, Apr 24, 2015 at 1:16 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> This would allow doing something crazy as:
>>
>> suppress_context_messages = warning,error
>> display_context_messages = notice
>
> This is a very flexible proposal, but it's a tremendous amount of
> machinery for what's really a very minor issue.  If we added two GUCs
> for every comparably important issue, we'd have about 40,000 of them.

I agree. The one-dimensional GUC syntax is not well suited for
multi-dimensional config settings. And that's a good thing mostly I
think. It would be a nightmare if the config file values could in JSON
format, it's good they are simple.

But I'm thinking maybe we could improve the config file syntax for the
general case when you have multiple things you want to control, in
this case the message levels, and for each such thing, you want to
turn something on/off, in this case the CONTEXT. Maybe we could simply
use plus "+" and minus "-" to mean "on" and "off"?

Example:

context_messages = -warning, -error, +notice



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Moving ExecInsertIndexTuples and friends to new file
Next
From: Kouhei Kaigai
Date:
Subject: Re: Custom/Foreign-Join-APIs (Re: [v9.5] Custom Plan API)