Re: BUG #14691: Isolation failure in deferrable transaction concurrent with schema change

From: Chris Pacejo <cpacejo(at)clearskydata(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14691: Isolation failure in deferrable transaction concurrent with schema change
Date: 2017-07-19 17:39:39
Message-ID: CAC8iE5hg7TcqWvm8KrbtcJaOB2PKjuzsRUSiMP3KNbWQMuTUaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Jul 17, 2017 at 1:08 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2017-07-20 06:25:33 Re: PgFDW connection invalidation by ALTER SERVER/ALTER USER MAPPING
Previous Message Tom Lane 2017-07-19 15:45:23 Re: BUG #14753: Bad selectivity estimation with functional partial index