| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Tables in public schema |
| Date: | 2025-05-27 15:33:17 |
| Message-ID: | CANzqJaAftAp5m2ucNC_G_sp34QSH5tZ=eEvy0+Mrbv5ow8yK2g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, May 27, 2025 at 10:12 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Tue, May 27, 2025 at 7:02 AM Edwin UY <edwin(dot)uy(at)gmail(dot)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 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roland Müller | 2025-05-27 20:26:23 | Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. |
| Previous Message | Ron Johnson | 2025-05-27 15:31:43 | Re: Tables in public schema |