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 1sytUP-002tbk-Do for pgsql-general@arkaria.postgresql.org; Thu, 10 Oct 2024 13:46:02 +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 1sytUO-000lGd-Fc for pgsql-general@arkaria.postgresql.org; Thu, 10 Oct 2024 13:46:00 +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 1sytUO-000lGV-5u for pgsql-general@lists.postgresql.org; Thu, 10 Oct 2024 13:46:00 +0000 Received: from mail-oa1-x2b.google.com ([2001:4860:4864:20::2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sytUL-000D3X-Pd for pgsql-general@lists.postgresql.org; Thu, 10 Oct 2024 13:45:59 +0000 Received: by mail-oa1-x2b.google.com with SMTP id 586e51a60fabf-2883d9d2da0so445807fac.2 for ; Thu, 10 Oct 2024 06:45:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1728567957; x=1729172757; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=PCoynnT7Ml2nN3kKy1rENNZxUQDYoysZSck/pfCfsKU=; b=P6Z9bcPNG4g/+iYQdaFraBLgxA2rAPbBJzsvJvIin2DMwe1LfDicqLiTO7acO42CNG FjrYudCXbePPbEmi2DNdrMotlHQxeVxgUnr1rPhYG8C2ZinU7csNHxNsuWgDcqGItUQu LldZILvSyMPKOIr8MT/C/7ZPe+s8Q446Hsv84qmf44/pGvxTM+l7ISLMJ1R7jgFsGzGJ JwLRbgRpOgvqXNE7Gi83/mUhXJGDqQK8D3WgEGBzIDZ0SJZ/4uDWSoOdxFYGSE+1DR34 hcVgXIR4kxCBYvOMZi+wdZRo8YV18885QWjYm1nGQzBq51OyVXHAFNODEZek6BrcQzbY szbA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1728567957; x=1729172757; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=PCoynnT7Ml2nN3kKy1rENNZxUQDYoysZSck/pfCfsKU=; b=p8gJjopqY1uPoW6FzqqU/IvoAgglBWe0hYYk4FIz0KG2NuC2H9zPDkFgpVhahlqIf6 Pj7gPnEgvg5NWBzPKuOWLJKUrMYxq8HJuPwbbeI2iQetdOlNveoqdVCtSL7rMP1hSn2M me17ogmCRs7DTj3SEe5GUO9guYG4b4JW0jLObpQ/xxf802HVaxL6QnTniD6M/KugD+mU DsHBsaifhfA96x/QW0+tLH4sTBaKdP/PK13Z4VIZ7++slwlyumCvt6sl3wPICeBFfgLL yonmo4Z6KBKbKosTkPPFA3dfkJ3OhNYcBvQN/Xo18u9wtm5kBEB9+QSvEtOylDSU4qCr ZN8w== X-Gm-Message-State: AOJu0Yw6iuiWLBtHMk2ZK4FBxy+Dp3z+JrdHOl0d9sRMlswzHP6jkcPA imqiSZIGaIHP13Fxnt6auZXDL4uOG+u/EsqKk5E1x1yW0alc7Oz64ICpeUWh6CxHGrCMrW+s+G8 KZnFBaSixMJTpQG18GHrtcmhNDhA= X-Google-Smtp-Source: AGHT+IGX3nsjAbWbTGX/zIodwLEXE0xy0q9ARfUaOaUCjagUUO5u0ilyG0t22I4UNyyzDkTVcpYh3AlVkROrIefoRSo= X-Received: by 2002:a05:6871:e49b:b0:268:9f88:18ef with SMTP id 586e51a60fabf-288342b1ff5mr4014528fac.13.1728567956688; Thu, 10 Oct 2024 06:45:56 -0700 (PDT) MIME-Version: 1.0 References: <711b77fc-f9e5-4637-8a2c-9cc1a3b3f4da@ewie.name> In-Reply-To: <711b77fc-f9e5-4637-8a2c-9cc1a3b3f4da@ewie.name> From: Dominique Devienne Date: Thu, 10 Oct 2024 15:45:45 +0200 Message-ID: Subject: Re: Tablespace ACLs To: Erik Wienhold Cc: pgsql-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Oct 10, 2024 at 3:40=E2=80=AFPM Erik Wienhold wrot= e: > On 2024-10-10 14:35 +0200, Dominique Devienne wrote: > > Hi. Why isn't the ::regrole::text cast working as usual? > > Aren't the OIDs for grantor and grantee returned by acldefault() valid = ROLEs? > > You must call acldefault() with spcowner instead of oid: > > aclexplode(coalesce(spcacl, acldefault('t', spcowner))) Rah, silly me. Thanks Erik, much better now. --DD