From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org, maxim(dot)boguk(at)gmail(dot)com |
Subject: | Re: BUG #15353: \det (list foreign tables) ignoring search_path |
Date: | 2018-08-25 21:44:24 |
Message-ID: | 875zzyyvjh.fsf@news-spur.riddles.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
>>>>> "PG" == PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
PG> Looks like that the \det[+] [PATTERN] list foreign tables
PG> ignoring current searh_path settings:
Nope, what you're missing is that pg_catalog is implicitly on the front
of the search path (if not otherwise specified), so
pg_catalog.pg_stat_user_tables is considered to "hide"
public.pg_stat_user_tables. Object X in schema Y is only considered
"visible" if using the unqualified name "X" actually resolves to the Y.X
object, and in this case, if one just refers to "pg_stat_user_tables"
one gets pg_catalog.pg_stat_user_tables, not public.pg_stat_user_tables.
--
Andrew (irc:RhodiumToad)
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Munro | 2018-08-25 21:55:23 | Re: BUG #15348: Postgres 8.4 accepte les connexions entrantes |
Previous Message | PG Bug reporting form | 2018-08-25 21:09:38 | BUG #15353: \det (list foreign tables) ignoring search_path |