Previous version replaced.

Your patch has been added to the PostgreSQL unapplied patches list at:

        http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------


Sergey E. Koposov wrote:
> 
> Now the patch have been made using "cvs diff -c" 
> 
> Sergey
> 
> On Tue, 29 Nov 2005, Sergey E. Koposov wrote:
> 
> > Hello All, 
> > 
> > 1) I'm proposing a patch to do the DROP FUNCTION argument tab completion.
> > Now, the arguments of the drop function can be tab completed. for example
> > 
> > drop function strpos (
> > <press tab>
> > drop FUNCTION strpos (text, text)
> > 
> > or:
> > 
> > wsdb=# drop FUNCTION length (      
> > bit)        bytea)      character)  lseg)       path)       text)
> > <press c>
> > wsdb# DROP FUNCTION length ( character) 
> > 
> > I think that this patch should be rather useful. At it least I hate 
> > always to type all the arguments of the dropped functions.
> > 
> > 2) Also some fixes applied for the 
> > CREATE INDEX syntax
> > 
> > now the parenthesises are inserted by tab pressing. 
> > suppose I have the table q3c:
> > wsdb=# \d q3c
> >           Table "public.q3c"
> >  Column |       Type       | Modifiers 
> > --------+------------------+-----------
> >  ipix   | bigint           | 
> >  ra     | double precision | 
> >  dec    | double precision | 
> > 
> > Now if I do 
> > wsdb# create index xxx on q3c 
> > <press tab>
> > wsdb# CREATE INDEX xxx on q3c ( 
> > <press tab>
> > wsdb=# CREATE INDEX xxx on q3c ( 
> > "dec"  ipix   ra     
> > <press r>
> > wsdb=# CREATE INDEX xxx on q3c ( ra 
> > 
> > Regards,
> >         Sergey
> > 
> > *****************************************************
> > Sergey E. Koposov
> > Max-Planck Institut for Astronomy
> > Web: http://lnfm1.sai.msu.ru/~math 
> > E-mail: [EMAIL PROTECTED]
> > 
> > 
> 
> *****************************************************
> Sergey E. Koposov
> Max-Planck Institut for Astronomy
> Web: http://lnfm1.sai.msu.ru/~math 
> E-mail: [EMAIL PROTECTED]
>  

Content-Description: 

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to [EMAIL PROTECTED] so that your
>        message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to