Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14691: Isolation failure in deferrable transactionconcurrent with schema change - Mailing list pgsql-bugs

From Chris Pacejo
Subject Re: [BUGS] BUG #14691: Isolation failure in deferrable transactionconcurrent with schema change
Date
Msg-id CAC8iE5hg7TcqWvm8KrbtcJaOB2PKjuzsRUSiMP3KNbWQMuTUaQ@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14691: Isolation failure in deferrable transactionconcurrent with schema change  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14753: Bad selectivity estimation with functional partial index
Next
From: buhhunyx@tut.by
Date:
Subject: Re: [BUGS] BUG #14750: Seq Scan instead of Index Scan works without limitation