Re: Improvements in psql hooks for variables - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Improvements in psql hooks for variables
Date
Msg-id 20161121134135.GF13284@tamriel.snowman.net
Whole thread Raw
In response to Re: Improvements in psql hooks for variables  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: Improvements in psql hooks for variables  ("Daniel Verite" <daniel@manitou-mail.org>)
Re: Improvements in psql hooks for variables  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-hackers
Daniel,

* Daniel Verite (daniel@manitou-mail.org) wrote:
>     Tom Lane wrote:
>
> > Stephen Frost <sfrost@snowman.net> writes:
> > > In reviewing this patch, I also noticed that it's set up to assume a
> > > 'true' result when a variable can't be parsed by ParseVariableBool.
> >
> > I suppose that's meant to be backwards-compatible with the current
> > behavior:
> >
> > regression=# \timing foo
> > unrecognized value "foo" for "\timing"; assuming "on"
> > Timing is on.
>
> Exactly. The scope of the patch is limited to the effect
> of \set assignments to built-in variables.
>
> > but I agree that if we're changing things in this area, that would
> > be high on my list of things to change.  I think what we want going
> > forward is to disallow setting "special" variables to invalid values,
> > and that should hold both for regular variables that have special
> > behaviors, and for the special-syntax cases like \timing.
>
> +1

Not sure I follow your reply here.  There seems to be broad agreement to
improve how we handle both \set and "special" variables and the code
paths are related and this patch is touching them, so it seems like the
correct next step here is to adjust the patch to update the code based
on that agreement.

Are you working to make those changes?  I'd rather we make the changes
to this code once rather than push what you have now only to turn around
and change it significantly again.

Thanks!

Stephen

pgsql-hackers by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Improvements in psql hooks for variables
Next
From: "Daniel Verite"
Date:
Subject: Re: Improvements in psql hooks for variables