Invalid user-level setting = confusing error message

From: Thom Brown <thom(at)linux(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Invalid user-level setting = confusing error message
Date: 2016-02-11 13:20:08
Message-ID: CAA-aLv7b9EAiyftyw-iV6PSZFkuV4Yjui1Zirod+XSfnXyOj3w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

At the moment, if we try to set up a configuration parameter for a
user which doesn't make sense in that context, we get an error message
that doesn't really tell us that we're not allowed to set it for
users:

# ALTER ROLE moo SET log_line_prefix = '%s';
ERROR: parameter "log_line_prefix" cannot be changed now

Might I propose an alternative error message for user-level
configuration changes that target parameters of level sighup and
above?

Perhaps something like:

ERROR: parameter "log_line_prefix" cannot be set at the user level.

Thom

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacek Wielemborek 2016-02-11 13:26:41 Re: Request for Code Review: BPGSQL
Previous Message Robert Haas 2016-02-11 13:18:15 Re: max_parallel_degree context level