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

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

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: [Fwd: Bug#146689: postgresql-client: 'GRANT DELETE' autocompletionfollows syntax for 'DELETE']
Date: 2002-05-12 06:30:28
Message-ID: 1021185028.1539.32.camel@linda (view raw or flat)
Thread:
Lists: pgsql-bugs
-----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 

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-05-12 15:58:50
Subject: Re: Bug #664: Strange cursor behaviour with particular database schema
Previous:From: pgsql-bugsDate: 2002-05-11 21:13:39
Subject: Bug #665: MORE INFO Re: "Strange cursor behaviour with a particular database schema"

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