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 1l7T8W-0000BT-DF for pgsql-bugs@arkaria.postgresql.org; Thu, 04 Feb 2021 01:08: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 1l7T8V-00078w-9t for pgsql-bugs@arkaria.postgresql.org; Thu, 04 Feb 2021 01:08:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l7SzF-0008Dm-L7 for pgsql-bugs@lists.postgresql.org; Thu, 04 Feb 2021 00:59:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l7SzC-0007BN-6c for pgsql-bugs@lists.postgresql.org; Thu, 04 Feb 2021 00:59: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=4fnhGPEluyyGR0zWYwf0jc1JAjzdtzBLXbSHNLsIqWI=; b=ixBs8MyIvjfjUEhtONPJSqd00w MhIP3YVB4GKEU2lX4azF3xZTW6/khze2/ngnsm/CM0r6k6w10EL1dtKidSj4PTikDR4IlI0bChw75 RFIrqQq6Bv3Kpy0KQC30/Peq5G0QjKtMF7I+rgG7guhvIy70TbQAdoeTToKjKZ7cywX1kdVh2bol5 e7fB75PCdlnV27dCtOWq31nbPbWwee7oUxqZmRz+sbQSWPKzNr9XWZt6cV+7PFff39eBuxGvdp5M+ LHD5JXKkv21dLbt4XzsXUX4cJ/Mp3Lt8pNU8g52kb8cw0PM3slrKOal4+OOAhehqCN2BFPLQ3F3mc zxPV9WbA==; 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 1l7SzA-0004z0-Rq for pgsql-bugs@lists.postgresql.org; Thu, 04 Feb 2021 00:59:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l7Sz8-0001qn-5F for pgsql-bugs@lists.postgresql.org; Thu, 04 Feb 2021 00:59:02 +0000 Content-Type: multipart/mixed; boundary="===============7518597323843741149==" MIME-Version: 1.0 Subject: BUG #16853: Materialized view not behaving in fully MVCC-compliant way To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: postgresql@mscott.org Reply-To: postgresql@mscott.org, pgsql-bugs@lists.postgresql.org Date: Thu, 04 Feb 2021 00:58:07 +0000 Message-ID: <16853-edcd2caf18096366@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7518597323843741149== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjg1MwpMb2dnZWQgYnk6ICAgICAgICAgIFNjb3R0IE1hcmN5CkVtYWls IGFkZHJlc3M6ICAgICAgcG9zdGdyZXNxbEBtc2NvdHQub3JnClBvc3RncmVTUUwgdmVyc2lvbjog MTIuNApPcGVyYXRpbmcgc3lzdGVtOiAgIG1hY09TCkRlc2NyaXB0aW9uOiAgICAgICAgCgpJIGhh dmUgYSBtYXRlcmlhbGl6ZWQgdmlldyB0aGF0IGlzIHZlcnkgZXhwZW5zaXZlIHRvIGdlbmVyYXRl IGJ1dCBhbHNvCmluZnJlcXVlbnRseSB1c2VkLCBzbyB3aGVuZXZlciBzb21ldGhpbmcgaGFwcGVu cyB0aGF0IGludmFsaWRhdGVzIHRoZSBkYXRhCmluIHRoZSBNViBJIHVzZSBgUkVGUkVTSCBNQVRF UklBTElaRUQgVklFVyBXSVRIIE5PIERBVEE7YCB0byBkZS1wb3B1bGF0ZSBpdC4KSW4gdGhlIHBs YWNlcyB3aGVyZSB0aGUgTVYgd2lsbCBiZSB1c2VkLCBJIGZpcnN0IGNoZWNrCnBnX2NsYXNzLnJl bGlzcG9wdWxhdGVkIHRvIHNlZSBpZiB0aGUgTVYgaGFzIGRhdGEgb3Igbm90LCBhbmQgaWYgbm90 LCBJCnJlZnJlc2ggdGhlIE1WIGFuZCB0aGVuIHByb2NlZWQuDQoNCkhvd2V2ZXIsIGlmIG9uZSBj b25uZWN0aW9uIHJlbW92ZXMgdGhlIGRhdGEgZnJvbSB0aGUgTVYgd2hpbGUgYW5vdGhlcgpjb25u ZWN0aW9uIGlzIGFscmVhZHkgaW4gYSB0cmFuc2FjdGlvbiB0aGF0IHdpbGwgYWNjZXNzIHRoZSBN VidzIGRhdGEsIHRoZQphdHRlbXB0IHRvIGFjY2VzcyB0aGUgZGF0YSBpbiB0aGUgTVYgc2hvdWxk IGNhdXNlIGEgdHJhbnNhY3Rpb24gcm9sbGJhY2sKZXJyb3IsIG5vdCBhICJtYXRlcmlhbGl6ZWQg dmlldyBoYXMgbm90IGJlZW4gcG9wdWxhdGVkIiBlcnJvci4NCg0KSGVyZSBpcyBhIHNpbXBsZSBz ZXQgb2YgcHNxbCBjb21tYW5kcyAocnVuIGluIHR3byBkaWZmZXJlbnQgcHNxbApzZXNzaW9ucy0t dGhlIGluZGVudGVkIGxpbmVzIGFyZSBmb3IgdGhlIDJuZCBzZXNzaW9uKSB0aGF0IHNob3dzIHRo ZQpwcm9ibGVtLg0KDQoNCmNyZWF0ZSBtYXRlcmlhbGl6ZWQgdmlldyBtYXR2aWV3IGFzIHNlbGVj dCAqIGZyb20gcGdfY2F0YWxvZy5wZ19jbGFzczsNCg0KYmVnaW4gaXNvbGF0aW9uIGxldmVsIHNl cmlhbGl6YWJsZTsNCnNlbGVjdCByZWxpc3BvcHVsYXRlZCBmcm9tIHBnX2NhdGFsb2cucGdfY2xh c3Mgd2hlcmUgcmVsbmFtZSA9ICdtYXR2aWV3JzsNCi0tIHQNCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAK ICAgICBiZWdpbiBpc29sYXRpb24gbGV2ZWwgc2VyaWFsaXphYmxlOw0KICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIAogICAgIHNlbGVjdCByZWxpc3BvcHVsYXRlZCBmcm9tIHBnX2NhdGFsb2cucGdfY2xhc3Mg d2hlcmUgcmVsbmFtZSA9CidtYXR2aWV3JzsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAtLSB0 DQpyZWZyZXNoIG1hdGVyaWFsaXplZCB2aWV3IG1hdHZpZXcgd2l0aCBubyBkYXRhOw0Kc2VsZWN0 IHJlbGlzcG9wdWxhdGVkIGZyb20gcGdfY2F0YWxvZy5wZ19jbGFzcyB3aGVyZSByZWxuYW1lID0g J21hdHZpZXcnOw0KLS0gZg0KY29tbWl0Ow0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgIHNlbGVj dCByZWxpc3BvcHVsYXRlZCBmcm9tIHBnX2NhdGFsb2cucGdfY2xhc3Mgd2hlcmUgcmVsbmFtZSA9 CidtYXR2aWV3JzsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAtLSB0DQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgCiAgICAgLS0gQXJndWFibHkgY29ycmVjdCB1bmRlciBNVkNDLCBhbHRob3VnaCBtYXli ZSBhIHRyYW5zYWN0aW9uIHJvbGxiYWNrCmVycm9yIHNob3VsZCBoYXBwZW4gaGVyZQ0KDQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgCiAgICAgc2VsZWN0IGNvdW50KCopIGZyb20gbWF0dmlldzsNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAKICAgICBFUlJPUjogIG1hdGVyaWFsaXplZCB2aWV3ICJtYXR2aWV3IiBo YXMgbm90IGJlZW4gcG9wdWxhdGVkDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgLS0gVGhpcyBz aG91bGQgYmUgYSB0cmFuc2FjdGlvbiByb2xsYmFjayBlcnJvciBvZiBzb21lIHNvcnQuDQoNCg0K V2hpbGUgSSBjYW4gc3BlY2lhbC1jYXNlIHRoaXMgZXJyb3IgdG8gYmUgaGFuZGxlZCBhcyBhIHRy YW5zYWN0aW9uIHJvbGxiYWNrCmVycm9yLCB0aGF0IHJlYWxseSBpc24ndCBjb3JyZWN0IGhlcmUs IGFuZCBtYWtpbmcgc3VjaCBhIGNoYW5nZSBpbiBteQphcHBsaWNhdGlvbidzIGxvZ2ljIHJ1bnMg dGhlIHJpc2sgb2YgcmVhbCBidWdzIHdoZXJlIHRoZSBNViBoYXNuJ3QgYmVlbgpwb3B1bGF0ZWQg YXJlIHJlcGVhdGVkIG51bWVyb3VzIHRpbWVzIHRvIG5vIGdvb2QgcHVycG9zZS4NCg0KSSBoYXZl IHZlcmlmaWVkIHRoaXMgYmVoYXZpb3IgaW4gUG9zdGdyZXMgOS40IGFuZCAxMi40LgoK --===============7518597323843741149==--