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 1pWkkJ-000846-6Y for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Feb 2023 21:09:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pWkkH-0002jw-Eq for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Feb 2023 21:09:17 +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 1pWjgN-00034p-0C for pgsql-bugs@lists.postgresql.org; Mon, 27 Feb 2023 20:01:11 +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 1pWjgI-0004Yj-3A for pgsql-bugs@lists.postgresql.org; Mon, 27 Feb 2023 20:01:10 +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=fds8s8EGdqESzMFvFZDzKwUuz3TBICqjtNkXdcpHb/k=; b=wROojBP9PEUyId0cawr3qhwbsJ i2DjYN/oFSMXB1/SQ4LPh9xt2bNoxKgJEF+pr6gWi9W7pOYSsmfu1s6/VvEFEwDydsRkya95GcOvc lhkFvhQUhFxfE9L+v+SzBlcEyaMLI60eGxpAN1uDf9iFRLhjdqHxL23mAIZkPBZnEev8WncHzvL+t CMFGIfufUV5bbtEFpEgZ+0GyRGUAUmiqpf0JCEkhwg2B6X5OwND51EsMk1nl/9k7InZ5cwEB/dL3y aqlS3MNHOnrcxfwkgfqcCSX2KP5vFd+MqI3RuZr/DVN8pgktJ/YDU3zxSyHsQShqjOEtwtLqMoh0d WH9b3+fA==; 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 1pWjgG-0003Bv-4D for pgsql-bugs@lists.postgresql.org; Mon, 27 Feb 2023 20:01:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pWjgD-003W9p-6H for pgsql-bugs@lists.postgresql.org; Mon, 27 Feb 2023 20:01:02 +0000 Content-Type: multipart/mixed; boundary="===============4075715539142389337==" MIME-Version: 1.0 Subject: BUG #17811: Replacing an underlying view breaks OLD/NEW tuple when accessing it via upper-level view To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 27 Feb 2023 20:00:03 +0000 Message-ID: <17811-d31686b78f0dffc9@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 --===============4075715539142389337== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzgxMQpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKSSd2ZSBkaXNjb3ZlcmVkIGFuIGlzc3VlIHdpdGggcmVwbGFjaW5nIGEgdmlldyB3aGVu IHRoZXJlIGlzIGFub3RoZXINCnVwZGF0YWJsZSB2aWV3IGRlZmluZWQgb24gdG9wIG9mIGl0IGFu ZCB0aGUgbmV3IHVuZGVybHlpbmcgdmlldyBoYXMNCm1vcmUgY29sdW1ucyB0aGFuIHRoZSBwcmV2 aW91cyBvbmUuDQoNCkZpcnN0IGV4YW1wbGUgd2l0aCB0cmlnZ2VyczoNCkNSRUFURSBUQUJMRSB0 IChpZCBpbnQsIGYxIHRleHQpOw0KQ1JFQVRFIFZJRVcgdjEgQVMgU0VMRUNUIGlkIEZST00gdDsN CkNSRUFURSBWSUVXIHYyIEFTIFNFTEVDVCAqIEZST00gdjE7DQpDUkVBVEUgT1IgUkVQTEFDRSBW SUVXIHYxIEFTIFNFTEVDVCAqIEZST00gdDsNCkNSRUFURSBGVU5DVElPTiB2MV90cmlnX2ZuKCkg UkVUVVJOUyB0cmlnZ2VyIEFTICQkDQpCRUdJTiANCiAgUkFJU0UgTk9USUNFICdvbGQuaWQ6ICUs IG9sZC5mMTogJScsIG9sZC5pZCwgb2xkLmYxOw0KICBVUERBVEUgdCBTRVQgaWQ9bmV3LmlkIFdI RVJFIGlkPW9sZC5pZDsgDQogIFJFVFVSTiBuZXc7DQpFTkQ7ICQkIExBTkdVQUdFIHBscGdzcWw7 DQpDUkVBVEUgVFJJR0dFUiB2MV91cGRfdHJpZyBJTlNURUFEIE9GIFVQREFURSBPTiB2MQ0KIEZP UiBFQUNIIFJPVyBFWEVDVVRFIEZVTkNUSU9OIHYxX3RyaWdfZm4oKTsNCklOU0VSVCBJTlRPIHQg VkFMVUVTICgxLCAxMSksICgyLCAyMik7DQpTRUxFQ1QgKiBGUk9NIHQ7DQpVUERBVEUgdjIgU0VU IGlkID0gMyBXSEVSRSBpZCA9IDI7DQpTRUxFQ1QgKiBGUk9NIHQ7DQoNCiBpZCB8IGYxIA0KLS0t LSstLS0tDQogIDEgfCAxMQ0KICAyIHwgMjINCigyIHJvd3MpDQoNCk5PVElDRTogIG9sZC5pZDog Miwgb2xkLmYxOiA8TlVMTD4gLS0gPz8/DQpVUERBVEUgMQ0KIGlkIHwgZjEgDQotLS0tKy0tLS0N CiAgMSB8IDExDQogIDMgfCAyMg0KKDIgcm93cykNCg0KDQpidXQgaWYgbmV3IHYxICBkZWZpbmVk IHdpdGggc2VjdXJpdHlfYmFycmllcjoNCkNSRUFURSBPUiBSRVBMQUNFIFZJRVcgdjEgV0lUSCAo c2VjdXJpdHlfYmFycmllciA9IHRydWUpIEFTIFNFTEVDVCAqIEZST00KdDsNCi4uLg0KTk9USUNF OiAgb2xkLmlkOiAyLCBvbGQuZjE6IDIyLCBvbGQuZjI6IDIyMiAtLSBPSw0KDQpidXQgb24gbWFz dGVyIChhZnRlciA0N2JiOWRiNzUpDQouLi4NCk5PVElDRTogIG9sZC5pZDogMiwgb2xkLmYxOiAy Miwgb2xkLmYyOiAyMjINCldBUk5JTkc6ICBwcm9ibGVtIGluIGFsbG9jIHNldCBNZXNzYWdlQ29u dGV4dDogcmVxIHNpemUgPiBhbGxvYyBzaXplIGZvcgpjaHVuayAweDYyOTAwMDAzY2NiMCBpbiBi bG9jayAweDYyOTAwMDAzYzIwMA0KV0FSTklORzogIHByb2JsZW0gaW4gYWxsb2Mgc2V0IE1lc3Nh Z2VDb250ZXh0OiByZXEgc2l6ZSA+IGFsbG9jIHNpemUgZm9yCmNodW5rIDB4NjI5MDAwMDNjY2Iw IGluIGJsb2NrIDB4NjI5MDAwMDNjMjAwDQooSSd2ZSBzZWVuIGFsc28gcnVudGltZSBlcnJvcnMg ZGV0ZWN0ZWQgYnkgYXNhbi4pDQoNClNlY29uZCBleGFtcGxlIHdpdGggcnVsZXMgKFJFTF8xNV9T VEFCTEUgd2l0aG91dCBhc3NlcnRzKToNCkNSRUFURSBUQUJMRSB0KGlkIGludCwgZjEgaW50LCBm MiBpbnQsIGYzIGludCwgZjQgaW50KTsNCkNSRUFURSBUQUJMRSB0YyhpZCBpbnQsIGYgaW50KTsN Cg0KQ1JFQVRFIFZJRVcgdjEgQVMgU0VMRUNUIDEgQVMgaWQ7DQpDUkVBVEUgVklFVyB2MiBBUyBT RUxFQ1QgKiBGUk9NIHYxOw0KQ1JFQVRFIE9SIFJFUExBQ0UgVklFVyB2MSBXSVRIIChzZWN1cml0 eV9iYXJyaWVyID0gdHJ1ZSkgQVMgU0VMRUNUICogRlJPTQp0Ow0KDQpDUkVBVEUgUlVMRSB2MV91 cGRfcnVsZSBBUyBPTiBVUERBVEUgVE8gdjENCiAgRE8gSU5TVEVBRCAoSU5TRVJUIElOVE8gdGMg VkFMVUVTIChORVcuaWQsIE5FVy5mMSk7IFVQREFURSB0IFNFVCBpZCA9Ck5FVy5pZCBXSEVSRSBp ZCA9IE9MRC5pZDspOw0KDQpJTlNFUlQgSU5UTyB0IFZBTFVFUyAoMSwgMTEsIDExMSwgMTExMSwg MTExMTEpLCAoMiwgMjIsIDIyMiwgMjIyMiwgMjIyMjIpOw0KDQpTRUxFQ1QgKiBGUk9NIHQ7DQpT RUxFQ1QgKiBGUk9NIHYyOw0KDQpVUERBVEUgdjIgU0VUIGlkID0gMyBXSEVSRSBpZCA9IDI7DQpT RUxFQ1QgKiBGUk9NIHQ7DQpTRUxFQ1QgKiBGUk9NIHRjOw0KDQogaWQgDQotLS0tDQogIDENCiAg Mg0KKDIgcm93cykNCg0Kc2VydmVyIGNsb3NlZCB0aGUgY29ubmVjdGlvbiB1bmV4cGVjdGVkbHkN Ci4uLg0KUHJvZ3JhbSB0ZXJtaW5hdGVkIHdpdGggc2lnbmFsIFNJR1NFR1YsIFNlZ21lbnRhdGlv biBmYXVsdC4NCg0KIzAgIDB4MDAwMDU1NWIxOWNkMjJiNiBpbiBibXNfYWRkX21lbWJlcnMgKGE9 MHg4LCBiPWJAZW50cnk9MHg1NTViMWE2NDU5OTApCmF0IGJpdG1hcHNldC5jOjgwOA0KODA4ICAg ICAgICAgICAgIGlmIChhLT5ud29yZHMgPCBiLT5ud29yZHMpDQooZ2RiKSBidA0KIzAgIDB4MDAw MDU1NWIxOWNkMjJiNiBpbiBibXNfYWRkX21lbWJlcnMgKGE9MHg4LCBiPWJAZW50cnk9MHg1NTVi MWE2NDU5OTApCmF0IGJpdG1hcHNldC5jOjgwOA0KIzEgIDB4MDAwMDU1NWIxOWQyOTI3MyBpbiBh ZGRfdmFyc190b190YXJnZXRsaXN0IChyb290PTB4NTU1YjFhNjQ1MDg4LAp2YXJzPTB4NTU1YjFh NjQ1OTQwLCANCiAgICB3aGVyZV9uZWVkZWQ9MHg1NTViMWE2NDU5OTAsIGNyZWF0ZV9uZXdfcGg9 dHJ1ZSkgYXQgaW5pdHNwbGFuLmM6MjU5DQojMiAgMHgwMDAwNTU1YjE5ZDI5MzFkIGluIGJ1aWxk X2Jhc2VfcmVsX3RsaXN0cyAocm9vdD0weDU1NWIxYTY0NTA4OCwKZmluYWxfdGxpc3Q9PG9wdGlt aXplZCBvdXQ+KSBhdCBpbml0c3BsYW4uYzoxOTINCiMzICAweDAwMDA1NTViMTlkMmJlMjYgaW4g cXVlcnlfcGxhbm5lciAocm9vdD1yb290QGVudHJ5PTB4NTU1YjFhNjQ1MDg4LCANCiAgICBxcF9j YWxsYmFjaz1xcF9jYWxsYmFja0BlbnRyeT0weDU1NWIxOWQyYzQzMCA8c3RhbmRhcmRfcXBfY2Fs bGJhY2s+LApxcF9leHRyYT1xcF9leHRyYUBlbnRyeT0weDdmZmZkMTg2Y2QxMCkNCiAgICBhdCBw bGFubWFpbi5jOjE3OA0KLi4uDQoNCkJ1dCB3aXRoOg0KQ1JFQVRFIFJVTEUgdjFfdXBkX3J1bGUg QVMgT04gVVBEQVRFIFRPIHYxDQogIERPIElOU1RFQUQgKElOU0VSVCBJTlRPIHRjIFZBTFVFUyAo TkVXLmlkLCBORVcuZjMpOyBVUERBVEUgdCBTRVQgaWQgPQpORVcuaWQgV0hFUkUgaWQgPSBPTEQu aWQ7KTsNCg0KLi4uDQogaWQgDQotLS0tDQogIDENCiAgMg0KKDIgcm93cykNCg0KVVBEQVRFIDEN CiBpZCB8IGYxIHwgZjIgIHwgIGYzICB8ICBmNCAgIA0KLS0tLSstLS0tKy0tLS0tKy0tLS0tLSst LS0tLS0tDQogIDEgfCAxMSB8IDExMSB8IDExMTEgfCAxMTExMQ0KICAzIHwgMjIgfCAyMjIgfCAy MjIyIHwgMjIyMjINCigyIHJvd3MpDQoNCiBpZCB8ICBmICAgDQotLS0tKy0tLS0tLQ0KICAzIHwg MjIyMg0KKDEgcm93KQ0KKE1heWJlIGl0IHN1Y2NlZWRlZCBhY2NpZGVudGFsbHkuKQ0KDQpSRUxf MTVfU1RBQkxFIHdpdGggYXNzZXJ0czoNClRSQVA6IEZhaWxlZEFzc2VydGlvbigiYXR0bm8gPj0g cmVsLT5taW5fYXR0ciAmJiBhdHRubyA8PSByZWwtPm1heF9hdHRyIiwKRmlsZTogImluaXRzcGxh bi5jIiwgTGluZTogMjQ5LCBQSUQ6IDI2NjE3MCkNCg0KSW50ZXJlc3RpbmdseSBlbm91Z2gsIGJ1 dCByZXBsYWNpbmcgYW4gdW5kZXJseWluZyB2aWV3IHdpdGggaW5jb21wYXRpYmxlCmZpZWxkcyAN CmlzIHByb2hpYml0ZWQgKHRoYW5rcyB0byBhIGNoZWNrIGluIGNoZWNrVmlld1R1cGxlRGVzYygp KToNCkNSRUFURSBWSUVXIHYxIEFTIFNFTEVDVCAxOjp0ZXh0IEFTIGlkOw0KQ1JFQVRFIFZJRVcg djIgQVMgU0VMRUNUICogRlJPTSB2MTsNCkNSRUFURSBPUiBSRVBMQUNFIFZJRVcgdjEgV0lUSCAo c2VjdXJpdHlfYmFycmllciA9IHRydWUpIEFTIFNFTEVDVCAqIEZST00KdDsNCkVSUk9SOiAgY2Fu bm90IGNoYW5nZSBkYXRhIHR5cGUgb2YgdmlldyBjb2x1bW4gImlkIiBmcm9tIHRleHQgdG8gaW50 ZWdlcg0KDQpKdXN0IGFzIGRlY3JlYXNpbmcgb2YgYSBudW1iZXIgb2YgY29sdW1uczoNCkNSRUFU RSBWSUVXIHYxIEFTIFNFTEVDVCAxIEFTIGlkLCAxMSBBUyBmMSwgMTExIEFTIGYyLCAxMTExIEFT IGYzLCAxMTExMSBBUwpmNCwgMTExMTExIEFTIGY1Ow0KQ1JFQVRFIFZJRVcgdjIgQVMgU0VMRUNU ICogRlJPTSB2MTsNCkNSRUFURSBPUiBSRVBMQUNFIFZJRVcgdjEgV0lUSCAoc2VjdXJpdHlfYmFy cmllciA9IHRydWUpIEFTIFNFTEVDVCAqIEZST00KdDsNCkVSUk9SOiAgY2Fubm90IGRyb3AgY29s dW1ucyBmcm9tIHZpZXcNCg0KTWF5YmUgcmVwbGFjaW5nIGEgdmlldyB3aXRoIGluY3JlYXNpbmcg bnVtYmVyIG9mIGNvbHVtbnMgc2hvdWxkIGJlCnByb2hpYml0ZWQgdG9vPwoK --===============4075715539142389337==--