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 1k07H4-0007Of-H2 for pgsql-novice@arkaria.postgresql.org; Mon, 27 Jul 2020 17:50:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k07H3-00042a-HU for pgsql-novice@arkaria.postgresql.org; Mon, 27 Jul 2020 17:50:53 +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 1k06u1-0001iM-5Z for pgsql-novice@lists.postgresql.org; Mon, 27 Jul 2020 17:27:05 +0000 Received: from nce.mail.chartercom.com ([142.136.234.137] helo=mail.chartercom.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k06ty-0005qX-UV for pgsql-novice@lists.postgresql.org; Mon, 27 Jul 2020 17:27:04 +0000 IronPort-SDR: mks516VrImJSzTXJ3TuhDdZBZuScXVeot3PSDekEbZ9G7bYo14YsHtYDvrihHbh0GicO9Dxcqn zbmCv6i+IrXg== X-IronPort-AV: E=Sophos;i="5.75,402,1589259600"; d="scan'208,217";a="109750877" Received: from unknown (HELO NCEMEXGP003.CORP.CHARTERCOM.com) ([142.136.234.156]) by mail.chartercom.com with ESMTP/TLS/ECDHE-RSA-AES256-SHA384; 27 Jul 2020 12:27:00 -0500 Received: from NCEMEXGP001.CORP.CHARTERCOM.COM (2002:8e88:ea06::8e88:ea06) by NCEMEXGP003.CORP.CHARTERCOM.com (2002:8e88:ea08::8e88:ea08) with Microsoft SMTP Server (TLS) id 15.0.1473.3; Mon, 27 Jul 2020 12:27:00 -0500 Received: from NCEMEXGP001.CORP.CHARTERCOM.COM ([fe80::cd2e:8361:3a34:53ab]) by NCEMEXGP001.CORP.CHARTERCOM.com ([fe80::cd2e:8361:3a34:53ab%19]) with mapi id 15.00.1473.003; Mon, 27 Jul 2020 12:27:00 -0500 From: "Vianello, Dan A" To: Chamath Sajeewa , "pgsql-novice@lists.postgresql.org" Subject: RE: [EXTERNAL] Pgsql error in coalesce Thread-Topic: [EXTERNAL] Pgsql error in coalesce Thread-Index: AQHWZDY0VsLJ2lcRxE6xEzYEjlxmxKkbq9qQ Date: Mon, 27 Jul 2020 17:27:00 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [142.136.235.122] Content-Type: multipart/alternative; boundary="_000_f76fe0eb980941a3ad33400dd833bfccNCEMEXGP001CORPCHARTERC_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_f76fe0eb980941a3ad33400dd833bfccNCEMEXGP001CORPCHARTERC_ Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 WW91ciBjb2x1bW4gbmFtZSDigJxjb2x1bW5fbmFtZeKAnSBpcyBvZiB0eXBlIHRleHQuIFRoZSBu dW1iZXIgMjU1IGlzIGFuIGludGVnZXIuICBTaW5jZSB0aG9zZSBkYXRhdHlwZXMgZG9u4oCZdCBt YXRjaCB0aGUgY29hbGVzY2UgZnVuY3Rpb24gZmFpbHMuICBJZiB0aGUgZGF0YSBpbiDigJxjb2x1 bW5fbmFtZeKAnSBjYW4gYWx3YXlzIGJlIGNhc3QgdG8gYW4gaW50ZWdlciB0aGVuIHlvdSBjYW4g dXNlDQoNClNlbGVjdCBjb2FsZXNjZShjb2x1bW5fbmFtZTo6aW50ZWdlciwgMjU1KTsNCg0KT3Ig eW91IGNhbiBjYXN0IDI1NSB0byBhIHRleHQgc3RyaW5nIG9mIOKAmDI1NeKAmSB3aXRoIHRoaXM6 DQoNClNlbGVjdCBjb2FsZXNjZShjb2x1bW5fbmFtZSwgJzI1NSc6OnRleHQpOw0KDQoNCkUtTUFJ TCBDT05GSURFTlRJQUxJVFkgTk9USUNFOiANClRoZSBjb250ZW50cyBvZiB0aGlzIGUtbWFpbCBt ZXNzYWdlIGFuZCBhbnkgYXR0YWNobWVudHMgYXJlIGludGVuZGVkIHNvbGVseSBmb3IgdGhlIGFk ZHJlc3NlZShzKSBhbmQgbWF5IGNvbnRhaW4gY29uZmlkZW50aWFsIGFuZC9vciBsZWdhbGx5IHBy aXZpbGVnZWQgaW5mb3JtYXRpb24uIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGll bnQgb2YgdGhpcyBtZXNzYWdlIG9yIGlmIHRoaXMgbWVzc2FnZSBoYXMgYmVlbiBhZGRyZXNzZWQg dG8geW91IGluIGVycm9yLCBwbGVhc2UgaW1tZWRpYXRlbHkgYWxlcnQgdGhlIHNlbmRlciBieSBy ZXBseSBlLW1haWwgYW5kIHRoZW4gZGVsZXRlIHRoaXMgbWVzc2FnZSBhbmQgYW55IGF0dGFjaG1l bnRzLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LCB5b3UgYXJlIG5vdGlm aWVkIHRoYXQgYW55IHVzZSwgZGlzc2VtaW5hdGlvbiwgZGlzdHJpYnV0aW9uLCBjb3B5aW5nLCBv ciBzdG9yYWdlIG9mIHRoaXMgbWVzc2FnZSBvciBhbnkgYXR0YWNobWVudCBpcyBzdHJpY3RseSBw cm9oaWJpdGVkLgo= --_000_f76fe0eb980941a3ad33400dd833bfccNCEMEXGP001CORPCHARTERC_ Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9 DQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCglj b2xvcjojMDU2M0MxOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBz cGFuLk1zb0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xv cjojOTU0RjcyOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0Kc3Bhbi5FbWFpbFN0eWxl MTgNCgl7bXNvLXN0eWxlLXR5cGU6cGVyc29uYWwtcmVwbHk7DQoJZm9udC1mYW1pbHk6IkNhbGli cmkiLHNhbnMtc2VyaWY7DQoJY29sb3I6IzFGNDk3RDt9DQouTXNvQ2hwRGVmYXVsdA0KCXttc28t c3R5bGUtdHlwZTpleHBvcnQtb25seTsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsc2Fucy1zZXJp Zjt9DQpAcGFnZSBXb3JkU2VjdGlvbjENCgl7c2l6ZTo4LjVpbiAxMS4waW47DQoJbWFyZ2luOjEu MGluIDEuMGluIDEuMGluIDEuMGluO30NCmRpdi5Xb3JkU2VjdGlvbjENCgl7cGFnZTpXb3JkU2Vj dGlvbjE7fQ0KLS0+PC9zdHlsZT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNoYXBlZGVm YXVsdHMgdjpleHQ9ImVkaXQiIHNwaWRtYXg9IjEwMjYiIC8+DQo8L3htbD48IVtlbmRpZl0tLT48 IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNoYXBlbGF5b3V0IHY6ZXh0PSJlZGl0Ij4NCjxv OmlkbWFwIHY6ZXh0PSJlZGl0IiBkYXRhPSIxIiAvPg0KPC9vOnNoYXBlbGF5b3V0PjwveG1sPjwh W2VuZGlmXS0tPg0KPC9oZWFkPg0KPGJvZHkgbGFuZz0iRU4tVVMiIGxpbms9IiMwNTYzQzEiIHZs aW5rPSIjOTU0RjcyIj4NCjxkaXYgY2xhc3M9IldvcmRTZWN0aW9uMSI+DQo8cCBjbGFzcz0iTXNv Tm9ybWFsIj48Zm9udCBzaXplPSIyIiBjb2xvcj0iIzFmNDk3ZCIgZmFjZT0iQ2FsaWJyaSI+PHNw YW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90 OyxzYW5zLXNlcmlmO2NvbG9yOiMxRjQ5N0QiPllvdXIgY29sdW1uIG5hbWUg4oCcY29sdW1uX25h bWXigJ0gaXMgb2YgdHlwZSB0ZXh0LiBUaGUgbnVtYmVyIDI1NSBpcyBhbiBpbnRlZ2VyLiZuYnNw OyBTaW5jZSB0aG9zZSBkYXRhdHlwZXMgZG9u4oCZdCBtYXRjaA0KIHRoZSBjb2FsZXNjZSBmdW5j dGlvbiBmYWlscy4mbmJzcDsgSWYgdGhlIGRhdGEgaW4g4oCcY29sdW1uX25hbWXigJ0gY2FuIGFs d2F5cyBiZSBjYXN0IHRvIGFuIGludGVnZXIgdGhlbiB5b3UgY2FuIHVzZQ0KPG86cD48L286cD48 L3NwYW4+PC9mb250PjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxmb250IHNpemU9IjIiIGNv bG9yPSIjMWY0OTdkIiBmYWNlPSJDYWxpYnJpIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBw dDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3 RCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9mb250PjwvcD4NCjxwIGNsYXNzPSJNc29Ob3Jt YWwiPjxmb250IHNpemU9IjIiIGNvbG9yPSIjMWY0OTdkIiBmYWNlPSJDYWxpYnJpIj48c3BhbiBz dHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNh bnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+U2VsZWN0IGNvYWxlc2NlKGNvbHVtbl9uYW1lOjppbnRl Z2VyLCAyNTUpOzxvOnA+PC9vOnA+PC9zcGFuPjwvZm9udD48L3A+DQo8cCBjbGFzcz0iTXNvTm9y bWFsIj48Zm9udCBzaXplPSIyIiBjb2xvcj0iIzFmNDk3ZCIgZmFjZT0iQ2FsaWJyaSI+PHNwYW4g c3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90Oyxz YW5zLXNlcmlmO2NvbG9yOiMxRjQ5N0QiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvZm9udD48 L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48Zm9udCBzaXplPSIyIiBjb2xvcj0iIzFmNDk3ZCIg ZmFjZT0iQ2FsaWJyaSI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6 JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMxRjQ5N0QiPk9yIHlvdSBjYW4g Y2FzdCAyNTUgdG8gYSB0ZXh0IHN0cmluZyBvZiDigJgyNTXigJkgd2l0aCB0aGlzOg0KPGJyPg0K PGJyPg0KU2VsZWN0IGNvYWxlc2NlKGNvbHVtbl9uYW1lLCAnMjU1Jzo6dGV4dCk7PG86cD48L286 cD48L3NwYW4+PC9mb250PjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxmb250IHNpemU9IjIi IGNvbG9yPSIjMWY0OTdkIiBmYWNlPSJDYWxpYnJpIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEx LjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFG NDk3RCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9mb250PjwvcD4NCjxkaXY+DQo8ZGl2Pg0K PHAgY2xhc3M9Ik1zb05vcm1hbCI+PGZvbnQgc2l6ZT0iMyIgZmFjZT0iVGltZXMgTmV3IFJvbWFu Ij48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEyLjBwdCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+ PC9mb250PjwvcD4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rpdj4NClRoZSBjb250ZW50cyBvZiB0aGlz IGUtbWFpbCBtZXNzYWdlIGFuZCA8YnI+YW55IGF0dGFjaG1lbnRzIGFyZSBpbnRlbmRlZCBzb2xl bHkgZm9yIHRoZSA8YnI+YWRkcmVzc2VlKHMpIGFuZCBtYXkgY29udGFpbiBjb25maWRlbnRpYWwg PGJyPmFuZC9vciBsZWdhbGx5IHByaXZpbGVnZWQgaW5mb3JtYXRpb24uIElmIHlvdTxicj5hcmUg bm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQgb2YgdGhpcyBtZXNzYWdlPGJyPm9yIGlmIHRoaXMg bWVzc2FnZSBoYXMgYmVlbiBhZGRyZXNzZWQgdG8geW91IDxicj5pbiBlcnJvciwgcGxlYXNlIGlt bWVkaWF0ZWx5IGFsZXJ0IHRoZSBzZW5kZXI8YnI+YnkgcmVwbHkgZS1tYWlsIGFuZCB0aGVuIGRl bGV0ZSB0aGlzIG1lc3NhZ2UgPGJyPmFuZCBhbnkgYXR0YWNobWVudHMuIElmIHlvdSBhcmUgbm90 IHRoZSA8YnI+aW50ZW5kZWQgcmVjaXBpZW50LCB5b3UgYXJlIG5vdGlmaWVkIHRoYXQgPGJyPmFu eSB1c2UsIGRpc3NlbWluYXRpb24sIGRpc3RyaWJ1dGlvbiwgY29weWluZyw8YnI+b3Igc3RvcmFn ZSBvZiB0aGlzIG1lc3NhZ2Ugb3IgYW55IGF0dGFjaG1lbnQgPGJyPmlzIHN0cmljdGx5IHByb2hp Yml0ZWQuPC9ib2R5Pg0KPC9odG1sPg0K --_000_f76fe0eb980941a3ad33400dd833bfccNCEMEXGP001CORPCHARTERC_--