Temp Tables

Поиск
Список
Период
Сортировка
От sad
Тема Temp Tables
Дата
Msg-id 200409271712.21053.sad@bankir.ru
обсуждение исходный текст
Ответ на Re: postgres rpm  (Devrim GUNDUZ <devrim@gunduz.org>)
Список pgsql-sql
Hi

I propose you again a topic for discuss.

Do you find useful the clause "ON COMMIT DELETE ROWS" ?
like Oracle allows to specify for a temporery table

And is it necessary to delete temp table from The Dictionary wherever
disconnect and recrete it each session it needed ? (I mean that some problems
better to solve with so-called GLOBAL TEMP TABLEs which are created once the
DB created and DBMS keeps them empty (by ON COMMIT DELETE ROWS) and only own
rows each user sees in a transaction)




В списке pgsql-sql по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: COUNT(*) to find records which have a certain number of dependencies
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: FOREIGN KEY and AccessExclusiveLock