Re: Isolation of table creation

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Isolation of table creation
Дата
Msg-id 20151211084916.GL14789@awork2.anarazel.de
обсуждение исходный текст
Ответ на Isolation of table creation  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Список 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 по дате отправления:

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Isolation of table creation
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Error with index on unlogged table