Re: Dump public schema ownership & seclabels

From: Noah Misch <noah(at)leadboat(dot)com>
To: Vik Fearing <vik(at)postgresfriends(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Dump public schema ownership & seclabels
Date: 2021-01-17 09:41:02
Message-ID: 20210117094102.GB1695558@rfd.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jan 16, 2021 at 02:05:43PM +0100, Vik Fearing wrote:
> On 12/30/20 12:59 PM, Noah Misch wrote:
> > On Tue, Dec 29, 2020 at 05:49:24AM -0800, Noah Misch wrote:
> >> https://postgr.es/m/20201031163518.GB4039133@rfd.leadboat.com gave $SUBJECT as
> >> one of the constituent projects for changing the public schema default ACL.
> >> This ended up being simple. Attached.
> >
> > This is defective; it fails to reproduce nspacl after "ALTER SCHEMA public
> > OWNER TO pg_write_server_files; REVOKE ALL ON SCHEMA public FROM
> > pg_write_server_files;". I will try again later.
>
> Could I ask you to also include COMMENTs when you try again, please?

That may work. I had not expected to hear of a person changing the comment on
schema public. To what do you change it?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vik Fearing 2021-01-17 11:00:06 Re: Dump public schema ownership & seclabels
Previous Message Dilip Kumar 2021-01-17 08:18:47 Re: Is Recovery actually paused?