I will adjust this patch based on later feedback emails. 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. --------------------------------------------------------------------------- Joachim Wieland wrote: > Hi, > > psql's tab completion has the following problem: > > If we have the following syntax for example: > > SET SESSION AUTHORIZATION <user>; > SET SESSION AUTHORIZATION DEFAULT; > > After "SET SESSION AUTHORIZATION", the tab completion can offer a list of > roles or the string constant "DEFAULT". However it can't offer both because > it can't get a list of roles and add a string constant to this list. > > The appended patch adds the functionality of lists that can be extended with > constants. > > Then you get: > > template1=# SET session AUTHORIZATION <tab> > DEFAULT fred joe john > > I did proof-of-concept examples to add a constant to a > > - list from a query > - list from a schema query > - list of table attributes > > > Joachim > [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- 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 4: Have you searched our list archives? http://archives.postgresql.org