From: | Jürgen Purtz <juergen(at)purtz(dot)de> |
---|---|
To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: Users/Roles do not align. |
Date: | 2020-02-06 10:06:44 |
Message-ID: | ae68a0ba-9a20-bbab-8964-4b66c459e4c3@purtz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | PG Doc comments form | 2020-02-06 12:23:46 | Examples required in || 5.10. Table Partitioning |
Previous Message | Bruce Momjian | 2020-02-06 05:11:31 | Re: Documentation: 21.5. Default Roles |