[Bash-completion-devel] [bash-completion-Bugs][314636] psql auto-complete varies depending on .psqlrc contents

[bash-completion-bugs at alioth.debian.org]

bash-completion-Bugs item #314636, was opened at 2014-03-26 00:16 by Paul Norman
You can respond by visiting: 
https://alioth.debian.org/tracker/?func=detail&atid=413095&aid=314636&group_id=100114

Status: Open
Priority: 3
Submitted By: Paul Norman (pnorman-guest)
Assigned to: Nobody (None)
Summary: psql auto-complete varies depending on .psqlrc contents 
Distribution: --Distribution-Agnostic--
Originally reported in: None
Milestone: None
Status: None
Original bug number: 


Initial Comment:
The psql completions use psql commands such as psql -AtqwlF $'\t' or psql -Atqwc 'select usename from pg_user'.

This is an issue when the user has a .psqlrc file which changes the default formatting. A particular problem is \pset format wrapped which changes the output even when -t is in effect. The combination of \pset format wrapped and \pset border 2 will cause | to be the only database suggested, because it's the first character on each line with psql -AtqwlF '\t'.

The fix is to pass psql the option -X, which causes it to not load .psqlrc files.

----------------------------------------------------------------------

You can respond by visiting: 
https://alioth.debian.org/tracker/?func=detail&atid=413095&aid=314636&group_id=100114