Re: Schema-qualify function calls in information_schema

David Fetter <david(at)fetter(dot)org> writes:
> Please find attached a patch against master to do $Subject, which
> tones down the hilarity, at least in information_schema.

The views do not need this sort of change, because they're parsed
only once during initdb.

The bodies of functions in information_schema do need qualification,
but I think they've already got it, or at least I remember having
looked through them for the issue in the past.

> Another way to fix this, which I know will be controversial, is simply
> to mandate that pg_catalog (and possibly information_schema) be
> non-changeably first in the search_path.

I think that ship sailed long ago. It might be workable to attach
"SET search_path" clauses to the functions, if you want to make them
more bulletproof.

regards, tom lane