On 10/2/26 3:19 AM, Ron Johnson wrote:
On Thu, Oct 1, 2026 at 8:35 PM David G. Johnston
<[email protected] <mailto:[email protected]>> wrote:
On Thu, Oct 1, 2026 at 4:56 PM Ron Johnson <[email protected]
<mailto:[email protected]>> 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
[email protected]
