Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qjDPs-009rJF-0d for pgsql-general@arkaria.postgresql.org; Thu, 21 Sep 2023 06:44:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qjDPq-00975i-Jf for pgsql-general@arkaria.postgresql.org; Thu, 21 Sep 2023 06:43:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qjDPq-00975S-7r for pgsql-general@lists.postgresql.org; Thu, 21 Sep 2023 06:43:58 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qjDPj-006TAl-Ep for pgsql-general@lists.postgresql.org; Thu, 21 Sep 2023 06:43:57 +0000 Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-52e5900cf77so585952a12.2 for ; Wed, 20 Sep 2023 23:43:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1695278630; x=1695883430; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=/j+qHBmrik+LJfC9WNjkzAwkK7SX23Waj6Cd1Jt4FfI=; b=rkNKVzJUPJ1iEL1RIfScks0WDoFqfneNncQPcqfng8P9IpwRJKUZdBrKDoCv7l5ZZc NB+ohGkiHvX0oNl38F38RoGGl1E5ZAMjhSawmVBfF4TK1WiqY7JQPzLLMNriDx61y9sC HkNJ/GFRQfUVr68qUsrv1Qf2qSCl0O4y5mjeOj/QJe4f3OK+ZBB2o/MxpTQgmi0Mo8Ua XzzXcoZLhzXO0CgZYlg9CHOCB03DNuWlLYC90KjFQWHfjhtgvE9Gm//tlZ1lRPp7cRj6 GKT0cSvd2Cmm/kOZXytoKaRjk1b3BgfNS8TrTtCyzyq9SPNOCfyzI9J60fA2lM4fmPIC c9tQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695278630; x=1695883430; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=/j+qHBmrik+LJfC9WNjkzAwkK7SX23Waj6Cd1Jt4FfI=; b=eI14V6/znYDMrF4bPXGKITyr8iVUA31INc0iYHopo7OFJVrrFipO7n77xsU9jLXNb9 ZAeWGdmGF6yIRtc+Wp/2Wnp9kKp2n425xZHrtE2X/Bg7F+OHyqbqPE7jHcRLF5GtQ9gq fc7m4/0haC310pQYjp++0nwxjj7LTub0GmQNgwDyQOePgP8YPS1u9hBcKROOSMuYzCYn +v5hzqFaeoxnSboy1CU25DR3lianiy4dKCv+Pw9zHOrjFPb314sWBlwzTdznn8TlwAN8 WKa2umDlEGvqSl8/hVtLFHSXTsLH5NF3Qa2D7RDUSQMJlEt6aWTtvTGpLgDd3gPJzEWG bdZQ== X-Gm-Message-State: AOJu0YyMLk62KN0/eDTC5O77hgJx8PaVRb8wB1P5To5aNhvugku1OrX5 7TSj2oBAyytpNQ7ZKfBaouo8Hw== X-Google-Smtp-Source: AGHT+IFmTZMbQd38oamYQ7JU79NLKBrkdqAzbzJVDvgeBTZvR0evUzIvEzvWdnIAqi7fDz/n6yAylA== X-Received: by 2002:a17:906:cca:b0:9ae:420e:739b with SMTP id l10-20020a1709060cca00b009ae420e739bmr3647376ejh.46.1695278630542; Wed, 20 Sep 2023 23:43:50 -0700 (PDT) Received: from localhost.localdomain (62-46-255-1.adsl.highway.telekom.at. [62.46.255.1]) by smtp.gmail.com with ESMTPSA id lu8-20020a170906fac800b00997cce73cc7sm557465ejb.29.2023.09.20.23.43.50 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 20 Sep 2023 23:43:50 -0700 (PDT) Message-ID: Subject: Re: Changed functionality from 14.3 to 15.3 From: Laurenz Albe To: "David G. Johnston" , Erik Wienhold Cc: Michael Corey , pgsql-general@lists.postgresql.org Date: Thu, 21 Sep 2023 08:43:49 +0200 In-Reply-To: References: <6xfetyaijvqg6urzqpnwhlupztiyz7w2x5tlibn23oifqm344z@gpvbxz2fr4nq> <3hv6njioml35mptmeap7xwma5hvxu4s4h4vjvl7j2nvbbpjggz@y4afouuumdfi> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-09-20 at 14:24 -0700, David G. Johnston wrote: > On Wed, Sep 20, 2023 at 2:20=E2=80=AFPM Erik Wienhold wr= ote: > > Has your 14.3 some left-over state from previous test runs?=C2=A0 I ass= ume > > the server is not re-created for each test run.=C2=A0 I was wondering i= f the > > roles may still exist and with additional memberships.=C2=A0 But then a= gain > > the script just uses CREATE ROLE.=C2=A0 So the roles definitely do not = exist > > beforehand.=C2=A0 But what are the actual memberships of sten_schema? > > Because it must inherit SELECT on ref_media_code on 14.3.=C2=A0 It can'= t be > > from object_creator because that role also gets newly created. >=20 > 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