ON COMMIT options for non temporary tables

Поиск
Список
Период
Сортировка
От P V Tekawade
Тема ON COMMIT options for non temporary tables
Дата
Msg-id CAOxwpHA=9bPqPW3XJE3hQjvuuEyGcj+1W1dn8H=NG8jfAqXjwg@mail.gmail.com
обсуждение исходный текст
Ответы Re: ON COMMIT options for non temporary tables
Список pgsql-general
Дерево обсуждения

Hi

 

For my work with Postgres 11.5, I needed functionality that unlogged tables are automatically dropped at the commit time, but I found that ON COMMIT option is only supported with temporary table.

I would like to understand reasons why this option is limited to temporary tables? Is there any problem by making this option available for other type of tables such as unlogged tables?

 

--

Thanks

Prafulla

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

Предыдущее
От: Michael Korbakov
Дата:
Сообщение: Adding LIMIT changes PostgreSQL plan from good to a bad one
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Help with authentication on Debain/Ubuntu installation