Re: ON COMMIT options for non temporary tables

2019-11-21 Thread Michael Paquier
On Thu, Nov 21, 2019 at 05:13:31PM +0100, Laurenz Albe wrote: > How should that work for tables other than temporary tables? > Should COMMIT lock if somebody else accesses the table? Postgres does not support read uncommitted, so the table would not be visible to other sessions until the transacti

Re: ON COMMIT options for non temporary tables

2019-11-21 Thread Laurenz Albe
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 t