Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggaxT-0001xY-6b for pgsql-bugs@arkaria.postgresql.org; Mon, 07 Jan 2019 19:53:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ggaxR-0000hN-E2 for pgsql-bugs@arkaria.postgresql.org; Mon, 07 Jan 2019 19:53:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggalo-0002OD-4u for pgsql-bugs@lists.postgresql.org; Mon, 07 Jan 2019 19:41:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ggall-0006th-6P for pgsql-bugs@lists.postgresql.org; Mon, 07 Jan 2019 19:41:07 +0000 Content-Type: multipart/mixed; boundary="===============1342260511295401003==" MIME-Version: 1.0 Subject: BUG #15580: ALTER TABLE with new column and ADD PRIMARY KEY throws spurious "column contains null values" To: pgsql-bugs@lists.postgresql.org From: =?utf-8?q?PG_Bug_reporting_form?= Cc: allison.kaptur@gmail.com Reply-To: allison.kaptur@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 07 Jan 2019 19:40:45 +0000 Message-ID: <15580-d1a6de5a3d65da51@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1342260511295401003== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTU4MApMb2dnZWQgYnk6ICAgICAgICAgIEFsbGlzb24gS2FwdHVyCkVt YWlsIGFkZHJlc3M6ICAgICAgYWxsaXNvbi5rYXB0dXJAZ21haWwuY29tClBvc3RncmVTUUwgdmVy c2lvbjogOS42LjIKT3BlcmF0aW5nIHN5c3RlbTogICBBbnkKRGVzY3JpcHRpb246ICAgICAgICAK CkFuIEFMVEVSIFRBQkxFIHRoYXQgYm90aCAoYSkgYWRkcyBhIHByaW1hcnkga2V5IG9uIGFuIGV4 aXN0aW5nIGNvbHVtbiBhbmQKKGIpIGFkZHMgYSBuZXcgbm90LW51bGwgY29sdW1uIGZhaWxzIHdp dGggImNvbHVtbiAnbmV3X2NvbCcgY29udGFpbnMgbnVsbAp2YWx1ZXMiLg0KDQpUb20gTGFuZSBo ZWxwZnVsbHkgYm9pbGVkIGRvd24gbXkgb3JpZ2luYWwgcHJvYmxlbSB0byBhIHNtYWxsZXIgcmVw cm86DQpyZWdyZXNzaW9uPSMgY3JlYXRlIHRhYmxlIHQxIChhIGludCk7DQpDUkVBVEUgVEFCTEUN CnJlZ3Jlc3Npb249IyBpbnNlcnQgaW50byB0MSB2YWx1ZXMoMSk7DQpJTlNFUlQgMCAxDQpyZWdy ZXNzaW9uPSMgYWx0ZXIgdGFibGUgdDEgYWRkIGNvbHVtbiBiIGZsb2F0OCBub3QgbnVsbCBkZWZh dWx0IHJhbmRvbSgpLA0KYWRkIHByaW1hcnkga2V5KGEpOw0KRVJST1I6ICBjb2x1bW4gImIiIGNv bnRhaW5zIG51bGwgdmFsdWVzDQoNClRvbSBhZGRzIChvbiBwZ3NxbC1nZW5lcmFsKToNCj4gSXQg ZmFpbHMgbGlrZSB0aGF0IGFzIGZhciBiYWNrIGFzIEkgdHJpZWQgKDguNCkuICBJJ20gZ3Vlc3Np bmcgdGhhdAp3ZSdyZQ0KZG9pbmcgdGhlIEFMVEVSIHN0ZXBzIGluIHRoZSB3cm9uZyBvcmRlciwg YnV0IGhhdmVuJ3QgbG9va2VkIGNsb3NlciB0aGFuDQp0aGF0Lg0KDQo+IEludGVyZXN0aW5nbHks IGluIHYxMSBhbmQgSEVBRCBpdCB3b3JrcyBpZiB5b3UgdXNlIGEgY29uc3RhbnQgZGVmYXVsdCwN CnN1Z2dlc3RpbmcgdGhhdCB0aGUgZmFzdC1kZWZhdWx0IGZlYXR1cmUgaXMgYXQgbGVhc3QgYWRq YWNlbnQgdG8gdGhlDQpwcm9ibGVtLg0KDQoNClR3byB3b3JrYXJvdW5kcyB0aGF0IGRvIG5vdCB0 cmlnZ2VyIHRoZSBidWc6DQoxLiBTZXR0aW5nIE5PVCBOVUxMIGluIGEgc2VwYXJhdGUgc3RlcCBm cm9tIGFkZGluZyB0aGUgY29sdW1uDQpBTFRFUiBUQUJMRSB0MQ0KICAgIEFERCBDT0xVTU4gYiBp bnQgVU5JUVVFIERFRkFVTFQgcmFuZG9tKCksDQogICAgQUREIFBSSU1BUlkgS0VZIChhKSwNCiAg ICBBTFRFUiBDT0xVTU4gYiBTRVQgTk9UIE5VTEw7DQoNCjIuIFNwbGl0dGluZyB0aGUgY29tbWFu ZCBpbnRvIHR3byBBTFRFUiBUQUJMRSBzdGF0ZW1lbnRzDQpBTFRFUiBUQUJMRSB0MQ0KICAgIEFE RCBDT0xVTU4gYiBpbnQgVU5JUVVFIE5PVCBOVUxMIERFRkFVTFQgcmFuZG9tKCk7DQpBTFRFUiBU QUJMRSBuZXdfdGFibGUNCiAgICBBREQgUFJJTUFSWSBLRVkgKGEpOw0KDQpUaGVzZSB0d28gd29y a2Fyb3VuZHMgbGVhdmUgbWUgd2l0aCB0aGUgc2FtZSB0aGVvcnkgYXMgVG9tOiBwb3N0Z3JlcyBz ZWVtcwp0byBiZSByZXdyaXRpbmcgdGhlIG9yZGVyIG9mIHRoZSBBTFRFUiBzdGVwcyBzbyB0aGF0 IE5PVCBOVUxMIGlzIGFwcGxpZWQgdG8KdGhlIG5ldyBjb2x1bW4gYmVmb3JlIHRoZSBkZWZhdWx0 IHZhbHVlcyBhcmUgc3VwcGxpZWQuCgo= --===============1342260511295401003==--