Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mTWUC-00009h-C5 for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Sep 2021 21:42:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mTWUB-0006tw-8U for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Sep 2021 21:42:31 +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 1mTW3g-0006w2-Lb for pgsql-bugs@lists.postgresql.org; Thu, 23 Sep 2021 21:15:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mTW3e-0001If-0h for pgsql-bugs@lists.postgresql.org; Thu, 23 Sep 2021 21:15:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=r9UX2Yaf/GjnuA90KlF9zcL7TueGwgCNm7JuLXx8RVw=; b=aExcCflivNIRlx6vfAmn6OQFzs UQwkjWYSRvUdxxKhaX/CZ25KtXmi9wvjMBRs3kRzADnjRK2nZjz/SEHdbZ0frvjN+71aqOP2B6Fnk NIh6hLlwUikslpwKay/MHZaMItfaiGTmdjNhER+lS/8Ro4HGWXd+o10kECG+0+dsSKWY+jT3F1KH0 PLNN3jMQTchOcCGho5KFwHBFDkWIgSRr0uNb7kru7zPyl+M8r/TN+AdtycQmogwllfb9Iy/7KYW/7 +CouyVNBGHNLurvmidmGVj2lCrDrFBU8lE076XEwm1xMiFrHL3LkS6fvsXPELngIiJ+POUxDK+Mb+ D9vj2PLA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mTW3c-0004Hx-4n for pgsql-bugs@lists.postgresql.org; Thu, 23 Sep 2021 21:15:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mTW3a-0004nm-Kz for pgsql-bugs@lists.postgresql.org; Thu, 23 Sep 2021 21:15:02 +0000 Content-Type: multipart/mixed; boundary="===============1803548277377402620==" MIME-Version: 1.0 Subject: BUG #17202: GENERATED BY DEFAULT AS IDENTITY not inherited (but SERIAL is) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ehuels@gmail.com Reply-To: ehuels@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 23 Sep 2021 21:14:06 +0000 Message-ID: <17202-c8185405bc872f6e@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1803548277377402620== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzIwMgpMb2dnZWQgYnk6ICAgICAgICAgIEVyaWsgSHVlbHNtYW5uCkVt YWlsIGFkZHJlc3M6ICAgICAgZWh1ZWxzQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEy LjgKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgTGludXggMjAuMDQgKHJ1bm5pbmcgYSBEb2Nr ZXIgY29udGFpbmVyKQpEZXNjcmlwdGlvbjogICAgICAgIAoKV2hpbGUgY2hhbmdpbmcgdGhlIGRl ZmluaXRpb24gb2YgYSBwYXJlbnQgdGFibGUgZnJvbSB0aGUgbm9uLXN0YW5kYXJkIFNFUklBTApj b2x1bW4gdHlwZSB0byB0aGUgU1FMIEFOU0kgc3RhbmRhcmQgImludGVnZXIgR0VORVJBVEVEIEJZ IERFRkFVTFQgQVMKSURFTlRJVFkiLCBJJ20gZmluZGluZyBhIGRpZmZlcmVuY2Ugb24gdGhlIHJl c3VsdGluZyBjb2x1bW5zIGluIHRoZSBjaGlsZAp0YWJsZS4NCg0KV2l0aCB0aGUgIlNFUklBTCIg Y29sdW1uIGRlY2xhcmF0aW9uIGFuZCB0aGVzZSB0YWJsZSBkZWZpbml0aW9uczoNCg0KQ1JFQVRF IFRBQkxFIG5vdGUgKGlkIHNlcmlhbCBwcmltYXJ5IGtleSwNCiAgICAgICAgICAgICAgICAgICBu b3RlX2NsYXNzIGludGVnZXIgbm90IG51bGwgcmVmZXJlbmNlcyBub3RlX2NsYXNzKGlkKSwNCiAg ICAgICAgICAgICAgICAgICBub3RlIHRleHQgbm90IG51bGwsDQogICAgICAgICAgICAgICAgICAg dmVjdG9yIHRzdmVjdG9yIG5vdCBudWxsIGRlZmF1bHQgJycsDQogICAgICAgICAgICAgICAgICAg Y3JlYXRlZCB0aW1lc3RhbXAgbm90IG51bGwgZGVmYXVsdCBub3coKSwNCiAgICAgICAgICAgICAg ICAgICBjcmVhdGVkX2J5IHRleHQgREVGQVVMVCBTRVNTSU9OX1VTRVIsDQogICAgICAgICAgICAg ICAgICAgcmVmX2tleSBpbnRlZ2VyIG5vdCBudWxsLA0KICAgICAgICAgICAgICAgICAgIHN1Ympl Y3QgdGV4dCk7DQogDQpDUkVBVEUgVEFCTEUgZW50aXR5X25vdGUoDQogICAgICBlbnRpdHlfaWQg aW50IHJlZmVyZW5jZXMgZW50aXR5KGlkKSwNCiAgICAgIHByaW1hcnkga2V5KGlkKSkgSU5IRVJJ VFMgKG5vdGUpOw0KDQpJJ20gZ2V0dGluZyB0aGlzIG91dHB1dCBmb3IgJ1xkJzoNCg0KIA0KZXhp c3Rpbmc9IyBcZCBub3RlDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg VGFibGUgInB1YmxpYy5ub3RlIg0KICAgQ29sdW1uICAgfCAgICAgICAgICAgIFR5cGUgICAgICAg ICAgICAgfCBDb2xsYXRpb24gfCBOdWxsYWJsZSB8ICAgICAgICAgIAogIERlZmF1bHQgICAgICAg ICAgICAgIA0KLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0t LS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIGlk ICAgICAgICAgfCBpbnRlZ2VyICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3Qg bnVsbCB8Cm5leHR2YWwoJ25vdGVfaWRfc2VxJzo6cmVnY2xhc3MpDQogbm90ZV9jbGFzcw0KfCBp bnRlZ2VyICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8IA0KIG5v dGUgICAgICAgfCB0ZXh0ICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3Qg bnVsbCB8IA0KIHZlY3RvciAgICAgfCB0c3ZlY3RvciAgICAgICAgICAgICAgICAgICAgfCAgICAg ICAgICAgfCBub3QgbnVsbCB8CicnOjp0c3ZlY3Rvcg0KIGNyZWF0ZWQgICAgfCB0aW1lc3RhbXAg d2l0aG91dCB0aW1lIHpvbmUgfCAgICAgICAgICAgfCBub3QgbnVsbCB8IG5vdygpDQogY3JlYXRl ZF9ieSB8IHRleHQgICAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAg IHwKU0VTU0lPTl9VU0VSDQogcmVmX2tleSAgICB8IGludGVnZXIgICAgICAgICAgICAgICAgICAg ICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwgDQogc3ViamVjdCAgICB8IHRleHQgICAgICAgICAg ICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwgDQpJbmRleGVzOg0KICAgICJu b3RlX3BrZXkiIFBSSU1BUlkgS0VZLCBidHJlZSAoaWQpDQpGb3JlaWduLWtleSBjb25zdHJhaW50 czoNCiAgICAibm90ZV9ub3RlX2NsYXNzX2ZrZXkiIEZPUkVJR04gS0VZIChub3RlX2NsYXNzKSBS RUZFUkVOQ0VTCm5vdGVfY2xhc3MoaWQpDQpOdW1iZXIgb2YgY2hpbGQgdGFibGVzOiA2IChVc2Ug XGQrIHRvIGxpc3QgdGhlbS4pDQogDQpleGlzdGluZz0jIFxkIGludm9pY2Vfbm90ZQ0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgVGFibGUgInB1YmxpYy5pbnZvaWNlX25vdGUi DQogICBDb2x1bW4gICB8ICAgICAgICAgICAgVHlwZSAgICAgICAgICAgICB8IENvbGxhdGlvbiB8 IE51bGxhYmxlIHwgICAgICAgICAgCiAgRGVmYXVsdCAgICAgICAgICAgICAgDQotLS0tLS0tLS0t LS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogaWQgICAgICAgICB8IGludGVnZXIg ICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwKbmV4dHZhbCgnbm90 ZV9pZF9zZXEnOjpyZWdjbGFzcykNCiBub3RlX2NsYXNzIHwgaW50ZWdlciAgICAgICAgICAgICAg ICAgICAgIHwgICAgICAgICAgIHwgbm90IG51bGwgfCANCiBub3RlICAgICAgIHwgdGV4dCAgICAg ICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgbm90IG51bGwgfCANCiB2ZWN0b3IgICAg IHwgdHN2ZWN0b3IgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgbm90IG51bGwgfAon Jzo6dHN2ZWN0b3INCiBjcmVhdGVkICAgIHwgdGltZXN0YW1wIHdpdGhvdXQgdGltZSB6b25lIHwg ICAgICAgICAgIHwgbm90IG51bGwgfCBub3coKQ0KIGNyZWF0ZWRfYnkgfCB0ZXh0ICAgICAgICAg ICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCAgICAgICAgICB8ClNFU1NJT05fVVNFUg0KIHJl Zl9rZXkgICAgfCBpbnRlZ2VyICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3Qg bnVsbCB8IA0KIHN1YmplY3QgICAgfCB0ZXh0ICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAg ICAgICAgfCAgICAgICAgICB8IA0KSW5kZXhlczoNCiAgICAiaW52b2ljZV9ub3RlX3BrZXkiIFBS SU1BUlkgS0VZLCBidHJlZSAoaWQpDQogICAgImludm9pY2Vfbm90ZV9pZF9pZHgiIGJ0cmVlIChp ZCkNCiAgICAiaW52b2ljZV9ub3RlX3ZlY3RvcnNfaWR4IiBnaXN0ICh2ZWN0b3IpDQpGb3JlaWdu LWtleSBjb25zdHJhaW50czoNCiAgICAiaW52b2ljZV9ub3RlX3JlZl9rZXlfZmtleSIgRk9SRUlH TiBLRVkgKHJlZl9rZXkpIFJFRkVSRU5DRVMKaW52b2ljZShpZCkNCkluaGVyaXRzOiBub3RlDQog DQpBcyB5b3UgY2FuIHNlZSwgYm90aCB0aGUgIm5vdGUiIGFuZCAiaW52b2ljZV9ub3RlIiB0YWJs ZXMgaGF2ZSBhIGRlZmF1bHQKIm5leHR2YWwiIGZ1bmN0aW9uIGFwcGxpZWQgdG8gdGhlICJpZCIg Y29sdW1uLiBXaGVuIEkgY2hhbmdlICJTRVJJQUwiIHRvCiJpbnRlZ2VyIGdlbmVyYXRlZCBieSBk ZWZhdWx0IEFTIElERU5USVRZIHByaW1hcnkga2V5IiBhcyBkZW1vbnN0cmF0ZWQKYmVsb3csIHRo ZSBvdXRwdXQgb2YgJ1xkJyBjaGFuZ2VzIHRvOg0KDQpSRUFURSBUQUJMRSBub3RlIChpZCBpbnRl Z2VyIGdlbmVyYXRlZCBieSBkZWZhdWx0IEFTIElERU5USVRZIHByaW1hcnkga2V5LA0KICAgICAg ICAgICAgICAgICAgIG5vdGVfY2xhc3MgaW50ZWdlciBub3QgbnVsbCByZWZlcmVuY2VzIG5vdGVf Y2xhc3MoaWQpLA0KICAgICAgICAgICAgICAgICAgIG5vdGUgdGV4dCBub3QgbnVsbCwNCiAgICAg ICAgICAgICAgICAgICB2ZWN0b3IgdHN2ZWN0b3Igbm90IG51bGwgZGVmYXVsdCAnJywNCiAgICAg ICAgICAgICAgICAgICBjcmVhdGVkIHRpbWVzdGFtcCBub3QgbnVsbCBkZWZhdWx0IG5vdygpLA0K ICAgICAgICAgICAgICAgICAgIGNyZWF0ZWRfYnkgdGV4dCBERUZBVUxUIFNFU1NJT05fVVNFUiwN CiAgICAgICAgICAgICAgICAgICByZWZfa2V5IGludGVnZXIgbm90IG51bGwsDQogICAgICAgICAg ICAgICAgICAgc3ViamVjdCB0ZXh0KTsNCiANCkNSRUFURSBUQUJMRSBpbnZvaWNlX25vdGUocHJp bWFyeSBrZXkoaWQpKSBJTkhFUklUUyAobm90ZSk7DQogDQogDQpuZXc9IyBcZCBub3RlDQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgVGFibGUgInB1YmxpYy5ub3RlIg0K ICAgQ29sdW1uICAgfCAgICAgICAgICAgIFR5cGUgICAgICAgICAgICAgfCBDb2xsYXRpb24gfCBO dWxsYWJsZSB8ICAgICAgICAgIAogIERlZmF1bHQgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIGlkICAgICAgICAgfCBpbnRlZ2VyICAg ICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8IGdlbmVyYXRlZApieSBk ZWZhdWx0IGFzIGlkZW50aXR5DQogbm90ZV9jbGFzcyB8IGludGVnZXIgICAgICAgICAgICAgICAg ICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwgDQogbm90ZSAgICAgICB8IHRleHQgICAgICAg ICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwgDQogdmVjdG9yICAgICB8 IHRzdmVjdG9yICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwKJyc6 OnRzdmVjdG9yDQogY3JlYXRlZCAgICB8IHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZSB8ICAg ICAgICAgICB8IG5vdCBudWxsIHwgbm93KCkNCiBjcmVhdGVkX2J5IHwgdGV4dCAgICAgICAgICAg ICAgICAgICAgICAgIHwgICAgICAgICAgIHwgICAgICAgICAgfApTRVNTSU9OX1VTRVINCiByZWZf a2V5ICAgIHwgaW50ZWdlciAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgbm90IG51 bGwgfCANCiBzdWJqZWN0ICAgIHwgdGV4dCAgICAgICAgICAgICAgICAgICAgICAgIHwgICAgICAg ICAgIHwgICAgICAgICAgfCANCkluZGV4ZXM6DQogICAgIm5vdGVfcGtleSIgUFJJTUFSWSBLRVks IGJ0cmVlIChpZCkNCkZvcmVpZ24ta2V5IGNvbnN0cmFpbnRzOg0KICAgICJub3RlX25vdGVfY2xh c3NfZmtleSIgRk9SRUlHTiBLRVkgKG5vdGVfY2xhc3MpIFJFRkVSRU5DRVMKbm90ZV9jbGFzcyhp ZCkNCk51bWJlciBvZiBjaGlsZCB0YWJsZXM6IDYgKFVzZSBcZCsgdG8gbGlzdCB0aGVtLikNCiAN Cm5ldz0jIFxkIGludm9pY2Vfbm90ZQ0KICAgICAgICAgICAgICAgICAgICAgICAgICBUYWJsZSAi cHVibGljLmludm9pY2Vfbm90ZSINCiAgIENvbHVtbiAgIHwgICAgICAgICAgICBUeXBlICAgICAg ICAgICAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCAgIERlZmF1bHQKICAgDQotLS0tLS0tLS0t LS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0tLQ0KIGlkICAgICAgICAgfCBpbnRlZ2VyICAgICAgICAgICAgICAgICAgICAg fCAgICAgICAgICAgfCBub3QgbnVsbCB8IA0KIG5vdGVfY2xhc3MgfCBpbnRlZ2VyICAgICAgICAg ICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8IA0KIG5vdGUgICAgICAgfCB0ZXh0 ICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8IA0KIHZlY3Rv ciAgICAgfCB0c3ZlY3RvciAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVs bCB8CicnOjp0c3ZlY3Rvcg0KIGNyZWF0ZWQgICAgfCB0aW1lc3RhbXAgd2l0aG91dCB0aW1lIHpv bmUgfCAgICAgICAgICAgfCBub3QgbnVsbCB8IG5vdygpDQogY3JlYXRlZF9ieSB8IHRleHQgICAg ICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwKU0VTU0lPTl9VU0VS DQogcmVmX2tleSAgICB8IGludGVnZXIgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8 IG5vdCBudWxsIHwgDQogc3ViamVjdCAgICB8IHRleHQgICAgICAgICAgICAgICAgICAgICAgICB8 ICAgICAgICAgICB8ICAgICAgICAgIHwgDQpJbmRleGVzOg0KICAgICJpbnZvaWNlX25vdGVfcGtl eSIgUFJJTUFSWSBLRVksIGJ0cmVlIChpZCkNCiAgICAiaW52b2ljZV9ub3RlX2lkX2lkeCIgYnRy ZWUgKGlkKQ0KICAgICJpbnZvaWNlX25vdGVfdmVjdG9yc19pZHgiIGdpc3QgKHZlY3RvcikNCkZv cmVpZ24ta2V5IGNvbnN0cmFpbnRzOg0KICAgICJpbnZvaWNlX25vdGVfcmVmX2tleV9ma2V5IiBG T1JFSUdOIEtFWSAocmVmX2tleSkgUkVGRVJFTkNFUwppbnZvaWNlKGlkKQ0KSW5oZXJpdHM6IG5v dGUNCiANCg0KTm90ZSB0aGF0IHRoZSAiaWQiIGNvbHVtbiBvZiB0aGUgImludm9pY2Vfbm90ZSIg dGFibGUgZG9lc24ndCBoYXZlIHRoZQoiZ2VuZXJhdGVkIGJ5IGRlZmF1bHQgYXMgaWRlbnRpdHki LiBJJ20gZXhwZWN0aW5nIHRoZSAiaW52b2ljZV9ub3RlIiB0YWJsZSdzCiJpZCIgY29sdW1uIHRv IGhhdmUgZXhhY3RseSB0aGUgc2FtZSBkZWZpbml0aW9uIGFzIHRoZSAiaWQiIGNvbHVtbiBpbiB0 aGUKIm5vdGUiIHRhYmxlIGluIGJvdGggc2l0dWF0aW9ucyBiZWNhdXNlIHRoZSBjb2x1bW4gaXNu J3QgcmVwZWF0ZWQgaW4gdGhlCmRlZmluaXRpb24gb2YgdGhlICJpbnZvaWNlX25vdGUiIGRlZmlu aXRpb24uCgo= --===============1803548277377402620==--