On 2023-09-20 14:24 -0700, David G. Johnston wrote:
> On Wed, Sep 20, 2023 at 2:20 PM Erik Wienhold <ewie@ewie.name> wrote:
>
> > Has your 14.3 some left-over state from previous test runs? I assume
> > the server is not re-created for each test run. I was wondering if the
> > roles may still exist and with additional memberships. But then again
> > the script just uses CREATE ROLE. So the roles definitely do not exist
> > beforehand. But what are the actual memberships of sten_schema?
> > Because it must inherit SELECT on ref_media_code on 14.3. It can't be
> > from object_creator because that role also gets newly created.
> >
>
> Your description also suggests that maybe the v14 instance has altered
> default privileges setup that maybe the v15 doesn't have.
Not possible for the roles created in the setup script because the
grantee must exist when defining default privileges. Also \dp shows
only those privileges granted in the setup script.
More questions that need answers:
* How are the databases created?
* Does the template database contribute anything, e.g. event triggers?
* Any other setup scripts involved?
--
Erik