Re: pgplsql temporary tables

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Maximiliano Di Rienzo" <maxi(at)fulfill-tech(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgplsql temporary tables
Date: 2005-09-15 14:57:05
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD357@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2005-09-15 19:21:34 Re: Per-table freeze limit proposal
Previous Message Kouber Saparev 2005-09-15 14:30:10 BUG #1883: Renaming a schema leaves inconsistent sequence names