Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: pgsql-hackers@lists.postgresql.org, steven.winfield@cantabcapital.com
Date: 2020-01-14T01:38:17Z
Lists: pgsql-bugs, pgsql-hackers
Attachments
- psql-filename-completion-fixes-6.patch (text/x-diff) patch
I wrote: > Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes: >> I have found a weird behavior with identifier quoting, which is not the >> subject of this patch, but it appears to be affected by it. > I'll think about how to improve this. Given that we're dequoting > filenames explicitly anyway, maybe we don't need to tell readline that > double-quote is a quoting character. Another idea is that maybe > we ought to refactor things so that identifier dequoting and requoting > is handled explicitly, similarly to the way filenames work now. > That would make the patch a lot bigger though. On reflection, it seems like the best bet for the moment is to remove double-quote from the rl_completer_quote_characters string, which should restore all behavior around double-quoted strings to what it was before. (We have to keep single-quote in that string, though, or quoted file names fail entirely.) The only impact this has on filename completion is that we're no longer bright enough to convert a double-quoted filename to single-quoted for you, which would be a nice-to-have but it's hardly core functionality. At some point it'd be good to undo that and upgrade quoted-identifier processing, but I don't really want to include such changes in this patch. I'm about burned out on tab completion for right now. regards, tom lane
Commits
-
Improve psql's tab completion for filenames.
- cd69ec66c886 13.0 landed
-
Modernize our readline API a tad.
- 5e7bedc5adba 13.0 landed
-
Add tab completion for EXPLAIN (SETTINGS) in psql
- 4b011cad272e 13.0 cited