On Fri, Oct 2, 2026 at 10:54 AM Adrian Klaver <[email protected]> wrote:
> 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 > > Excellent. Thanks! -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
