Re: BUG #13899: \det ignores visibility; patch attached

On Fri, Jan 29, 2016 at 9:34 AM, <reece(at)harts(dot)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