Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fN645-0005np-Rs for pgsql-bugs@arkaria.postgresql.org; Mon, 28 May 2018 00:31:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fN644-00022u-H3 for pgsql-bugs@arkaria.postgresql.org; Mon, 28 May 2018 00:31:08 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1fN644-00022k-Ae for pgsql-bugs@lists.postgresql.org; Mon, 28 May 2018 00:31:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fN640-0007jl-FD for pgsql-bugs@lists.postgresql.org; Mon, 28 May 2018 00:31:07 +0000 Content-Type: multipart/mixed; boundary="===============3689291053251314224==" MIME-Version: 1.0 Subject: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation To: pgsql-bugs@lists.postgresql.org From: =?utf-8?q?PG_Bug_reporting_form?= Cc: juergen+postgresql@strobel.info Reply-To: juergen+postgresql@strobel.info, pgsql-bugs@lists.postgresql.org Date: Mon, 28 May 2018 00:30:21 +0000 Message-ID: <152746742177.1291.9847032632907407358@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3689291053251314224== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTIxMgpMb2dnZWQgYnk6ICAgICAgICAgIErDvHJnZW4gU3Ryb2JlbApF bWFpbCBhZGRyZXNzOiAgICAgIGp1ZXJnZW4rcG9zdGdyZXNxbEBzdHJvYmVsLmluZm8KUG9zdGdy ZVNRTCB2ZXJzaW9uOiAxMC40Ck9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuCkRlc2NyaXB0aW9u OiAgICAgICAgCgpJIGZvdW5kIHVuZXhwZWN0ZWQgYmVoYXZpb3Igd2hlbiBwbGF5aW5nIGFyb3Vu ZCB3aXRoIGRlY2xhcmF0aXZlCnBhcnRpdGlvbmluZy4NCg0KRmlyc3QsIGFueSB3YXkgdG8gZGVm aW5lIGRlZmF1bHRzIG9uIChjaGlsZCkgcGFydGl0aW9uIHRhYmxlcyBpcyBzaWxlbnRseQppZ25v cmVkIHdoZW4gaW5zZXJ0aW5nIGludG8gdGhlIG1hc3RlciB0YWJsZSwgYnV0IG5vdCB3aGVuIGlu c2VydGluZyBpbnRvCnRoZSBjaGlsZCB0YWJsZS4gVGhlIGVhc2llc3Qgd2F5IHRvIHJlcHJvZHVj ZSB0aGlzIGlzOg0KDQpqdWU9PiBjcmVhdGUgdGFibGUgcHRlc3QgKGEgaW50LCBiIGludCkgcGFy dGl0aW9uIGJ5IGxpc3QgKGEpOw0KQ1JFQVRFIFRBQkxFDQpqdWU9PiBjcmVhdGUgdGFibGUgcHRl c3QxIHBhcnRpdGlvbiBvZiBwdGVzdCAoYiBkZWZhdWx0IDcpIGZvciB2YWx1ZXMgaW4KKDEpOw0K Q1JFQVRFIFRBQkxFDQpqdWU9PiBpbnNlcnQgaW50byBwdGVzdCAoYSkgdmFsdWVzICgxKTsNCklO U0VSVCAwIDENCmp1ZT0+IHRhYmxlIHB0ZXN0Ow0KIGEgfCBiIA0KLS0tKy0tLQ0KIDEgfCAgDQoo MSByb3cpDQoNCmp1ZT0+IGluc2VydCBpbnRvIHB0ZXN0MSAoYSkgdmFsdWVzICgxKTsNCklOU0VS VCAwIDENCmp1ZT0+IHRhYmxlIHB0ZXN0Ow0KIGEgfCBiIA0KLS0tKy0tLQ0KIDEgfCAgDQogMSB8 IDcNCigyIHJvd3MpDQoNClNlY29uZCwgdGhpcyBpcyBhIHdheSB0byB2aW9sYXRlIGEgTk9UIE5V TEwgY29uc3RyYWludCwgcHJlc3VtYWJseSBiZWNhdXNlIGEKZGVmYXVsdCB2YWx1ZSBzaG91bGQg YmUgYXBwbGllZCBsYXRlciBidXQgaXNuJ3Q6DQoNCmp1ZT0+IGNyZWF0ZSB0YWJsZSBwdGVzdCAo YSBpbnQsIGIgaW50IG5vdCBudWxsKSBwYXJ0aXRpb24gYnkgbGlzdCAoYSk7DQpDUkVBVEUgVEFC TEUNCmp1ZT0+IGNyZWF0ZSB0YWJsZSBwdGVzdDEgcGFydGl0aW9uIG9mIHB0ZXN0IChiIGRlZmF1 bHQgNykgZm9yIHZhbHVlcyBpbgooMSk7DQpDUkVBVEUgVEFCTEUNCmp1ZT0+IGluc2VydCBpbnRv IHB0ZXN0IChhKSB2YWx1ZXMgKDEpOw0KSU5TRVJUIDAgMQ0KanVlPT4gc2VsZWN0ICogZnJvbSBw dGVzdCB3aGVyZSBiIGlzIG51bGw7DQogYSB8IGIgDQotLS0rLS0tDQogMSB8ICANCigxIHJvdykN Cg0KVGhlIHNhbWUgaGFwcGVucyBmb3IgZGVmYXVsdHMgdXNpbmcgbmV4dHZhbChzZXF1ZW5jZSks IGVpdGhlciBpZiBzcGVjaWZpZWQKZGlyZWN0bHkgb3IgYXMgU0VSSUFMIGNvbHVtbnMgd2l0aCBB TFRFUiBUQUJMRSAuLi4gQVRUQUNIIFBBUlRJVElPTi4gTXkKY3VycmVudCB3b3JrYXJvdW5kIGlz IHRvIHVzZSBhIGJlZm9yZS1yb3cgdHJpZ2dlciB0byBhcHBseSB0aGUgZGVmYXVsdAp2YWx1ZS4K Cg== --===============3689291053251314224==--