Re: Users/Roles do not align.

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

In response to

Responses

Browse pgsql-docs by date

  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