On Thu, 2019-11-21 at 21:23 +0530, P V Tekawade wrote:
> 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?
How should that work for tables other than temporary tables?
Should COMMIT lock if somebody else accesses the table?
What keeps you from explicitly dropping the table right before
you commit?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com