Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ia6I8-0004Ze-9U for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Nov 2019 23:00:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ia6I6-0001db-W5 for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Nov 2019 23:00:10 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1ia6I6-0001dU-Lb for pgsql-bugs@lists.postgresql.org; Wed, 27 Nov 2019 23:00:10 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ia6I4-0000Qe-2c for pgsql-bugs@lists.postgresql.org; Wed, 27 Nov 2019 23:00:10 +0000 Content-Type: multipart/mixed; boundary="===============1451734074654778094==" MIME-Version: 1.0 Subject: BUG #16140: View with INSERT, DO INSTEAD, and ON CONFLICT causes an error To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: bryan.dicarlo@gmail.com Reply-To: bryan.dicarlo@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 27 Nov 2019 23:00:02 +0000 Message-ID: <16140-4d29cf5390118372@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1451734074654778094== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE0MApMb2dnZWQgYnk6ICAgICAgICAgIEJyeWFuIERpQ2FybG8KRW1h aWwgYWRkcmVzczogICAgICBicnlhbi5kaWNhcmxvQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDEyLjEKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4KRGVzY3JpcHRpb246ICAgICAgICAK CldoZW4gY3JlYXRpbmcgYW4gdXBkYXRhYmxlICJjb21wbGV4IiB2aWV3LCBpZiBhbiBPTiBDT05G TElDVCBjbGF1c2UgaXMKcHJvdmlkZWQsIGFuIElOU0VSVCBTRUxFQ1QgdG8gdGhhdCB2aWV3IHdp bGwgY2F1c2UgIkVSUk9SOiB2YXJpYWJsZSBub3QKZm91bmQgaW4gc3VicGxhbiB0YXJnZXQgbGlz dHMiLiAgUmVtb3ZpbmcgdGhlIE9OIENPTkZMSUNUIGNsYXVzZSBlbGltaW5hdGVzCnRoZSBlcnJv ciBtZXNzYWdlLg0KDQpJIGRpc2NvdmVyZWQgdGhpcyB3aGlsZSB1c2luZyBwb3N0Z3Jlc3QuICBU aGVyZSBhcmUgb3RoZXIgd2F5cyBJIGNhbiBoYW5kbGUKaXQgYnV0IGZyb20gd2hhdCBJIGNhbiB0 ZWxsLCB0aGlzIHNob3VsZCB3b3JrLg0KDQpSZXBvOg0KQ1JFQVRFIFRBQkxFIHNsb19tZXRhICgN CiBzbG9fbmFtZSAgICAgICAgVEVYVCAgICAgICBVTklRVUUgICAgICAgICBOT1QgTlVMTCwNCiBz bG9faWQgICAgICAgICAgU0VSSUFMICAgICBQUklNQVJZIEtFWSwNCiB3aW5kb3dfc2Vjb25kcyAg SU5UICAgIE5PVCBOVUxMLA0KIG9iamVjdGl2ZSAgICAgICBOVU1FUklDICAgIE5PVCBOVUxMLA0K IHN1cHBvcnRlZF90YWdzICBKU09OQiwNCiBDSEVDSyAob2JqZWN0aXZlIEJFVFdFRU4gMCBBTkQg MSkNCik7DQpDUkVBVEUgSU5ERVggU0xPX05BTUUgT04gc2xvX21ldGEgVVNJTkcgSEFTSCAoc2xv X25hbWUpOw0KDQpDUkVBVEUgVEFCTEUgc2xvX21ldHJpY3MgKA0KIHNsb19pZCAgICAgICAgIElO VCAgICAgICAgICBOT1QgTlVMTCAgICAgICAgICAgICAgICAgICAgICAgUkVGRVJFTkNFUwpzbG9f bWV0YSAoc2xvX2lkKSwNCiB2YWx1ZSAgICAgICAgICBOVU1FUklDICAgICAgTk9UIE5VTEwsDQog dGltZV93aW5kb3cgICAgVElNRVNUQU1QICAgIERFRkFVTFQgQ1VSUkVOVF9USU1FU1RBTVAsDQog dGFncyAgICAgICAgICAgSlNPTkIgICAgICAgIE5PVCBOVUxMLA0KIFBSSU1BUlkgS0VZIChzbG9f aWQsIHRpbWVfd2luZG93LCB0YWdzKSwNCiBDSEVDSyAodmFsdWUgQkVUV0VFTiAwIEFORCAxKQ0K KTsNCg0KQ1JFQVRFIFZJRVcgbWV0cmljcyBBUyBTRUxFQ1QNCiAgc2xvX21ldGEuc2xvX25hbWUg QVMgc2xvLA0KICBzbG9fbWV0cmljcy52YWx1ZSBBUyB2YWx1ZSwNCiAgc2xvX21ldHJpY3MudGFn cyBBUyB0YWdzLA0KICBzbG9fbWV0cmljcy50aW1lX3dpbmRvdyBBUyB0aW1lX3dpbmRvdw0KRlJP TQ0KICBzbG9fbWV0cmljcw0KICBMRUZUIEpPSU4gc2xvX21ldGEgT04gc2xvX21ldHJpY3Muc2xv X2lkID0gc2xvX21ldGEuc2xvX2lkOw0KDQotLSBNZXRyaWNzIElOU0VSVC9VUERBVEUgUlVMRQ0K Q1JFQVRFIE9SIFJFUExBQ0UgUlVMRSBtZXRyaWNzX2lucyBBUyBPTiBJTlNFUlQgVE8gbWV0cmlj cw0KICBETyBJTlNURUFEDQogIElOU0VSVCBJTlRPIHNsb19tZXRyaWNzIChzbG9faWQsIHZhbHVl LCB0aW1lX3dpbmRvdywgdGFncykNCiAgVkFMVUVTICgNCiAgICAoU0VMRUNUIHNsb19pZCBGUk9N IHNsb19tZXRhIFdIRVJFIHNsb19tZXRhLnNsb19uYW1lID0gTkVXLnNsbyksDQogICAgTkVXLnZh bHVlLA0KICAgICh0b190aW1lc3RhbXAoRVhUUkFDVChlcG9jaCBGUk9NIE5FVy50aW1lX3dpbmRv dyk6OmludCAtIChFWFRSQUNUKGVwb2NoCkZST00gTkVXLnRpbWVfd2luZG93KTo6aW50ICUgKFNF TEVDVCB3aW5kb3dfc2Vjb25kcyBGUk9NIHNsb19tZXRhIFdIRVJFCnNsb19tZXRhLnNsb19uYW1l ID0gTkVXLnNsbykpKSksDQogICAgTkVXLnRhZ3MNCiAgKQ0KICBPTiBDT05GTElDVCAoc2xvX2lk LCB0aW1lX3dpbmRvdywgdGFncykgRE8gVVBEQVRFIFNFVCB2YWx1ZSA9IE5FVy52YWx1ZQ0KIFJF VFVSTklORyAoU0VMRUNUIHNsb19uYW1lIEZST00gc2xvX21ldGEgV0hFUkUgc2xvX21ldGEuc2xv X2lkID0gc2xvX2lkKSwKdmFsdWUsIHRhZ3MsIHRpbWVfd2luZG93Ow0KDQogLS0tIFBvcHVsYXRl IFNMTyBNZXRhIFRhYmxlDQogSU5TRVJUIElOVE8gc2xvX21ldGEgKHNsb19uYW1lLCB3aW5kb3df c2Vjb25kcywgb2JqZWN0aXZlLApzdXBwb3J0ZWRfdGFncykNCiBWQUxVRVMgKCdncHVfY2FwYWNp dHknLCAzMDAsIDAuOTUsICdbInpvbmUiXSc6Ompzb24pOw0KDQogLS0tIFdPUktTIFRyeSBhbmQg YWRkIHRvIGFuIHVwZGF0ZWFibGUgdmlldw0KIElOU0VSVCBJTlRPIG1ldHJpY3MgKCJzbG8iLCAi dGFncyIsICJ0aW1lX3dpbmRvdyIsICJ2YWx1ZSIpDQogVkFMVUVTICgnZ3B1X2NhcGFjaXR5Jywg J3siem9uZSI6ICJOUC1GUkszLURDIn0nLCAnMjAxOS0xMS0yNiAxMDo0MDowMCcsCjAuOTQpDQog UkVUVVJOSU5HICo7DQoNCiAtLSBXT1JLUyBUZXN0IHdpdGggVGFibGUgUG9wdWxhdGlvbg0KIFdJ VEggcGdyc3RfYm9keSBBUyAoU0VMRUNUIGpzb25fYnVpbGRfYXJyYXkoJ3sic2xvX2lkIjoKMSwi dmFsdWUiOjAuOTgsInRhZ3MiOnsiem9uZSI6Ik5QLUZSSzMtREMifSwidGltZV93aW5kb3ciOiIy MDE5LTExLTI2VDEwOjUwOjAwIn0nOjpqc29uKQpBUyB2YWwpDQogSU5TRVJUIElOVE8gc2xvX21l dHJpY3MgKHNsb19pZCwgdGFncywgdGltZV93aW5kb3csIHZhbHVlKQ0KIFNFTEVDVCBzbG9faWQs IHRhZ3MsIHRpbWVfd2luZG93LCB2YWx1ZSANCiBGUk9NIGpzb25fcG9wdWxhdGVfcmVjb3Jkc2V0 KG51bGw6OnB1YmxpYy5zbG9fbWV0cmljcyAsIChTRUxFQ1QgdmFsIEZST00KcGdyc3RfYm9keSkp Ow0KDQogLS0gRE9FU04nVCBXT1JLIFRlc3Qgd2l0aCBWaWV3IFBvcHVsYXRpb24NCiAtLSBGaXhl ZCBieSBjb21tZW50aW5nIG91dCB0aGUgZm9sbG93aW5nIGZyb20gbWV0cmljc19pbnMgcnVsZTog J09OCkNPTkZMSUNUIChzbG9faWQsIHRpbWVfd2luZG93LCB0YWdzKSBETyBVUERBVEUgU0VUIHZh bHVlID0gTkVXLnZhbHVlJw0KIFdJVEggcGdyc3RfYm9keSBBUyAoU0VMRUNUIGpzb25fYnVpbGRf YXJyYXkoJ3sic2xvIjoKImdwdV9jYXBhY2l0eSIsInZhbHVlIjowLjk4LCJ0YWdzIjp7InpvbmUi OiJOUC1GUkszLURDIn0sInRpbWVfd2luZG93IjoiMjAxOS0xMS0yNlQxMDozMDowMCJ9Jzo6anNv bikKQVMgdmFsKQ0KIElOU0VSVCBJTlRPIG1ldHJpY3MgKHNsbywgdGFncywgdGltZV93aW5kb3cs IHZhbHVlKQ0KIFNFTEVDVCBzbG8sIHRhZ3MsIHRpbWVfd2luZG93LCB2YWx1ZSANCiBGUk9NIGpz b25fcG9wdWxhdGVfcmVjb3Jkc2V0KG51bGw6OnB1YmxpYy5tZXRyaWNzICwgKFNFTEVDVCB2YWwg RlJPTQpwZ3JzdF9ib2R5KSk7DQoNCiAtLSBNZXRyaWNzIElOU0VSVC9VUERBVEUgUlVMRQ0KIENS RUFURSBPUiBSRVBMQUNFIFJVTEUgbWV0cmljc19pbnMgQVMgT04gSU5TRVJUIFRPIG1ldHJpY3MN CiAgIERPIElOU1RFQUQNCiAgIElOU0VSVCBJTlRPIHNsb19tZXRyaWNzIChzbG9faWQsIHZhbHVl LCB0aW1lX3dpbmRvdywgdGFncykNCiAgIFZBTFVFUyAoDQogICAgIChTRUxFQ1Qgc2xvX2lkIEZS T00gc2xvX21ldGEgV0hFUkUgc2xvX21ldGEuc2xvX25hbWUgPSBORVcuc2xvKSwNCiAgICAgTkVX LnZhbHVlLA0KICAgICAodG9fdGltZXN0YW1wKEVYVFJBQ1QoZXBvY2ggRlJPTSBORVcudGltZV93 aW5kb3cpOjppbnQgLSAoRVhUUkFDVChlcG9jaApGUk9NIE5FVy50aW1lX3dpbmRvdyk6OmludCAl IChTRUxFQ1Qgd2luZG93X3NlY29uZHMgRlJPTSBzbG9fbWV0YSBXSEVSRQpzbG9fbWV0YS5zbG9f bmFtZSA9IE5FVy5zbG8pKSkpLA0KICAgICBORVcudGFncw0KICAgKQ0KLS0gICBPTiBDT05GTElD VCAoc2xvX2lkLCB0aW1lX3dpbmRvdywgdGFncykgRE8gVVBEQVRFIFNFVCB2YWx1ZSA9Ck5FVy52 YWx1ZQ0KICBSRVRVUk5JTkcgKFNFTEVDVCBzbG9fbmFtZSBGUk9NIHNsb19tZXRhIFdIRVJFIHNs b19tZXRhLnNsb19pZCA9IHNsb19pZCksCnZhbHVlLCB0YWdzLCB0aW1lX3dpbmRvdzsNCg0KICAt LSBXT1JLUyBOT1cgVGVzdCB3aXRoIFZpZXcgUG9wdWxhdGlvbg0KICAtLSBGaXhlZCBieSBjb21t ZW50aW5nIG91dCB0aGUgZm9sbG93aW5nIGZyb20gbWV0cmljc19pbnMgcnVsZTogJ09OCkNPTkZM SUNUIChzbG9faWQsIHRpbWVfd2luZG93LCB0YWdzKSBETyBVUERBVEUgU0VUIHZhbHVlID0gTkVX LnZhbHVlJw0KICBXSVRIIHBncnN0X2JvZHkgQVMgKFNFTEVDVCBqc29uX2J1aWxkX2FycmF5KCd7 InNsbyI6CiJncHVfY2FwYWNpdHkiLCJ2YWx1ZSI6MC45OCwidGFncyI6eyJ6b25lIjoiTlAtRlJL My1EQyJ9LCJ0aW1lX3dpbmRvdyI6IjIwMTktMTEtMjZUMTA6MzA6MDAifSc6Ompzb24pCkFTIHZh bCkNCiAgSU5TRVJUIElOVE8gbWV0cmljcyAoc2xvLCB0YWdzLCB0aW1lX3dpbmRvdywgdmFsdWUp DQogIFNFTEVDVCBzbG8sIHRhZ3MsIHRpbWVfd2luZG93LCB2YWx1ZSANCiAgRlJPTSBqc29uX3Bv cHVsYXRlX3JlY29yZHNldChudWxsOjpwdWJsaWMubWV0cmljcyAsIChTRUxFQ1QgdmFsIEZST00K cGdyc3RfYm9keSkpOwoK --===============1451734074654778094==--