Re: [BUGS] Autocomplete on Postgres7.4beta5 not working?

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'stab-completion.c.       [snip]
Note that tables, indexes, views and sequences relations in the'pg_catalog' namespace are excluded even though they are
inthecurrent search path. I found not doing this produced annoyingbehaviour when expanding names beginning with 'p'.
Peoplewho workwith system tables a lot may not like this though; I can look foranother 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?
        regards, tom lane