pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: David G. Johnston <david.g.johnston@gmail.com>
To: Erik Wienhold <ewie@ewie.name>
Cc: Michael Corey <michael.corey.ap@nielsen.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Changed functionality from 14.3 to 15.3
Date: Thu, 21 Sep 2023 08:43:49 +0200
Message-ID: <de9d39f7c156a8d899b31c20c5defdba96e83d2a.camel@cybertec.at> (raw)
In-Reply-To: <CAKFQuwaJsjuit_rV=QXJHUT5WfWpsyPww9oGxZWoScsQP2j-rw@mail.gmail.com>
References: <CAABu8T85mYLy1is3-EmK1FgKKpuFOXQUSM90UazNV3PjOsUGig@mail.gmail.com>
	<6xfetyaijvqg6urzqpnwhlupztiyz7w2x5tlibn23oifqm344z@gpvbxz2fr4nq>
	<CAABu8T-=QBpDccbTsDTqLB8v0oQXN7wKUw6QsDp13rXCZvHrVw@mail.gmail.com>
	<uygeqa33gw6qmd3sz5n2pxangrrl4z5mixxevbyjhr7tsyjvlg@hc4hryl4numv>
	<CAABu8T_H7uXVO_Jz3tCUMn8rJyA8YzoWpQEch5LjTucccMBQcg@mail.gmail.com>
	<3hv6njioml35mptmeap7xwma5hvxu4s4h4vjvl7j2nvbbpjggz@y4afouuumdfi>
	<CAKFQuwaJsjuit_rV=QXJHUT5WfWpsyPww9oGxZWoScsQP2j-rw@mail.gmail.com>

On Wed, 2023-09-20 at 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.

Since there were references to "rds_superuser", it could also be that this
is caused by modifications that Amazon did to PostgreSQL.

Yours,
Laurenz Albe





view thread (17+ messages)  latest in thread

Message-ID: <de9d39f7c156a8d899b31c20c5defdba96e83d2a.camel@cybertec.at>
Permalink:  ../de9d39f7c156a8d899b31c20c5defdba96e83d2a.camel@cybertec.at/
Also on:    postgresql.org/message-id/de9d39f7c156a8d899b31c20c5defdba96e83d2a.camel@cybertec.at

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: laurenz.albe@cybertec.at, david.g.johnston@gmail.com, ewie@ewie.name, michael.corey.ap@nielsen.com
  Subject: Re: Changed functionality from 14.3 to 15.3
  In-Reply-To: <de9d39f7c156a8d899b31c20c5defdba96e83d2a.camel@cybertec.at>
  References: <CAABu8T85mYLy1is3-EmK1FgKKpuFOXQUSM90UazNV3PjOsUGig@mail.gmail.com> <6xfetyaijvqg6urzqpnwhlupztiyz7w2x5tlibn23oifqm344z@gpvbxz2fr4nq> <CAABu8T-=QBpDccbTsDTqLB8v0oQXN7wKUw6QsDp13rXCZvHrVw@mail.gmail.com> <uygeqa33gw6qmd3sz5n2pxangrrl4z5mixxevbyjhr7tsyjvlg@hc4hryl4numv> <CAABu8T_H7uXVO_Jz3tCUMn8rJyA8YzoWpQEch5LjTucccMBQcg@mail.gmail.com> <3hv6njioml35mptmeap7xwma5hvxu4s4h4vjvl7j2nvbbpjggz@y4afouuumdfi> <CAKFQuwaJsjuit_rV=QXJHUT5WfWpsyPww9oGxZWoScsQP2j-rw@mail.gmail.com> <de9d39f7c156a8d899b31c20c5defdba96e83d2a.camel@cybertec.at>

* 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