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

The following bug has been logged on the website:

Bug reference:      14691
Logged by:          Chris Pacejo
Email address:      cpacejo@clearskydata.com
PostgreSQL version: 9.5.7
Operating system:   CentOS 7
Description:

Hi, issuing a SERIALIZABLE DEFERRABLE READ ONLY read from a table to which a
column is being added results in an isolation failure.

me=> BEGIN; ALTER TABLE foo ADD COLUMN y integer DEFAULT 0;

me=> BEGIN; ALTER TABLE foo ADD COLUMN y integer; UPDATE foo SET y = 0;

 x | y
---+---
 1 |
 2 |
 3 |
(3 rows)