public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ron Johnson <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Re: Tables in public schema
Date: Tue, 27 May 2025 11:33:17 -0400
Message-ID: <CANzqJaAftAp5m2ucNC_G_sp34QSH5tZ=eEvy0+Mrbv5ow8yK2g@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwauK-3-gUSj+YVMKYi0+LtmnVBaF69V_RHDem1cqC8_gQ@mail.gmail.com>
References: <CA+wokJ_OnXhaE39YzYwqdj3Hh+M81QrAFrT9X8tbUW3iGT1-gA@mail.gmail.com>
	<CAKFQuwauK-3-gUSj+YVMKYi0+LtmnVBaF69V_RHDem1cqC8_gQ@mail.gmail.com>

On Tue, May 27, 2025 at 10:12 AM David G. Johnston <
[email protected]> wrote:

> On Tue, May 27, 2025 at 7:02 AM Edwin UY <[email protected]> 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 follow it.  Users would be subject to whatever new
> permissions apply to the newly created schema rather than the public schema
> though.
>

 And he'll either have to SET SEARCH_PATH or manually qualify every CREATE
TABLE statement with the correct schema name.

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Tables in public schema
  In-Reply-To: <CANzqJaAftAp5m2ucNC_G_sp34QSH5tZ=eEvy0+Mrbv5ow8yK2g@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox