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 1qwGsC-00AkuT-W6 for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Oct 2023 07:03:12 +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 1qwGsB-00CJ9E-6i for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Oct 2023 07:03:11 +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 1qwGsA-00CJ7X-TW for pgsql-hackers@lists.postgresql.org; Fri, 27 Oct 2023 07:03:10 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qwGs7-002X0B-HS for pgsql-hackers@lists.postgresql.org; Fri, 27 Oct 2023 07:03:09 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-9a58dbd5daeso262638166b.2 for ; Fri, 27 Oct 2023 00:03:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1698390185; x=1698994985; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=s+5DKtsXjZw2jcLaXddUhl4QGvMgVLGt0Hr4f5i634o=; b=RqNWKD9xIzDy0NbQwjHlpTySK7ijtPeW94xWvszM7WfcNkAmCzAy7tj6UEVVXes3qY 8zocH43zSG1Cjwt3WXYwYFQ3T7UMIpMguQSmPCDZiTehf+TcThx3qSCJY8Fy9OYgwjde IMWyWSmEtUFwXjuANS4RKlnGMboGUHhB6hERFQ0s4pxQzrANrb7P7thapx22fmUhNLr4 iKM9FHwm5oYtGXGN00qdLbjQtAORtj4GHbDTzvHG4Lpn/t5P/nQ0ikUgrmbzDk0YNeiU UWTPg4LN6HsPcgVhBO52QpEv0avS0EPGyXpHsJRRovBap42QkB2z/i6SSGuwxoyacoSf SQVA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698390185; x=1698994985; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=s+5DKtsXjZw2jcLaXddUhl4QGvMgVLGt0Hr4f5i634o=; b=pxnY+BZGJQnT8U8NxiV1lRNPZq6uxIl3jhTNLxQMlnTnVjjKoeCWcFn89TE/STcplP BGcWUGhQ9bLdL8uAI4A/b8aB8wIxK+p4Qg8VxTRBojrUMWbelzzxmcZrNaST2WGP1vBy S1wIZ6so+T+opSiaDNJeuBcftiDq5GY5pPMAzkX04FHQzaEz4k1PA494KcW1a35sxsou TtUvhyLAtk04VsLC7V35hvrcR5V08vXOYTum1MOgOd123RRJ2XaCMjofGbTCepYKJzgw OCSZyUemqmMY6KkwB6NcjKvkS7HzZID0CXcwqRaPgQtmE9RjcHv94VAKErQnulqP2qww KN9w== X-Gm-Message-State: AOJu0YzQ0BwQy1X+W4wctOYSH5/CSPNBaaOq0ct5xQB6ysNALASBePJg PQ4443nFwkSi6PyR/FYamorJbA== X-Google-Smtp-Source: AGHT+IG44RL80MkEkHwT0JduxD16dOrolrcippFKTvPvuLGTAQwGOjXZYclEXiJk53qMJsz3439v1Q== X-Received: by 2002:a17:906:6547:b0:9ae:7870:1539 with SMTP id u7-20020a170906654700b009ae78701539mr1398205ejn.76.1698390185087; Fri, 27 Oct 2023 00:03:05 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:9ed1:f603:606a:d25e:a194]) by smtp.gmail.com with ESMTPSA id kb23-20020a1709070f9700b009930042510csm713793ejc.222.2023.10.27.00.03.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 27 Oct 2023 00:03:04 -0700 (PDT) Message-ID: Subject: Re: Version 14/15 documentation Section "Alter Default Privileges" From: Laurenz Albe To: David Burns , pgsql-hackers@lists.postgresql.org Date: Fri, 27 Oct 2023 09:03:04 +0200 In-Reply-To: References: <4a6f157edc4ae38a2050a5893e6729cbb98113bc.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, 2022-11-04 at 10:49 +0100, Laurenz Albe wrote: > On Thu, 2022-11-03 at 11:32 +0100, Laurenz Albe wrote: > > On Wed, 2022-11-02 at 19:29 +0000, David Burns wrote: > >=20 > > > Some additional clarity in the versions 14/15 documentation would be = helpful specifically > > > surrounding the "target_role" clause for the ALTER DEFAULT PRIVILEGES= command. > > > To the uninitiated, the current description seems vague.=C2=A0 Maybe = something like the following would help: >=20 > After some more thinking, I came up with the attached patch. I'm sending a reply to the hackers list, so that I can add the patch to the= commitfest. Yours, Laurenz Albe