Re: Improvements in psql hooks for variables
Daniel Verite <daniel@manitou-mail.org>
From: "Daniel Verite" <daniel@manitou-mail.org>
To: "Ashutosh Sharma" <ashu.coek88@gmail.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>,"Rahila Syed"
<rahilasyed90@gmail.com>,"Stephen Frost" <sfrost@snowman.net>,"Ashutosh
Bapat" <ashutosh.bapat@enterprisedb.com>,"pgsql-hackers"
<pgsql-hackers@postgresql.org>
Date: 2017-01-20T13:44:12Z
Lists: pgsql-hackers
Ashutosh Sharma wrote: > postgres=# \echo :ENCODING > UTF8 > postgres=# \set ENCODING xyz > postgres=# \echo :ENCODING > xyz > > I think currently we are not even showing what are the different valid > encoding names to the end users like we show it for other built-in > variables > VERBOSITY, ECHO etc. I mean if i run '\set VERBOSITY' followed by tab > command it does show me the valid values for VERBOSITY but not for > ENCODING. Setting ENCODING has no effect, like DBNAME, USER, HOST and PORT. In a way, it's a read-only variable that's here to inform the user, not as a means to change the encoding (\encoding does that and has proper support for tab completion) What we could do as of this patch is emit an error when we try to change ENCODING, with a hook returning false and a proper error message hinting to \encoding. I'm working on adding such messages to other variables. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite
Commits
-
Clean up psql's behavior for a few more control variables.
- fd6cd698031d 10.0 landed
-
Make psql's \set display variables in alphabetical order.
- c3e3844a92fe 10.0 landed
-
Improve psql's behavior for \set and \unset of its control variables.
- 86322dc7e013 10.0 landed
-
Make psql reject attempts to set special variables to invalid values.
- 511ae628f31b 10.0 landed