Bug#536815: postgresql-client-8.3: local db tab completion for psql
I left a comment at the launchpad bug. There is now a way to fix this. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#536815: postgresql-client-8.3: local db tab completion for psql
Hi Martin, Thanks for your quick reply, on your work on the Debian postgresql package. On Tue, 14 Jul 2009, Martin Pitt wrote: As you already discovered yourself, this was disabled in bash-completion, so I reassing this wishlist bug to bash-completion. Maintainers, please close/wontfix as you see fit (I don't know the reason why it was disabled). Speaking as the psql maintainer, figuring out all local databases correctly (and mapping them to their cluster) is really nontrivial, so perhaps it was done because the completion was too bad? Well, no disrespect intended, but the reason for disabling this feature is because it doesn't work perfectly? Now hitting tab gives all the files in the directory. How is that better? To the bash completion maintainers: please consider renabling this functionality. There was no reason given for the original disabling. It looks like this change was made in Ubuntu first, and copied to Debian. If there is a Ubuntu bug or a discussion in the ML is would have been helpful to link to it. For one thing, is would make requests like this less likely. Otherwise, is there some way to reenable this functionality locally? Regards, Faheem Mitha. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#536815: [Bash-completion-devel] Bug#536815: postgresql-client-8.3: local db tab completion for psql
On Tuesday 14 July 2009, Faheem Mitha wrote: If there is a Ubuntu bug or a discussion in the ML is would have been helpful to link to it. For one thing, is would make requests like this less likely. First two distinct hits when Googling ubuntu psql completion: http://ubuntuforums.org/showthread.php?t=613499 https://bugs.launchpad.net/ubuntu/+source/bash-completion/+bug/164772 Disclaimer: I have nothing to do with Ubuntu or Debian nor have a strong opinion on the issue - the argument in the Ubuntu bug tracker seems quite valid to me though. I've added a pointer to that bug in sources and CHANGES in git. Otherwise, is there some way to reenable this functionality locally? See the _pg_databases and _pg_users completion functions. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#536815: postgresql-client-8.3: local db tab completion for psql
reassign 536815 bash-completion 20080617.4 thanks Hello Faheem, Faheem Mitha [2009-07-13 14:24 -0400]: I have been using a machine, still running etch, where tab completion for local dbs works. fah...@ccis2753:~$ dpkg -l postgresql-client-8.3 [...] ii postgresql-client-8.3 8.3.5-1~bpo40+1 front-end programs for PostgreSQL 8.3 fah...@ccis2753:~$ psql --version psql (PostgreSQL) 8.3.5 contains support for command-line editing fah...@ccis2753:~$ psql [tab] btsnp_full_genomebtsnp_full_genome_copy2 btsnp_test template0 btsnp_full_genome_copy btsnp_full_genome_trunc postgres template1 However, this doesn't work for other machines I've tried, machines now mostly running 8.3 on lenny. Do you know what is going on here? I tried IRC (#postgresql on freenode), but they don't seem to be interested. As you already discovered yourself, this was disabled in bash-completion, so I reassing this wishlist bug to bash-completion. Maintainers, please close/wontfix as you see fit (I don't know the reason why it was disabled). Speaking as the psql maintainer, figuring out all local databases correctly (and mapping them to their cluster) is really nontrivial, so perhaps it was done because the completion was too bad? Thanks, Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#536815: postgresql-client-8.3: local db tab completion for psql
On Monday 13 July 2009 21:24:59 Faheem Mitha wrote: There are some lines in the changelog about this, but not very specific. faheem:/usr/share/doc/postgresql-client-8.3$ zgrep completion * [...] changelog.gz: * Improve tab completion support (Stefan Kaltenbrunn, Greg Sabino changelog.gz: * Improve tab completion (Rod, Ross Reedstrom, Ian Barwick) FYI, these items relate to the tab completion of the SQL language within the psql program, not the completion of arguments to the psql program in the shell. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#536815: postgresql-client-8.3: local db tab completion for psql
Package: postgresql-client-8.3 Version: 8.3.7-0lenny1 Severity: wishlist Hi, I have been using a machine, still running etch, where tab completion for local dbs works. fah...@ccis2753:~$ dpkg -l postgresql-client-8.3 [...] ii postgresql-client-8.3 8.3.5-1~bpo40+1 front-end programs for PostgreSQL 8.3 fah...@ccis2753:~$ psql --version psql (PostgreSQL) 8.3.5 contains support for command-line editing fah...@ccis2753:~$ psql [tab] btsnp_full_genomebtsnp_full_genome_copy2 btsnp_test template0 btsnp_full_genome_copy btsnp_full_genome_trunc postgres template1 However, this doesn't work for other machines I've tried, machines now mostly running 8.3 on lenny. Do you know what is going on here? I tried IRC (#postgresql on freenode), but they don't seem to be interested. There are some lines in the changelog about this, but not very specific. faheem:/usr/share/doc/postgresql-client-8.3$ zgrep completion * [...] changelog.gz: * Improve tab completion support (Stefan Kaltenbrunn, Greg Sabino changelog.gz: * Improve tab completion (Rod, Ross Reedstrom, Ian Barwick) Regards, Faheem. -- System Information: Debian Release: 5.0.2 APT prefers stable APT policy: (500, 'stable'), (50, 'unstable'), (50, 'testing'), (1, 'experimental') Architecture: i386 (i686) Kernel: Linux 2.6.26-2-vserver-686-bigmem (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages postgresql-client-8.3 depends on: ii libc6 2.7-18GNU C Library: Shared libraries ii libpq5 8.3.7-0lenny1 PostgreSQL C client library ii libreadline5 5.2-3.1 GNU readline and history libraries ii libssl0.9.80.9.8g-15+lenny1 SSL shared libraries ii postgresql-client-comm 94lenny1 manager for multiple PostgreSQL cl ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime postgresql-client-8.3 recommends no packages. Versions of packages postgresql-client-8.3 suggests: ii postgresql-8.3 8.3.7-0lenny1 object-relational SQL database, ve pn postgresql-doc-8.3 none(no description available) -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#536815: postgresql-client-8.3: local db tab completion for psql
On Mon, 13 Jul 2009, Faheem Mitha wrote: Package: postgresql-client-8.3 Version: 8.3.7-0lenny1 Severity: wishlist Hi, I have been using a machine, still running etch, where tab completion for local dbs works. fah...@ccis2753:~$ dpkg -l postgresql-client-8.3 [...] ii postgresql-client-8.3 8.3.5-1~bpo40+1 front-end programs for PostgreSQL 8.3 fah...@ccis2753:~$ psql --version psql (PostgreSQL) 8.3.5 contains support for command-line editing fah...@ccis2753:~$ psql [tab] btsnp_full_genomebtsnp_full_genome_copy2 btsnp_test template0 btsnp_full_genome_copy btsnp_full_genome_trunc postgres template1 However, this doesn't work for other machines I've tried, machines now mostly running 8.3 on lenny. Do you know what is going on here? I tried IRC (#postgresql on freenode), but they don't seem to be interested. [snip] It looks like this facility was recently disabled in the bash-completion package, so feel free to close this bug. I'll leave it open for now in case you want to offer any feedback. Regards, Faheem. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
