Re: Why is materialized view creation a "security-restricted operation"?

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Franz-Josef Färber <Franz-Josef(dot)Faerber(at)stmuk(dot)bayern(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why is materialized view creation a "security-restricted operation"?
Date: 2026-10-14 17:46:51
Message-ID: 26CC036A-0D6C-4B82-829F-BBDB88A5AD59@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Oct 14, 2026, at 11:38, Färber, Franz-Josef (StMUK) <Franz-Josef(dot)Faerber(at)stmuk(dot)bayern(dot)de> wrote:
>
> Yes, I would have to predefine the columns.
> In my case it's just one column, one row, which i wanted to load from an external file.
>
>
Excuse me? One column, one row is a single value. Where does the need for a view/table/relation come from?

In response to

Browse pgsql-general by date

  From Date Subject
Previous Message 2026-10-14 17:38:03 AW: Why is materialized view creation a "security-restricted operation"?