Do not use temp table

Open JamesGuthrie opened this issue 1 year ago • 1 comments

Using a temp table prohibits the extension from being installed in the context of pgextwlist, which installs extensions in a security-restricted context.

I'm opening this PR as a mechanism to start the conversation around this. It probably doesn't make sense to modify these functions in the existing install scripts.

Apr 24 '24 13:04 JamesGuthrie

PostGIS was also affected by this, see related issues:

https://github.com/dimitri/pgextwlist/issues/43
https://github.com/postgis/postgis/pull/623

Apr 25 '24 06:04 JamesGuthrie