Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jIedo-0001sR-8x for pgsql-bugs@arkaria.postgresql.org; Sun, 29 Mar 2020 20:34:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jIedG-0003ph-UT for pgsql-bugs@arkaria.postgresql.org; Sun, 29 Mar 2020 20:34:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jIedG-0003pa-OI for pgsql-bugs@lists.postgresql.org; Sun, 29 Mar 2020 20:34:10 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jIedB-0006iQ-UR for pgsql-bugs@lists.postgresql.org; Sun, 29 Mar 2020 20:34:10 +0000 Content-Type: multipart/mixed; boundary="===============1612442288310499313==" MIME-Version: 1.0 Subject: BUG #16328: Generated column and inheritance: strange default error To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: remi.cura@gmail.com Reply-To: remi.cura@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 29 Mar 2020 20:33:43 +0000 Message-ID: <16328-8ded3dc9a974cd21@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1612442288310499313== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjMyOApMb2dnZWQgYnk6ICAgICAgICAgIFLDqW1pIEN1cmEKRW1haWwg YWRkcmVzczogICAgICByZW1pLmN1cmFAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTIu MgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAxOC4wNApEZXNjcmlwdGlvbjogICAgICAgIAoK KHJlcG9zdCBmcm9tIGhhY2tlcnMpDQpJIGVuY291bnRlcmVkIGEgc3RyYW5nZSBpc3N1ZSB3aXRo IGdlbmVyYXRlZCBjb2x1bW4gYW5kIGluaGVyaXRhbmNlLg0KVGhlIGNvcmUgb2YgdGhlIHByb2Js ZW0gaXMgdGhhdCB3aGVuIGluaGVyaXRpbmcgZnJvbSBhIHRhYmxlLCB5b3UgY2FuCnJlLWRlY2xh cmUgdGhlIHNhbWUgY29sdW1uIChwcm92aWRlZCBpdCBoYXMgdGhlIHNhbWUgdHlwZSkuDQoNCkJ1 dCB3aGVuIGRvaW5nIHRoaXMgYW5kIGludHJvZHVjaW5nIGEgZ2VuZXJhdGVkIGNvbHVtbiwgYW4g ZXJyb3IgaXMgcmFpc2VkDQpgWzBBMDAwXSBFUlJPUjogY2Fubm90IHVzZSBjb2x1bW4gcmVmZXJl bmNlIGluIERFRkFVTFQgZXhwcmVzc2lvbmANCg0KVGhpcyBpcyB0b28gYmFkLCBhcyBnZW5lcmF0 ZWQgY29sdW1ucyBhcmUgYW4gYXdlc29tZSBuZXcgZmVhdHVyZS4NCkkgZG9uJ3QgdGhpbmsgdGhh dCBpcyBhbiAgZXhwZWN0ZWQgYmVoYXZpb3IsIGFuZCBhdCB0aGUgdmVyeSBsZWFzdCB0aGUgZXJy b3IKaXMgbWlzbGVhZGluZy4NCg0KSGVyZSBpcyBhIHN1cGVyIHNob3J0IHN5bnRoZXRpYyBkZW1v LCBhbG9uZyB3aXRoIDIgd29ya2Fyb3VuZHMNCmBgYFNRTA0KLS0tLSB0ZXN0aW5nIGFuIGlzc3Vl IHdpdGggaW5oZXJpdGFuY2UgYW5kIGdlbmVyYXRlZCBjb2x1bW4NCkRST1AgU0NIRU1BIElGIEVY SVNUUyB0ZXN0X2luaGVyaXRhbmNlX2FuZF9nZW5lcmF0ZWRfY29sdW1uIENBU0NBREUgOw0KQ1JF QVRFIFNDSEVNQSBJRiBOT1QgRVhJU1RTIHRlc3RfaW5oZXJpdGFuY2VfYW5kX2dlbmVyYXRlZF9j b2x1bW4gOw0KDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQot LS0gRVJST1IgKHNldCBhIGdlbmVyYXRlZCBjb2x1bW4gaW4gYW4gaW5oZXJpdGVkIHRhYmxlKQ0K RFJPUCBUQUJMRSBJRiBFWElTVFMgdGVzdF9pbmhlcml0YW5jZV9hbmRfZ2VuZXJhdGVkX2NvbHVt bi5wYXJlbnRfdGFibGUKQ0FTQ0FERTsNCkNSRUFURSBUQUJMRSB0ZXN0X2luaGVyaXRhbmNlX2Fu ZF9nZW5lcmF0ZWRfY29sdW1uLnBhcmVudF90YWJsZSgNCiAgIHNjaWVuY2VfZ3JhZGUgZmxvYXQg REVGQVVMVCAwLjcNCiAgICAsIGF2Z19ncmFkZSBmbG9hdA0KKTsNCi0tIFRISVMgUkFJU0UgVEhF IEVSUk9SIDogWzBBMDAwXSBFUlJPUjogY2Fubm90IHVzZSBjb2x1bW4gcmVmZXJlbmNlIGluCkRF RkFVTFQgZXhwcmVzc2lvbg0KRFJPUCBUQUJMRSBJRiBFWElTVFMgdGVzdF9pbmhlcml0YW5jZV9h bmRfZ2VuZXJhdGVkX2NvbHVtbi5jaGlsZF9iYXNpYzsNCkNSRUFURSBUQUJMRSB0ZXN0X2luaGVy aXRhbmNlX2FuZF9nZW5lcmF0ZWRfY29sdW1uLmNoaWxkX2Jhc2ljKA0KICAgbGl0ZXJhdHVyZV9n cmFkZSBmbG9hdCBERUZBVUxUIDAuMywNCiAgIC0tIGF2Z19ncmFkZSBmbG9hdCBpcyBpbmhlcml0 ZWQNCiAgIGF2Z19ncmFkZSBmbG9hdCBHRU5FUkFURUQgQUxXQVlTIEFTICgKKHNjaWVuY2VfZ3Jh ZGUrbGl0ZXJhdHVyZV9ncmFkZSkvMi4wICkgU1RPUkVEDQopSU5IRVJJVFMgKHRlc3RfaW5oZXJp dGFuY2VfYW5kX2dlbmVyYXRlZF9jb2x1bW4ucGFyZW50X3RhYmxlKTsNCi0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KDQoNCi0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCi0tLSBXT1JLUyAocmVtb3ZpbmcgdGhlIGNvbHVtbiBm cm9tIHBhcmVudCkNCkRST1AgVEFCTEUgSUYgRVhJU1RTIHRlc3RfaW5oZXJpdGFuY2VfYW5kX2dl bmVyYXRlZF9jb2x1bW4ucGFyZW50X3RhYmxlCkNBU0NBREU7DQpDUkVBVEUgVEFCTEUgdGVzdF9p bmhlcml0YW5jZV9hbmRfZ2VuZXJhdGVkX2NvbHVtbi5wYXJlbnRfdGFibGUoDQogICBzY2llbmNl X2dyYWRlIGZsb2F0IERFRkFVTFQgMC43DQotLSAgICAgLCBhdmdfZ3JhZGUgZmxvYXQNCik7DQot LQ0KRFJPUCBUQUJMRSBJRiBFWElTVFMgdGVzdF9pbmhlcml0YW5jZV9hbmRfZ2VuZXJhdGVkX2Nv bHVtbi5jaGlsZF9iYXNpYzsNCkNSRUFURSBUQUJMRSB0ZXN0X2luaGVyaXRhbmNlX2FuZF9nZW5l cmF0ZWRfY29sdW1uLmNoaWxkX2Jhc2ljKA0KICAgbGl0ZXJhdHVyZV9ncmFkZSBmbG9hdCBERUZB VUxUIDAuMywNCiAgIGF2Z19ncmFkZSBmbG9hdCBHRU5FUkFURUQgQUxXQVlTIEFTICgKKHNjaWVu Y2VfZ3JhZGUrbGl0ZXJhdHVyZV9ncmFkZSkvMi4wICkgU1RPUkVEDQopSU5IRVJJVFMgKHRlc3Rf aW5oZXJpdGFuY2VfYW5kX2dlbmVyYXRlZF9jb2x1bW4ucGFyZW50X3RhYmxlKTsNCi0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KDQoNCg0KLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0gVEhJUyBXT1JLUyAoZHJvcGluZyBp bmhlcml0YW5jZSwgZHJvcHBpbmcgY29sdW1uLCBjcmVhdGluZyBjb2x1bW4gd2l0aApnZW5lcmF0 aW5nLCBhZGRpbmcgaW5oZXJpdGFuY2UgKQ0KRFJPUCBUQUJMRSBJRiBFWElTVFMgdGVzdF9pbmhl cml0YW5jZV9hbmRfZ2VuZXJhdGVkX2NvbHVtbi5wYXJlbnRfdGFibGUKQ0FTQ0FERTsNCkNSRUFU RSBUQUJMRSB0ZXN0X2luaGVyaXRhbmNlX2FuZF9nZW5lcmF0ZWRfY29sdW1uLnBhcmVudF90YWJs ZSgNCiAgIHNjaWVuY2VfZ3JhZGUgZmxvYXQgREVGQVVMVCAwLjcNCiAgICAsIGF2Z19ncmFkZSBm bG9hdA0KKTsNCi0tDQpEUk9QIFRBQkxFIElGIEVYSVNUUyB0ZXN0X2luaGVyaXRhbmNlX2FuZF9n ZW5lcmF0ZWRfY29sdW1uLmNoaWxkX2Jhc2ljOw0KQ1JFQVRFIFRBQkxFIHRlc3RfaW5oZXJpdGFu Y2VfYW5kX2dlbmVyYXRlZF9jb2x1bW4uY2hpbGRfYmFzaWMoDQogICBsaXRlcmF0dXJlX2dyYWRl IGZsb2F0IERFRkFVTFQgMC4zLA0KICAgYXZnX2dyYWRlIGZsb2F0DQopSU5IRVJJVFMgKHRlc3Rf aW5oZXJpdGFuY2VfYW5kX2dlbmVyYXRlZF9jb2x1bW4ucGFyZW50X3RhYmxlKTsNCkFMVEVSIFRB QkxFIHRlc3RfaW5oZXJpdGFuY2VfYW5kX2dlbmVyYXRlZF9jb2x1bW4uY2hpbGRfYmFzaWMgTk8g SU5IRVJJVAp0ZXN0X2luaGVyaXRhbmNlX2FuZF9nZW5lcmF0ZWRfY29sdW1uLnBhcmVudF90YWJs ZTsNCkFMVEVSIFRBQkxFIHRlc3RfaW5oZXJpdGFuY2VfYW5kX2dlbmVyYXRlZF9jb2x1bW4uY2hp bGRfYmFzaWMgRFJPUCBDT0xVTU4KYXZnX2dyYWRlOw0KQUxURVIgVEFCTEUgdGVzdF9pbmhlcml0 YW5jZV9hbmRfZ2VuZXJhdGVkX2NvbHVtbi5jaGlsZF9iYXNpYw0KICAgIEFERCBDT0xVTU4gYXZn X2dyYWRlIGZsb2F0IEdFTkVSQVRFRCBBTFdBWVMgQVMgKAooc2NpZW5jZV9ncmFkZStsaXRlcmF0 dXJlX2dyYWRlKS8yLjAgKSBTVE9SRUQ7DQpBTFRFUiBUQUJMRSB0ZXN0X2luaGVyaXRhbmNlX2Fu ZF9nZW5lcmF0ZWRfY29sdW1uLmNoaWxkX2Jhc2ljIElOSEVSSVQKdGVzdF9pbmhlcml0YW5jZV9h bmRfZ2VuZXJhdGVkX2NvbHVtbi5wYXJlbnRfdGFibGU7DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpgYGANClBvc3RncmVTUUwgMTIuMiAoVWJ1bnR1IDEyLjIt Mi5wZ2RnMTguMDQrMSkgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQKYnkgZ2NjIChV YnVudHUgNy40LjAtMXVidW50dTF+MTguMDQuMSkgNy40LjAsIDY0LWJpdAoK --===============1612442288310499313==--