Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Andrew McMillanDate: 2002-06-06 10:52:06
Subject: Re: drop tempoary table VERY slow
Previous:From: Sam LiddicottDate: 2002-06-05 13:54:46
Subject: Re: drop tempoary table VERY slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group