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
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