ON COMMIT options for non temporary tables

P V Tekawade <[email protected]> Thu, 21 Nov 2019 21:23:21 +0530

Newsgroups	gmane.comp.db.postgresql.general
Message-ID	<CAOxwpHA=9bPqPW3XJE3hQjvuuEyGcj+1W1dn8H=NG8jfAqXjwg@mail.gmail.com>

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