Tom Lane wrote:
>Gaetano Mendola <mendola@bigfoot.com> writes:
>
>
>>I'm esperiencing problem with the <TAB> autocomplete on
>>postgres 7.4beta5:
>>
>>
>
>
>
>>#select * from pg_l<TAB><TAB>
>>and no suggestions out.
>>
>>
>
>This appears to have been a deliberate change:
>
>2003-03-27 11:45 momjian
>
> * src/bin/psql/tab-complete.c: Attached are two patches for psql's
> tab-completion.c.
> [snip]
>
> Note that tables, indexes, views and sequences relations in the
> 'pg_catalog' namespace are excluded even though they are in the
> current search path. I found not doing this produced annoying
> behaviour when expanding names beginning with 'p'. People who work
> with system tables a lot may not like this though; I can look for
> another solution if necessary.
>
> Ian Barwick
>
>AFAICT there was no discussion about this issue when the patch was
>proposed and applied. But now that the point is raised I have to say
>that I don't like this change. I don't think system catalogs should be
>excluded from tab completion. They never were before 7.4, and I have
>not seen anyone complaining about that, other than Ian.
>
>Comments anyone?
>
>
Might be better to:
1. make it a settable option
and/or
2. include catalog objects in expansion iff we are expanding "pg_" +
optional suffix (probably best of both worlds).
I rarely use completion in this way so I could be an unrepresentative
user, though :-)
cheers
andrew