Re: Isolation of table creation - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Isolation of table creation
Date
Msg-id 20151211084916.GL14789@awork2.anarazel.de
Whole thread Raw
In response to Isolation of table creation  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
List 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



pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Isolation of table creation
Next
From: Andres Freund
Date:
Subject: Re: Error with index on unlogged table