Try this:

test=# create table test (a int4);
CREATE
test=# grant select, update on te

Stop there and press 'TAB' to complete the word 'test'.

Your command line then gets rewritten to :

grant select, update on SET

It seems that it occurs when you have commas in there...

Chris


Tue, 24 Jul 2001 10:55:31 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Bug in psql tab completion

I just checked and putting any text in place of 'te' generates 'SET'. 
This is becausee the tab completion code thinks 'UPDATE ON te' is an
update on table ON.  The tasble comletion stuff is pretty good, but not
perfect.


> Try this:
> 
> test=# create table test (a int4);
> CREATE
> test=# grant select, update on te
> 
> Stop there and press 'TAB' to complete the word 'test'.
> 
> Your command line then gets rewritten to :
> 
> grant select, update on SET
> 
> It seems that it occurs when you have commas in there...
> 
> Chris
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 25 Jul 2001 18:48:04 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Bug in psql tab completion