Re: BUG #13899: \det ignores visibility; patch attached - Mailing list pgsql-bugs

On Fri, Jan 29, 2016 at 9:34 AM,  <reece@harts.net> wrote:
> --- src/bin/psql/describe.c.orig        2016-01-28 16:22:33.782890246 -0800
> +++ src/bin/psql/describe.c     2016-01-28 16:31:08.052200101 -0800
> @@ -4412,7 +4412,8 @@
>                                                          "d.objoid = c.oid AND d.objsubid = 0\n");
>
>         processSQLNamePattern(pset.db, &buf, pattern, false, false,
> -                                                 NULL, "n.nspname", "c.relname", NULL);
> +                                                 NULL, "n.nspname", "c.relname",
> +                                                 "pg_catalog.pg_table_is_visible(c.oid)");
>
>         appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");

Hm. I don't think so, the current behavior looks to be on purpose. \dE
instead can be used to match the visibility with search_path, so I
would rather modify the documentation to mention that \d[Eitstv]
matches the schema visibility in search_path instead and let \det
alone.
--
Michael