Thread: [Fwd: Bug#146689: postgresql-client: 'GRANT DELETE' autocompletion follows syntax for 'DELETE']
[Fwd: Bug#146689: postgresql-client: 'GRANT DELETE' autocompletion follows syntax for 'DELETE']
From
Oliver Elphick
Date:
-----Forwarded Message----- From: der.hans <bugs@LuftHans.com> To: Debian Bug Tracking System <submit@bugs.debian.org> Subject: Bug#146689: postgresql-client: 'GRANT DELETE' autocompletion follo= ws syntax for 'DELETE' Date: 11 May 2002 17:55:13 -0700 Package: postgresql-client Version: 7.2.1-2 Severity: minor When using tab completion to help enter SQL statements while using psql interactively 'GRANT DELETE' uses the syntax from 'DELETE' rather than that from 'GRANT'. It should follow something like: GRANT UPDATE ON <table> TO Instead it does: GRANT DELETE FROM <table> WHERE It auto fills in FROM and WHERE. It'll even wipe out ON and TO in those places. This doesn't affect anything if you don't use the tab completion, so it's just an annoyance. -- System Information Debian Release: 3.0 Architecture: i386 Kernel: Linux fs 2.4.17-k6 #2 Sat Dec 22 22:02:17 EST 2001 i686 Locale: LANG=3Dde_DE@euro, LC_CTYPE=3D Versions of packages postgresql-client depends on: ii libc6 2.2.5-4 GNU C Library: Shared librarie= s an ii libpam0g 0.72-35 Pluggable Authentication Modul= es l ii libpgsql2 7.2.1-2 Shared library libpq.so.2 for = Post ii libreadline4 4.2a-5 GNU readline and history libra= ries ii libssl0.9.6 0.9.6c-2 SSL shared libraries ii zlib1g 1:1.1.4-1 compression library - runtime -----End Of Forwarded Message----- --=20 Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "Study to show thyself approved unto God, a workman=20 who does not need to be ashamed and who correctly handles the word of truth." II Timothy 2:15=20
Yes, autocomplete is only smart about the first word or two; very hard to fix this. --------------------------------------------------------------------------- Oliver Elphick wrote: Checking application/pgp-signature: FAILURE -- Start of PGP signed section. > -----Forwarded Message----- > > From: der.hans <bugs@LuftHans.com> > To: Debian Bug Tracking System <submit@bugs.debian.org> > Subject: Bug#146689: postgresql-client: 'GRANT DELETE' autocompletion follows syntax for 'DELETE' > Date: 11 May 2002 17:55:13 -0700 > > Package: postgresql-client > Version: 7.2.1-2 > Severity: minor > > When using tab completion to help enter SQL statements while using psql > interactively 'GRANT DELETE' uses the syntax from 'DELETE' rather than > that from 'GRANT'. > > It should follow something like: > > GRANT UPDATE ON <table> TO > > Instead it does: > > GRANT DELETE FROM <table> WHERE > > It auto fills in FROM and WHERE. It'll even wipe out ON and TO in those > places. > > This doesn't affect anything if you don't use the tab completion, so > it's just an annoyance. > > -- System Information > Debian Release: 3.0 > Architecture: i386 > Kernel: Linux fs 2.4.17-k6 #2 Sat Dec 22 22:02:17 EST 2001 i686 > Locale: LANG=de_DE@euro, LC_CTYPE= > > Versions of packages postgresql-client depends on: > ii libc6 2.2.5-4 GNU C Library: Shared libraries an > ii libpam0g 0.72-35 Pluggable Authentication Modules l > ii libpgsql2 7.2.1-2 Shared library libpq.so.2 for Post > ii libreadline4 4.2a-5 GNU readline and history libraries > ii libssl0.9.6 0.9.6c-2 SSL shared libraries > ii zlib1g 1:1.1.4-1 compression library - runtime > > -----End Of Forwarded Message----- > > -- > Oliver Elphick Oliver.Elphick@lfix.co.uk > Isle of Wight http://www.lfix.co.uk/oliver > GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C > > "Study to show thyself approved unto God, a workman > who does not need to be ashamed and who correctly > handles the word of truth." II Timothy 2:15 -- End of PGP section, PGP failed! -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026