Re: [BUGS] BUG #14691: Isolation failure in deferrable transactionconcurrent with schema change

Поиск
Список
Период
Сортировка
От Chris Pacejo
Тема Re: [BUGS] BUG #14691: Isolation failure in deferrable transactionconcurrent with schema change
Дата
Msg-id CAC8iE5hg7TcqWvm8KrbtcJaOB2PKjuzsRUSiMP3KNbWQMuTUaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14691: Isolation failure in deferrable transactionconcurrent with schema change  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Mon, Jul 17, 2017 at 1:08 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
"Some DDL commands, currently only TRUNCATE and the table-rewriting forms of ALTER TABLE, are not MVCC-safe."

Ah thank you, I missed that.  This makes sense, since the deferrable transaction isn't taking any locks.  This information helps me to create a better workaround.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14753: Bad selectivity estimation with functional partial index
Следующее
От: buhhunyx@tut.by
Дата:
Сообщение: Re: [BUGS] BUG #14750: Seq Scan instead of Index Scan works without limitation