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 <[EMAIL PROTECTED]> > To: Debian Bug Tracking System <[EMAIL PROTECTED]> > 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 [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
