| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Bryn Llewellyn <bryn(at)yugabyte(dot)com>, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Seems to be impossible to set a NULL search_path |
| Date: | 2022-07-05 18:24:17 |
| Message-ID: | CAFj8pRA2fHFe-zqxnuR27MVGE+waKWsPoDAVD3W3iMj9TTFDjw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
út 5. 7. 2022 v 20:18 odesílatel Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
napsal:
> On 7/5/22 11:12 AM, Bryn Llewellyn wrote:
> > The section "Writing SECURITY DEFINER Functions Safely":
> >
> >
> https://www.postgresql.org/docs/current/sql-createfunction.html#id-1.9.3.67.10.2
> >
>
> > Finally, what do you think of a possible future enhancement to allow
> setting a null search_path?
> >
>
> 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.
Regards
Pavel
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-07-05 18:28:18 | Re: Seems to be impossible to set a NULL search_path |
| Previous Message | Christophe Pettus | 2022-07-05 18:18:36 | Re: Seems to be impossible to set a NULL search_path |