[Fwd: Bug#146689: postgresql-client: 'GRANT DELETE' autocompletion follows syntax for 'DELETE']

-----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