On 7/5/22 11:24 AM, Pavel Stehule wrote:
> >
>
> set search_path = '';
>
> show search_path ;
> search_path
> -------------
> ""
>
> \d
> Did not find any relations.
>
>
> But still in this case, there is pg_catalog in search path.
Yes but from OP:
"I've confirmed that even a superuser cannot create objects in a
"special" schema like "pg_catalog" or "pg_toast". So this gives me a
workaround to the limitation that I cannot force the use of fully
qualified names by setting a null search_path: I could set the attribute
of my subprogram to "pg_catalog"."
So Bryn Llewellyn does not seem to be concerned about that.
>
> Regards
>
> Pavel
>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
