Re: Dump public schema ownership & seclabels - Mailing list pgsql-hackers

From Noah Misch
Subject Re: Dump public schema ownership & seclabels
Date
Msg-id 20210117094102.GB1695558@rfd.leadboat.com
Whole thread Raw
In response to Re: Dump public schema ownership & seclabels  (Vik Fearing <vik@postgresfriends.org>)
Responses Re: Dump public schema ownership & seclabels
List 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?



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: Is Recovery actually paused?
Next
From: Vik Fearing
Date:
Subject: Re: Dump public schema ownership & seclabels