Re: Question about psql meta-command with schema option doesn't use visibilityrule

From: Tatsuro Yamada <tatsuro(dot)yamada(dot)tf(at)nttcom(dot)co(dot)jp>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Question about psql meta-command with schema option doesn't use visibilityrule
Date: 2021-11-08 06:06:54
Message-ID: 28aadd46-09b6-2b94-6573-088656c6c194@nttcom.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi David,

> I have a question that is a specification of permission check
> (visibilityrule) for psql meta-command with schema option.
>
> Visibility means search_path, not permission.  If s_a is not in the search_paths it objects are not visible unqualified but can be seen (catalog) when schema qualified.

Thanks for your comments! I understood them:
- all users can show System catalog (pg_catalog. *) is a
specification, so it is not a bug
- visibility and permission are not the same (I confused it before, oops)

Regards,
Tatsuro Yamada

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro Horiguchi 2021-11-08 06:07:43 Re: Commitfest 2021-11 Patch Triage - Part 1
Previous Message Kyotaro Horiguchi 2021-11-08 05:59:46 Re: Make mesage at end-of-recovery less scary.