Re: patch: autocomplete for functions

Peter Eisentraut <peter_e@gmx.net>

From: Peter Eisentraut <peter_e@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, Pavel Stehule <pavel.stehule@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-03-26T16:49:12Z
Lists: pgsql-hackers
On mån, 2012-03-19 at 15:53 -0400, Tom Lane wrote:
> This connects somewhat to the discussions we've had in the past about
> trying to get not-intended-for-public-use functions out of the
> standard search path.  Not that you want to put a full visibility
> check into the tab-completion query, but if it could simply exclude a
> "pg_private" namespace, that probably wouldn't be too expensive.

I wonder if this could be worked out using pg_depend.  For example, give
me all functions that are not referenced by some object in pg_catalog.