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 1uJwJ3-009m4i-Ng for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 15:33:33 +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 1uJwJ2-0098xb-F6 for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 15:33:32 +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 1uJwJ2-0098xT-3j for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 15:33:32 +0000 Received: from mail-oa1-x32.google.com ([2001:4860:4864:20::32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uJwJ0-000DyX-1L for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 15:33:31 +0000 Received: by mail-oa1-x32.google.com with SMTP id 586e51a60fabf-2c2c754af3cso2640076fac.3 for ; Tue, 27 May 2025 08:33:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748360009; x=1748964809; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=32Vg3XVpJNhBsGwNba7L1tGTQXacDi3XU7OtvgLI0WA=; b=gJQryQ3JKvKLo43SimQGbBysFK+4at4avn8YNZGUFtQa22VjC1XQk2NI5SKryXa1L4 9vIKmlmhg74df/xXH0xradUFFD///JshbnR+SwA839LABOz/sTK3oOsE79JmKifSEBwo GwJSYRm+SuWkY8YBsBIxu3lA9sDXy3CX4NFStLpxL5guFxyOSi0NnxGXiOA3nIFA6pD3 GU1cgnykYOoy1fLGQs+8WtINTf26hHXi6x55eVsgXlIE/K7S6cqEv5pTEZRW4P9B+Etu IlzeS2fra9FDlb2diTUstq9FwfP/lWci/Vwu6fdNj1cLdukmgTqe3OAXAtC/7y4NyLDS JZng== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748360009; x=1748964809; h=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=32Vg3XVpJNhBsGwNba7L1tGTQXacDi3XU7OtvgLI0WA=; b=TUPQR1cDA8noHlfdNr9oEolXVXaQVy4n19hGEmhRCdqWSeO0vsh76CaYu8zy71QS/0 9yDOntlT8AsE4WyyHJ9ZJsXY8hazyvqKNKWX2ZTHJCks9DS0vJa1buhtrhEtsh/XM1Ck AlZDBC+MRZ0oSCrY7I3I3PJ3zPx5GOfVT8v2JoUdiGaHAuOEuivFrCoWxomyy8Lh4H4E RIjMi9S+wbajAdI2n4vQFCD+kK1fprC+5PKltSvJBPJTcqI9oE1gnsMQEEunHQ0x/QbI clHfFvCoR1A+XCfZUEIMY9Vtq1uPzMuzlNWlzqftqQCG/uJPAXEhmNR5GZzUPiH/dUdI ezjw== X-Gm-Message-State: AOJu0Yy62FCkPnca33XD077cJWmjZZnz/3AsI17b2U0N6Tb5zcmvhaTj izPeP9RH/ngtk/6oYtF4v4bTpJRpoZDlZ0dR0xoAa9DIYbeIjDy086s6ySEIu9Rf2vIc9awNJxI CrVUQjHLHKYwXNJ+CQvulwwo5g4JYPavLpw== X-Gm-Gg: ASbGnct13CMrtbTwVMyhn0wmLUadwf72CNLx1hLT8KjLl6Z8jDwsHWfJU3rp2kRWDDs g6TfFz66Ai7POPQfdAi4rw9/HQgTpPRVLfcFai2I9g1VQeEc2y7gWdXcbXea8zsTvjhQHek3yk3 w/dTNx8H6OY6v4CkX69KvynlmDHYrFKKAHgQ== X-Google-Smtp-Source: AGHT+IEGBPOLBSUmfvF8PGxdRHrdLUk6ZEBS2u4n+Ke6lnz95+4/Ft/C9lUJK5zTsiI/VSVJUKmYZObcHtA0hggnN3Q= X-Received: by 2002:a05:6871:849b:20b0:2e8:7399:884a with SMTP id 586e51a60fabf-2e873999296mr4467254fac.29.1748360009336; Tue, 27 May 2025 08:33:29 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Tue, 27 May 2025 11:33:17 -0400 X-Gm-Features: AX0GCFurN0gGKA7IIVvz-nskvroHlnqTh_uh68YEY3-jhaGW8TtB5MCR_x6VPyw Message-ID: Subject: Re: Tables in public schema To: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000004bca3b06361fc9e4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004bca3b06361fc9e4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, May 27, 2025 at 10:12=E2=80=AFAM David G. Johnston < david.g.johnston@gmail.com> wrote: > On Tue, May 27, 2025 at 7:02=E2=80=AFAM Edwin UY wro= te: > >> Will I have to redo the grants? >> > > If you use "alter table set schema" the table OID will not change and the > grants should follow it. Users would be subject to whatever new > permissions apply to the newly created schema rather than the public sche= ma > though. > And he'll either have to SET SEARCH_PATH or manually qualify every CREATE TABLE statement with the correct schema name. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000004bca3b06361fc9e4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, May 27, 2025 at 10:12=E2=80=AFAM = David G. Johnston <david.g= .johnston@gmail.com> wrote:
On Tue, May 27, 20= 25 at 7:02=E2=80=AFAM Edwin UY <edwin.uy@gmail.com> wrote:
Will I have to redo the grants?

If you use "alter table set schema" the table OID = will not change and the grants should=C2=A0follow it.=C2=A0 Users would be = subject to whatever new permissions apply to the newly created schema rathe= r than the public schema though.

=C2=A0And he'll either have to SET SEARCH_PATH or manually qual= ify every CREATE TABLE statement with the correct schema name.
<= div>
--
Death to <Redacted&g= t;, and butter sauce.
Don't boil me, I'm still alive.
<= div><Redacted> lobster!
--0000000000004bca3b06361fc9e4--