Re: What's the point of allow_system_table_mods? - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: What's the point of allow_system_table_mods?
Date
Msg-id 87v9yignb5.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: What's the point of allow_system_table_mods?  (Andres Freund <andres@anarazel.de>)
Responses Re: What's the point of allow_system_table_mods?
Re: What's the point of allow_system_table_mods?
List pgsql-hackers
>>>>> "Andres" == Andres Freund <andres@anarazel.de> writes:

 Andres> Why is it so much more dangerous? I've seen plenty of corrupted
 Andres> clusters due to people doing DML against the catalogs. I'm OK
 Andres> with adding separate GUCs for both, if we want to do that, but
 Andres> I do think we shouldn't allow updating the catalogs wthout
 Andres> having having the superuser explicitly opt into that.

Be aware that a nonzero number of extensions (postgis especially) do
catalog DML in their install or update scripts. While you might well
think they shouldn't do that, in practice there is usually no viable
alternative.

-- 
Andrew (irc:RhodiumToad)



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Why is infinite_recurse test suddenly failing?
Next
From: Tom Lane
Date:
Subject: Re: What's the point of allow_system_table_mods?