Postgres Pro
Downloads
Home   >   mailing lists

ON COMMIT options for non temporary tables - Mailing list pgsql-general

From P V Tekawade
Subject ON COMMIT options for non temporary tables
Date
Msg-id CAOxwpHA=9bPqPW3XJE3hQjvuuEyGcj+1W1dn8H=NG8jfAqXjwg@mail.gmail.com
Whole thread Raw
Responses Re: ON COMMIT options for non temporary tables  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view

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 by date:

Previous
From: Michael Korbakov
Date:
Subject: Adding LIMIT changes PostgreSQL plan from good to a bad one
Next
From: Adrian Klaver
Date:
Subject: Re: Help with authentication on Debain/Ubuntu installation