| From: | "Igal (at) Lucee(dot)org" <igal(at)lucee(dot)org> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_dump and search_path |
| Date: | 2019-07-09 06:48:25 |
| Message-ID: | 1f5111a5-e49e-e44a-67df-b367e5d31fdf@lucee.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a custom search_path:
# show search_path;
search_path
----------------------------------
"staging, transient, pg_catalog"
(1 row)
I ran `pg_dump --schema-only` and the only reference in the output to
search_path is:
SELECT pg_catalog.set_config('search_path', '', false);
Then one of my functions which does not reference the full name of a
table with its schema fails with "relation [rel-name] does not exist".
Is that a bug? I have seen some old posts about this issue but am not
sure if there is a ticket or why it still is an issue.
Thanks,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igal @ Lucee.org | 2019-07-09 06:54:25 | Re: pg_dump and search_path |
| Previous Message | Thomas Munro | 2019-07-09 04:43:21 | Re: OOM with many sorts |