Re: Isolation of table creation

From: Andres Freund <andres(at)anarazel(dot)de>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Isolation of table creation
Date: 2015-12-11 08:49:16
Message-ID: 20151211084916.GL14789@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2015-12-11 11:46:11 +0300, Alexander Korotkov wrote:
> I discovered interesting issue with PostgreSQL transaction isolation.
> When transaction is in repeatable read isolation level, I can't see table
> which was created after transaction obtained snapshot. But I can run DML
> statements with this table. See example below.

> Is it a bug?

No, that's pretty much expected. Parse analysis, planning use fresh
catalog snapshot, whereas psql's schema queries use the transaction
snapshot.

Andres

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2015-12-11 09:34:13 Re: Error with index on unlogged table
Previous Message Alexander Korotkov 2015-12-11 08:46:11 Isolation of table creation