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