Re: pgplsql temporary tables

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: pgplsql temporary tables
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD357@Herge.rcsinc.local
обсуждение исходный текст
Ответ на pgplsql temporary tables  ("Maximiliano Di Rienzo" <maxi@fulfill-tech.com>)
Список 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 по дате отправления:

Предыдущее
От: "Maximiliano Di Rienzo"
Дата:
Сообщение: pgplsql temporary tables
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Per-table freeze limit proposal