Re: [Fwd: Bug#146689: postgresql-client: 'GRANT DELETE' autocompletion

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: 146689(at)bugs(dot)debian(dot)org
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [Fwd: Bug#146689: postgresql-client: 'GRANT DELETE' autocompletion
Date: 2002-06-05 17:57:29
Message-ID: 200206051757.g55HvTC26133@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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(at)LuftHans(dot)com>
> To: Debian Bug Tracking System <submit(at)bugs(dot)debian(dot)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(at)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(dot)Elphick(at)lfix(dot)co(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew McMillan 2002-06-06 10:52:06 Re: drop tempoary table VERY slow
Previous Message Sam Liddicott 2002-06-05 13:54:46 Re: drop tempoary table VERY slow