DKIM2-Signature: i=1; m=1; t=1790952873; d=aklaver.com;
	mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+;
	rt=PHBnc3FsLWdlbmVyYWxAcG9zdGdyZXNxbC5vcmc+;
	s=fm3:rsa-sha256:FEWboNynp29yKF9t6RNcVhyh9B5IUY+VLcnd/c0Nkq6Qfjd
	Bm6+JhT5kLYyQZc4WnN0cpiVijI+Sj5WaO9nilfh3HvSLf2RtXENb7TMxY4bgry2
	WSxTKwNP1l3pEw89NO+QrqcWGR3J+CrjCPhNfV35mpPzDqXfsFXFdpX4Z0o3AOsM
	XG+TcyVF38WUV+N71aB1TYSlHGmxy1MoEZqB/UCWj9dOM3p1iZ9JN5uxmtW4SFtS
	EYmEpkIkQaq4SebsJ0EozQbjtQ8lWHFtxkMiNbfug+UD8TuOyO3jmtXEeArfagHW
	sSboAlEhH4pZQ2duPoB3lyGYcK5UkSNC4uyya+A==;
Message-Instance: m=1;
 h=sha256:5u17z7/xdWxEhGYpofwN6thEfE8nBfwA5/9Fd1J5orw=:AgldhT8HYKp/y6yaDMenyGJpItfZc8g/FzoX+gY9RuY=;
Feedback-ID: i76984098:Fastmail
Message-ID: <f6d2fca1-1ee4-4d97-8219-100dd91d8496@aklaver.com>
Date: Fri, 2 Oct 2026 07:54:31 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Why is materialized view creation a "security-restricted
 operation"?
To: Ron Johnson <ronljohnsonjr@gmail.com>,
 pgsql-general <pgsql-general@postgresql.org>
References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de>
 <61488cb9-5b84-449a-9886-e0d3b9671aa6@aklaver.com>
 <CANzqJaCa34mEGBsTKZZQz7ZwDR3jd+Q0=s2_7ayw2hHFwTMXjw@mail.gmail.com>
 <CAKFQuwZwX-L-c+=DS=_+kox_+p9AobWRWL7Fot48uAOt2t_X1Q@mail.gmail.com>
 <CANzqJaBnOOer7V+AFk1uY86+uGfFj5EUCJLA0LvYyv9KCTksxg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: 
 <CANzqJaBnOOer7V+AFk1uY86+uGfFj5EUCJLA0LvYyv9KCTksxg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/f6d2fca1-1ee4-4d97-8219-100dd91d8496%40aklaver.com>
Precedence: bulk

On 10/2/26 3:19 AM, Ron Johnson wrote:
> On Thu, Oct 1, 2026 at 8:35 PM David G. Johnston 
> <david.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>> wrote:
> 
>     On Thu, Oct 1, 2026 at 4:56 PM Ron Johnson <ronljohnsonjr@gmail.com
>     <mailto:ronljohnsonjr@gmail.com>> wrote:
> 
>         A GLOBAL TEMP table (where the DBA runs the CREATE GLOBAL TEMP
>         TABLE once (so that CREATE TEMP TABLE some_table  everywhere
>         that my_func() is called) would also solve OP's problem.
> 
> 
>     Per the create table docs:
> 
>     "Optionally, GLOBAL or LOCAL can be written before TEMPORARY or
>     TEMP. This presently makes no difference in PostgreSQL and is
>     deprecated; see Compatibility below."
> 
> And I'm praying for "since future versions of PostgreSQLmight adopt a 
> more standard-compliant interpretation of their meaning" in the 
> Compatibility section you referenced.

As an extension there is:

https://github.com/darold/pgtt

> 
> -- 
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!


-- 
Adrian Klaver
adrian.klaver@aklaver.com