Re: pgplsql temporary tables - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: pgplsql temporary tables
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD357@Herge.rcsinc.local
Whole thread Raw
In response to pgplsql temporary tables  ("Maximiliano Di Rienzo" <maxi@fulfill-tech.com>)
List pgsql-hackers
>Hi, i didn't know where to send this, so forgive me if this isn't the
right >list.

probably general.

> compiled pl/pgsql script that "remembers" the OID of temporary tables,


Have you considered that if the temp table is created outside of the
function that uses it, this is not a problem?

Make one function, init_temp_tables() which is called after connection.
It creates all your tables so they are persistent between calls.  (FWIW,
your function is clever).

Merlin


pgsql-hackers by date:

Previous
From: "Maximiliano Di Rienzo"
Date:
Subject: pgplsql temporary tables
Next
From: Alvaro Herrera
Date:
Subject: Re: Per-table freeze limit proposal