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 1k06ZV-0005mL-Cq for pgsql-novice@arkaria.postgresql.org; Mon, 27 Jul 2020 17:05:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k06ZU-0006Bn-AZ for pgsql-novice@arkaria.postgresql.org; Mon, 27 Jul 2020 17:05:52 +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 1k06ZT-0006A8-P7 for pgsql-novice@lists.postgresql.org; Mon, 27 Jul 2020 17:05:52 +0000 Received: from mail-co1nam11on2094.outbound.protection.outlook.com ([40.107.220.94] helo=NAM11-CO1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k06ZQ-0005gn-SZ for pgsql-novice@lists.postgresql.org; Mon, 27 Jul 2020 17:05:50 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=oMsfc23Kf59EOPmzlCbrAVT3WseDxN/1O65fkFNvarJ98q2qRfbetALkyslRhqwXjeAFL0fP8Vb4LFDiUzcweg+B+Flw6hUml7NIxlCY+Q57p6AeZBqO5emsiERd/nu0DWar+MLiXa39t8Ho+Pbqq8K4WoEd6MRIyagTFvoGV7kEk7Ccj5xhm7MV+To5aNIEqSeIYLdqrC3lmEW4p4sEWYboCzR0GZp0tnQ+QSPZSul3OQx5eQ1vSNB32SHFpleflwr2WW+4v6ilccNUDqfZJW3n6uEXpy96dqIaWRe7b25wu3JJYTN12Va9Fc3LfpIJwD0G4Je5Dw+II+SLLb+kIg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=BDdLoPHodVXaNQjrYfFqKlt60jENVFVbQ/kcRL/blNY=; b=lPHzZNOJUFS4ltKAox4RQ6B6oQ/Fzl6dLi8W+GPhsxOw+4OCjNxuYxKQpLc3PINRErT0uOQtSUWEZQ+9kZ7D1nccnXMD/k0eoh5D9f5qSGwk+Ld9DQQx9nS/pQrhSumGkAp8ibcL9kj6fHQf2gW33+fdBxVFZ1zYtrUO4WEOqpGoTY4Aw8dLNv/gYgs+gckk2OeTuwtMff+Pa0ecsmU3W3zZBy6hLcIhBiwOC6Ejk9L3FFCziZ3OGnSPMEt+M1XBvppUCsFIyE/agTBNLSFL/aTKHdzHZZF8I7NLpzZAkPU1CcsyY5GjqamZLGE+GQJ36pG0t7uzGUPUVzGnxVp1xw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=cablelabs.com; dmarc=pass action=none header.from=cablelabs.com; dkim=pass header.d=cablelabs.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cablelabs.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=BDdLoPHodVXaNQjrYfFqKlt60jENVFVbQ/kcRL/blNY=; b=WKDfN29l28gCsbeBY6oZE1jWrMh5XBctpPMMKrKN07cj18q6cOLtJZvMAZ++63zbV7o2NQL92JMJrbCQDGj5sH7gq6DRrNWnF/iEWcsxZKQqX6ikOc6KVqGL735lQ0DZB8RDFAe5bZtU9Y8Ay/5jBR9Lt2Nr/WZyPhynhtLdlfLaB7RcBb4aYNiE3UfqhXHBPJPDgFqxhkb2USd1gWgHNhJYZuOc7ydzARRLZYoRQy+on4OfObuN3Vefdfkuk40eTZBmb/I96w6Q7XMRHKC0XG6G6suSNAnKv6LNJlhOoGZ79JXRlik2fn1XEhJ3hJOo9qfY2zAoJn9/6tcuYmGrCQ== Received: from CH2PR06MB6470.namprd06.prod.outlook.com (2603:10b6:610:87::10) by CH2PR06MB6741.namprd06.prod.outlook.com (2603:10b6:610:8e::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3216.26; Mon, 27 Jul 2020 17:05:46 +0000 Received: from CH2PR06MB6470.namprd06.prod.outlook.com ([fe80::549d:7303:9a32:7db1]) by CH2PR06MB6470.namprd06.prod.outlook.com ([fe80::549d:7303:9a32:7db1%5]) with mapi id 15.20.3216.033; Mon, 27 Jul 2020 17:05:46 +0000 From: Stephen Froehlich To: Chamath Sajeewa , "pgsql-novice@lists.postgresql.org" Subject: RE: Pgsql error in coalesce Thread-Topic: Pgsql error in coalesce Thread-Index: AQHWZDY1XngjGa6rAU60L+IsLeMqvKkbpyIw Date: Mon, 27 Jul 2020 17:05:46 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=cablelabs.com; x-originating-ip: [70.59.28.15] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: ab73b282-323d-4fb6-4233-08d8324f4de3 x-ms-traffictypediagnostic: CH2PR06MB6741: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:5236; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: iPtR7BiIgPmBwt4/Ey1q/R69J+SkG/v1z0QLNAX0td9AhfYGCMQR88wYr21nYVB4Gt9vQyLA65hQiuNCE3WElqeQGk3OmmuzNXZO5VH2Z9PGbxu2j8tVPZkrZPb2wTYjP0BtKxIWlMM9Qq2Ru4rZmSnYyNLdJdtIKFRzBbekPogDH8IP7qXI7In2xiaMd9sqWUVTMbUQql90rzvDpr+054uW1AxkwybTyLO1RSoYhAafiaJ91O1VSI+zMHp2CVycKlSPhwn/LZbQXr22ebKzGf+a1PZuipDYNiHE0O6xXvlSaBhmZCrB/95jtFID6sQ9 x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:CH2PR06MB6470.namprd06.prod.outlook.com;PTR:;CAT:NONE;SFTY:;SFS:(366004)(39840400004)(346002)(136003)(376002)(396003)(8676002)(76116006)(55016002)(66556008)(8936002)(478600001)(64756008)(9686003)(66476007)(66946007)(5660300002)(3480700007)(86362001)(33656002)(4744005)(2906002)(26005)(7696005)(52536014)(316002)(66446008)(71200400001)(110136005)(53546011)(6506007)(186003);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata: IfMDnOU6tEJXEV6RK3texSneLurbScZyn612z5hdAv4B7MEogN8dIG/Lb27aiJAfLSfRquPjKON8gzYCXeQ7MG3Q54apUIlnC9cisEyVgdGH4vVClCNcX0MBSvniBOaiKfVidCQEoZ8TnLaoA2vdrkQgIHMxLiJ9onxk7opLyyGv11mCqFTInaLy0wYy9IoBQtlk4l6+761r1LtSs+GFjUiFUUVknx3X9/Nc+rfLDQdh3THi1Ko/CcUaKGMhb9USLqgtfqQ1C5CZE3l5cktfmCCuB8p2BzLNH8s129ZhPhA9f3dzQ57AoBpuDBYUUQtAWg0fUHiUQMj20hvsuxahZt2n9hDEfkXy9fmHCzqLpvEziXwBZ7B4hv7ZkmiH4IsM9c9/A2f68eNfdhrCVn2lDhYQ+vy6ae/VNtpIGjQnADGO6QM9lkkVweqGUvjntlaM0r2e/EJt78cG8yCD0P8ad+6glcNgUL8Vi8laEFfiX+M= x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_CH2PR06MB64706ABCFCB27BAACBC50BD8E5720CH2PR06MB6470namp_" MIME-Version: 1.0 X-OriginatorOrg: cablelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: CH2PR06MB6470.namprd06.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: ab73b282-323d-4fb6-4233-08d8324f4de3 X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Jul 2020 17:05:46.2025 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: ce4fbcd1-1d81-4af0-ad0b-2998c441e160 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 9dsTbPmz9RvcxLGWqus082Tg+WRlq9dA0CEgAdj5HkVAq8J3/6OQSlFQIzIWW/UNRIiiDQzkUj8U8NyfbVaEK7k+vAlXnI/PXuwr7D2KfLI= X-MS-Exchange-Transport-CrossTenantHeadersStamped: CH2PR06MB6741 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_CH2PR06MB64706ABCFCB27BAACBC50BD8E5720CH2PR06MB6470namp_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 V2hhdCBkbyB5b3UgZ2V0IHdpdGggdGhlIGZvbGxvd2luZyB0d28gdHlwZSBjYXN0aW5nczoNCg0K U0VMRUNUIGNvYWxlc2NlKGNvbHVtbl9uYW1lOjppbnRlZ2VyLCAyNTUpOyA/DQpTRUxFQ1QgY29h bGVzY2UoY29sdW1uX25hbWUsIOKAmDI1NeKAmTo6dGV4dCk6OmludGVnZXI7ID8NCg0K4oCcaW50 ZWdlcuKAnSBtaWdodCBhY3R1YWxseSBiZSDigJxzbWFsbGludOKAnSBpZiB5b3XigJlyZSBvbmx5 IGdvaW5nIHRvIDI1NS4NCg0KLS1TdGVwaGVuDQoNCkZyb206IENoYW1hdGggU2FqZWV3YSA8Y3Nn c2FqZWV3YUBnbWFpbC5jb20+DQpTZW50OiBNb25kYXksIEp1bHkgMjcsIDIwMjAgMTA6NTENClRv OiBwZ3NxbC1ub3ZpY2VAbGlzdHMucG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFBnc3FsIGVycm9y IGluIGNvYWxlc2NlDQoNCkhpLA0KVGhlcmUgaXMgdGFibGUgd2l0aCBpbnQ0IGNvbHVtbi4gV2hl biBzZWxlY3QgcXVlcnkgaXMgZXhlY3V0ZWQgYXMgInNlbGVjdCBjb2FsZXNjZShjb2x1bW5fbmFt ZSwgMjU1KSwgcXVlcnkgaXMgZmFpbGluZyB3aXRoIGJlbG93IGVycm9yLg0KIkNPQUxFU0NFIHR5 cGVzIHRleHQgYW5kIGludGVnZXIgY2Fubm90IGJlIG1hY2hlZCIuDQpBbnkgaWRlYT8NClRoYW5r IFlvdSEhDQo= --_000_CH2PR06MB64706ABCFCB27BAACBC50BD8E5720CH2PR06MB6470namp_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjExLjBwdDsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsc2Fucy1zZXJpZjt9DQou TXNvQ2hwRGVmYXVsdA0KCXttc28tc3R5bGUtdHlwZTpleHBvcnQtb25seTsNCglmb250LWZhbWls eToiQ2FsaWJyaSIsc2Fucy1zZXJpZjt9DQpAcGFnZSBXb3JkU2VjdGlvbjENCgl7c2l6ZTo4LjVp biAxMS4waW47DQoJbWFyZ2luOjEuMGluIDEuMGluIDEuMGluIDEuMGluO30NCmRpdi5Xb3JkU2Vj dGlvbjENCgl7cGFnZTpXb3JkU2VjdGlvbjE7fQ0KLS0+PC9zdHlsZT48IS0tW2lmIGd0ZSBtc28g OV0+PHhtbD4NCjxvOnNoYXBlZGVmYXVsdHMgdjpleHQ9ImVkaXQiIHNwaWRtYXg9IjEwMjYiIC8+ DQo8L3htbD48IVtlbmRpZl0tLT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNoYXBlbGF5 b3V0IHY6ZXh0PSJlZGl0Ij4NCjxvOmlkbWFwIHY6ZXh0PSJlZGl0IiBkYXRhPSIxIiAvPg0KPC9v OnNoYXBlbGF5b3V0PjwveG1sPjwhW2VuZGlmXS0tPg0KPC9oZWFkPg0KPGJvZHkgbGFuZz0iRU4t VVMiIGxpbms9IiMwNTYzQzEiIHZsaW5rPSIjOTU0RjcyIj4NCjxkaXYgY2xhc3M9IldvcmRTZWN0 aW9uMSI+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5XaGF0IGRvIHlvdSBnZXQgd2l0aCB0aGUgZm9s bG93aW5nIHR3byB0eXBlIGNhc3RpbmdzOjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0i bWFyZ2luLWxlZnQ6LjVpbiI+U0VMRUNUIGNvYWxlc2NlKGNvbHVtbl9uYW1lOjppbnRlZ2VyLCAy NTUpOyA/PG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibWFyZ2lu LWxlZnQ6LjVpbiI+U0VMRUNUIGNvYWxlc2NlKGNvbHVtbl9uYW1lLCDigJgyNTXigJk6OnRleHQp OjppbnRlZ2VyOyA/PG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZu YnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPuKAnGludGVnZXLigJ0gbWlnaHQg YWN0dWFsbHkgYmUg4oCcc21hbGxpbnTigJ0gaWYgeW914oCZcmUgb25seSBnb2luZyB0byAyNTUu PG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwv cD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPi0tU3RlcGhlbjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xh c3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8ZGl2IHN0eWxlPSJib3JkZXI6 bm9uZTtib3JkZXItdG9wOnNvbGlkICNFMUUxRTEgMS4wcHQ7cGFkZGluZzozLjBwdCAwaW4gMGlu IDBpbiI+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48Yj5Gcm9tOjwvYj4gQ2hhbWF0aCBTYWplZXdh ICZsdDtjc2dzYWplZXdhQGdtYWlsLmNvbSZndDsgPGJyPg0KPGI+U2VudDo8L2I+IE1vbmRheSwg SnVseSAyNywgMjAyMCAxMDo1MTxicj4NCjxiPlRvOjwvYj4gcGdzcWwtbm92aWNlQGxpc3RzLnBv c3RncmVzcWwub3JnPGJyPg0KPGI+U3ViamVjdDo8L2I+IFBnc3FsIGVycm9yIGluIGNvYWxlc2Nl PG86cD48L286cD48L3A+DQo8L2Rpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7 PC9vOnA+PC9wPg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkhpLDxvOnA+PC9vOnA+PC9w Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPlRoZXJlIGlzIHRhYmxlIHdpdGggaW50NCBj b2x1bW4uIFdoZW4gc2VsZWN0IHF1ZXJ5IGlzIGV4ZWN1dGVkIGFzICZxdW90O3NlbGVjdCBjb2Fs ZXNjZShjb2x1bW5fbmFtZSwgMjU1KSwgcXVlcnkgaXMgZmFpbGluZyB3aXRoIGJlbG93IGVycm9y LjxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+JnF1 b3Q7Q09BTEVTQ0UgdHlwZXMgdGV4dCBhbmQgaW50ZWdlciBjYW5ub3QgYmUgbWFjaGVkJnF1b3Q7 LjxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+QW55 IGlkZWE/PG86cD48L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFs Ij5UaGFuayBZb3UhITxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9i b2R5Pg0KPC9odG1sPg0K --_000_CH2PR06MB64706ABCFCB27BAACBC50BD8E5720CH2PR06MB6470namp_--