| From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What's the point of allow_system_table_mods? |
| Date: | 2019-05-10 18:51:10 |
| Message-ID: | 87v9yignb5.fsf@news-spur.riddles.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>>>>> "Andres" == Andres Freund <andres(at)anarazel(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-05-10 19:00:18 | Re: What's the point of allow_system_table_mods? |
| Previous Message | Andres Freund | 2019-05-10 18:27:07 | Re: Why is infinite_recurse test suddenly failing? |