From: Stephen Frost <sfrost@snowman.net>
To: Jürgen Purtz <juergen@purtz.de>
Cc: pgsql-docs@lists.postgresql.org
Cc: jbird@nuna.com
Subject: Re: Users/Roles do not align.
Date: Wed, 5 Feb 2020 13:30:05 -0500
Message-ID: <20200205183005.GX3195@tamriel.snowman.net> (raw)
In-Reply-To: <2a273cf6-51be-a25b-5ef6-915ca727d4db@purtz.de>
References: <158057750885.1123.2806779262588618988@wrigleys.postgresql.org>
<2a273cf6-51be-a25b-5ef6-915ca727d4db@purtz.de>
Greetings,
* Jürgen Purtz (juergen@purtz.de) wrote:
> >Based on this, I believe Section 5.9 should read:
> >`A PostgreSQL database cluster contains one or more named databases. Roles
> >are shared across the entire cluster, but no other data is shared across
> >databases. Any given client connection to the server can access only the
> >data in a single database, the one specified in the connection request.`
>
> imo the following is a more precise wording:
>
> 'A cluster contains three or more named databases ('template0', 'template1',
> 'postgres', ...). Roles, which are users or groups, see Chapter 21, - as
Roles aren't 'users or groups', they're roles, and we don't actually
have users or groups today.
> well as database names and tablespace definitions - are shared across the
> entire cluster. No other data is shared across databases or schemas. Any
> given client connection to the server can access only the data in a single
> database, the one specified in the connection request. If it has the
> necessary privileges, the connection can access all schemas within this
> database.'
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. The description given in 22.1
seems like it's a lot better since it talks about the hierarchy in a
general sense.
The minimalistic approach suggested initially seems like it might be the
best answer to this right now.
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
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: sfrost@snowman.net, juergen@purtz.de, pgsql-docs@lists.postgresql.org, jbird@nuna.com
Subject: Re: Users/Roles do not align.
In-Reply-To: <20200205183005.GX3195@tamriel.snowman.net>
* 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