From: Jürgen Purtz <juergen@purtz.de>
To: pgsql-docs@lists.postgresql.org
Subject: Re: Users/Roles do not align.
Date: Thu, 6 Feb 2020 11:06:44 +0100
Message-ID: <ae68a0ba-9a20-bbab-8964-4b66c459e4c3@purtz.de> (raw)
In-Reply-To: <20200205183005.GX3195@tamriel.snowman.net>
References: <158057750885.1123.2806779262588618988@wrigleys.postgresql.org>
<2a273cf6-51be-a25b-5ef6-915ca727d4db@purtz.de>
<20200205183005.GX3195@tamriel.snowman.net>
> There's a few things wrong about this part anyway- namely that we've got
> FDWs now, and there's certainly other cluster-wide things that exist
> beyond the specific items listed, so I wonder if perhaps we should just
> stop trying to list everything here.
Inspiring answer! After some inquiry I became aware, that we do not have
only 2 levels of 'belong-to' but 3: tables, views, operators, and much
more objects belong to a schema; schemata, extensions (e.g. FDW), and
more(?) belong to a database; databases, roles, tablespaces, and more
belong to a cluster. Two aspects of 'belong-to' are: object names are
unique within their level, and objects are automatically known
everywhere within their level.
Information about such dependencies and their consequences is spread
across different chapters of the documentation and the System Catalog.
Of course the chapter about roles/users is not suitable to explain the
details. But it's important to know the hierarchy, it shut be summarized
somewhere.
Kind regards, J. Purtz
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: juergen@purtz.de, pgsql-docs@lists.postgresql.org
Subject: Re: Users/Roles do not align.
In-Reply-To: <ae68a0ba-9a20-bbab-8964-4b66c459e4c3@purtz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox