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 1syuQw-0030Gs-Kx for pgsql-general@arkaria.postgresql.org; Thu, 10 Oct 2024 14:46:31 +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 1syuQv-001gjK-R2 for pgsql-general@arkaria.postgresql.org; Thu, 10 Oct 2024 14:46:30 +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 1syuQv-001gj4-GL for pgsql-general@lists.postgresql.org; Thu, 10 Oct 2024 14:46:29 +0000 Received: from mail-oo1-xc35.google.com ([2607:f8b0:4864:20::c35]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1syuQt-000DRb-FX for pgsql-general@lists.postgresql.org; Thu, 10 Oct 2024 14:46:28 +0000 Received: by mail-oo1-xc35.google.com with SMTP id 006d021491bc7-5e8038d4931so577048eaf.2 for ; Thu, 10 Oct 2024 07:46:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1728571586; x=1729176386; 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=g8KDUbULJH5HoiEKm7+XTo1qQRU0sU2i0jnkLdAnucA=; b=c8skE7g2XyrmygayxWfMxac/9TzY169Ua9xR2FBgEWm3sGJD6tko5V/oNzxe1utUTV cZYB9Ru2mRyruSe33lk1ofllpwVNTKnHt507fjFHsjr4AsTr1Jg7q2TMGhtVxzub9pP+ ZSM7P9jegnq7LI1SlCXs77M7O5IvNnFxJ9JqRUXiG6/00O3lbHSq2LmuvgBtOOZa18Z2 6j0fp6WH/KdOUWsdFfa6zF7C8vpto2AZ9jJeR4rvA2XP0UsNRMF+DR9YgOEcHJB9ar/1 09bkvwz4G9Jv//tyjRygzqEgxn2kvhgW+DF0S7x8rj1Q62/qhWl+lWoSvCw+5YcLzVCB 0gIQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1728571586; x=1729176386; 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=g8KDUbULJH5HoiEKm7+XTo1qQRU0sU2i0jnkLdAnucA=; b=WQo2VXnvP+2AUiKlxRCWUI4pFFQI3WXnEHaGoTJp40kGtRBsOzEW7TNRt/DXfi5H9K YTkrRxXfQqhn5jmvX3peepf5OsY4I9DeBqDqP8sxLucx7IpZvUa4pgmYATnXtsD4kF3B H8H1MiC2snGocUxiNmLNCRDCx3oGow+Wn2Z6l/LabE+6YAvLVyzZn0+cLG/tRs3G/hpV 4CnH3w5iMq5q1B1rLrjMAvExz0vvCGxpkUGc4JDAI8j7BPAS5Uvsxniy1JQ1IReTtpNE cqdTV3cqSuhUEKYk3uX2vQW6CivHT176yQK5Qq2I8T2+rfa15lQMTy6v4HMwv+N8Lhss AFCw== X-Gm-Message-State: AOJu0YxRRnHeqt444lno1YJSczhrhAHssUj7AOC3XE/OMKeJx0XqFavG G8jdeZAPx2WdprP4GqySBG03yecVm1OBjDO90gMr5yjgvTQBgXcjlk5i9R6n5qxu3ZvzEGgYUc3 tf7Abg2mQLOVrrivyz6zzGwDT/zw= X-Google-Smtp-Source: AGHT+IHdmqkjYDaxq2j78txco9QP7STrUdlhcx/jIdU2tWgoRaAQ+klZsEZQ1jve2xJQq2vjW4zdvrXtA1gqxLz6UyQ= X-Received: by 2002:a05:6870:89a8:b0:270:46be:9534 with SMTP id 586e51a60fabf-2883434b1f0mr4495480fac.24.1728571586410; Thu, 10 Oct 2024 07:46:26 -0700 (PDT) MIME-Version: 1.0 References: <711b77fc-f9e5-4637-8a2c-9cc1a3b3f4da@ewie.name> <833a8d75-09d7-4691-85bc-1ae0d16097e2@ewie.name> <04e246e5-6808-4050-871d-07efc1cea715@ewie.name> In-Reply-To: <04e246e5-6808-4050-871d-07efc1cea715@ewie.name> From: Dominique Devienne Date: Thu, 10 Oct 2024 16:46:15 +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 4:19=E2=80=AFPM Erik Wienhold wrot= e: > > > On 2024-10-10 14:35 +0200, Dominique Devienne wrote: > > > > On a related but different matter, is it normal not having access t= o a > > > > single tablespace makes the whole output disappear? > On second thought, just guarding the pg_tablespace_size() call and > reporting an unknown size when permissions are insufficient is better, > so that \db+ still lists all tablespaces like \db does. FWIW, I agree. --DD