Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Tue, 2024-03-12 at 01:02 +0200, Heikki Linnakangas wrote:
>> I guess we need to allow creating such internal temporary tables,
>> despite the missing permission. That'll need some careful analysis to
>> make sure we don't accidentally allow creating other temporary tables...
> Wouldn't it be sufficient to document that fact, perhaps add an
> error hint and require the MV owner to have TEMP on the database?
+1. I don't see a need for this to be a low-permissions feature.
regards, tom lane