Postgres Pro
Downloads
Home   >   mailing lists

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

From Tatsuro Yamada
Subject Re: Question about psql meta-command with schema option doesn't use visibilityrule
Date
Msg-id 28aadd46-09b6-2b94-6573-088656c6c194@nttcom.co.jp
Whole thread Raw
In response to Re: Question about psql meta-command with schema option doesn't use visibilityrule  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
Tree view 
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
unqualifiedbut 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

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Make mesage at end-of-recovery less scary.
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Commitfest 2021-11 Patch Triage - Part 1