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 1qyw0v-00C92Y-Nr for pgsql-docs@arkaria.postgresql.org; Fri, 03 Nov 2023 15:23:13 +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 1qyw0u-001N7R-2F for pgsql-docs@arkaria.postgresql.org; Fri, 03 Nov 2023 15:23:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qyw0t-001N7J-Qr for pgsql-docs@lists.postgresql.org; Fri, 03 Nov 2023 15:23:11 +0000 Received: from mail-wr1-x436.google.com ([2a00:1450:4864:20::436]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qyw0r-003meB-CO for pgsql-docs@lists.postgresql.org; Fri, 03 Nov 2023 15:23:10 +0000 Received: by mail-wr1-x436.google.com with SMTP id ffacd0b85a97d-32dc918d454so1275534f8f.2 for ; Fri, 03 Nov 2023 08:23:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1699024988; x=1699629788; 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=kswFyic3su1bekrtWbk2CzvwnrWWTg4hY2SbjtPWVQg=; b=spExi1XUTT8mVjLEJANcfIjt0Noo51eIxVd9KzKZCMuRK0kRQtnvxQ6rUTAgZoXlFW krXXNy7gn/Xj+AmPo3xAtAKuE4QJBJ7bvZKLSWckduanW4ShMSbOaf+Z9UHTQa+HPhOJ gFNPqAldP1Pttg6Xa6PrPBV4SAp+7F03q9pbAwvWomvwu/CaAFaMZzFa8dZr4oAHbKf2 wA+KfSI3+7QLZzpgXSO0DmX/QKZEdaJ9JjyEt6587Qyovg0WhpDvApWsvEQkGaP//dTG 4Rh4q7dT8mtLJ/N6DGq/FDB4hpPrZB2t0xXTp5bayRdqSKn3bvhWetrw98RAB7PlkGF8 TQ6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699024988; x=1699629788; 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=kswFyic3su1bekrtWbk2CzvwnrWWTg4hY2SbjtPWVQg=; b=vDg/1XFKKhU1OjcloEiecRRnJ9xmOcjm086QkYP+JEYcWxihnh48/mdv9Q5zDLzpr8 4pxNJPR2W2gkFrlcx2G7xwQFSTjroQAtjM81ees9rDHWJ6AHnEPQSK74olS3D6mWdW6s mcah1x4av49Bv8TBG/8HMIUf/kgO2WYetWjrshLqh0cZqt+vW4tFXPWZk1xRtGGpcX9g hszCYw+rt26jCYL9p8UrXG0okRUfKgw3LnAakKHgMARx1yzTo/XWZYs8B2m54XiCXOE3 s+MSQkqN8InwVf0ZAHOVNXGsuwkAVDFLgaf6K5CgzOQ2TYwVGGFsjLJM7QgAk7IA1mvg qbMw== X-Gm-Message-State: AOJu0Yy2ZeW10Ipi/GTVRHBR3ruxF/8h2JcqA5cVSKPugHjFktzmJEq3 hPAegLwfrvvqdn11pHZzAy04itJh2+oDjciR/ok= X-Google-Smtp-Source: AGHT+IHmYD8vAnA8HoZiyj0RIdsyGdeoVOsjzZ+z2oXNCSApKdQKj0O68wEMSXIOD9CLugNurigU6g== X-Received: by 2002:a5d:47ab:0:b0:32f:8255:6672 with SMTP id 11-20020a5d47ab000000b0032f82556672mr17013126wrb.49.1699024987886; Fri, 03 Nov 2023 08:23:07 -0700 (PDT) Received: from localhost.localdomain ([2001:871:260:b539:1410:61d3:4510:7322]) by smtp.gmail.com with ESMTPSA id h17-20020adff4d1000000b0031c52e81490sm2099428wrp.72.2023.11.03.08.23.07 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 03 Nov 2023 08:23:07 -0700 (PDT) Message-ID: Subject: Re: Document target_role param of ALTER DEFAULT PRIVILEGES From: Laurenz Albe To: Bruce Momjian Cc: Jordi =?ISO-8859-1?Q?Guti=E9rrez?= Hermoso , pgsql-docs@lists.postgresql.org Date: Fri, 03 Nov 2023 16:23:07 +0100 In-Reply-To: References: <72652d72e1816bfc3c05d40f9e0e0373d07823c8.camel@octave.org> <293903c1f00f9b5053c0aa388ddc2850ae537f33.camel@cybertec.at> 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 Fri, 2023-11-03 at 09:53 -0400, Bruce Momjian wrote: > On Thu, Nov 2, 2023 at 09:51:58PM -0400, Bruce Momjian wrote: > > On Wed, Nov 1, 2023 at 09:31:52PM +0100, Laurenz Albe wrote: > > > There is another patch in the current commitfest that addresses a sim= ilar > > > problem, triggered by another complaint: > > > https://commitfest.postgresql.org/45/4633/ > > >=20 > > > That patch does not cover role membership. Perhaps you could adopt t= hat > > > patch and merge the information from your patch into it. > >=20 > > Agreed. I found this doc report from 2020 with the same confusion abou= t > > what target_role means: > >=20 > > https://www.postgresql.org/message-id/flat/160003085417.31338.63919776= 53235501273%40wrigleys.postgresql.org > >=20 > > I will apply my patch tomorrow/Friday and then work on the commitfest > > one. >=20 > Okay, patch applied to all supported version. I will now work on the > similar commitfest item. Thanks! Laurenz Albe