Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cMtnF-0005qU-HL for pgadmin-hackers@arkaria.postgresql.org; Fri, 30 Dec 2016 09:48:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cMtnF-00036Q-17 for pgadmin-hackers@arkaria.postgresql.org; Fri, 30 Dec 2016 09:48:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cMtnE-00036H-Cu for pgadmin-hackers@postgresql.org; Fri, 30 Dec 2016 09:48:08 +0000 Received: from mail-it0-x22d.google.com ([2607:f8b0:4001:c0b::22d]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cMtn6-0000lQ-NT for pgadmin-hackers@postgresql.org; Fri, 30 Dec 2016 09:48:06 +0000 Received: by mail-it0-x22d.google.com with SMTP id c20so235254764itb.0 for ; Fri, 30 Dec 2016 01:48:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=bpTRz9ZjS3c7QaggJknVW361vBvZFZYqfvmml1yqjoc=; b=eRpZQSBd9Av2ggIm/M1z8TV7KWnliYRs1hlJLNuWG05ha/wBlOZ43jKHByZjWngs3/ w0Kr9MBBQ/5TXJ9kyC0EiAAwrtieKF+xsOwDM5Po/CNP4wxKz+6O34jEama8KGI5r6hA nZJXQ5LOLlFjns8NXlGYlYrq87wMDf459U/6r3Tr9svqyYqR4LRIh+vZBEBH4QiueGoR qmd80hibXbfn30LVKV1j8EA4wT6IR8fHw5OlhB8gisJ7Hy5aLYrp5xqzz6IIvKq/KgWE P/zjdpMglehVeexEVfvFt7e4bg4ssBJK787e2UtB5DH9QhP0Cho/pBFlLI9xyh0XAzKb 5SLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=bpTRz9ZjS3c7QaggJknVW361vBvZFZYqfvmml1yqjoc=; b=jCVQJiwDgH9fEIOuuiiVxwZDZ868diY97yi7vON4ENu9MU/AIG5bR2uspt6/QbHm1x gwOGm3xXixKQoqWF5h4urqjsH4EpwXu5EhxPyXi2k+IAnqJqTt7tALipJeKYXhlysEn1 fKgkyk+6enZtvdxw+bqYAF1bUiwnpCI/LSPa0WeRP5cmeJA8LUAD35IvvvwNrFO8BpGn wyhfE3IEBC0zjV0P6vJYLpkke/mu7mHA9vPaks/X1v6MAo6AwTfbyK9JumHp7ziPITOc sc/1Ibe1FQWwUD0C6POAdBTRJIs8tlGsLajo1/YLvqucQIAp30LB8ofrS/Tw7SYDbbdz VXwA== X-Gm-Message-State: AIkVDXLonlZZmzAZGuasUAiGjQBXDRtgkEnZIh3zy2GLCwQ3OTQdR3j+dfXmODZnNNXle1+NH8LlI/U8Ysc+yXr3 X-Received: by 10.36.254.74 with SMTP id w71mr34371567ith.38.1483091279520; Fri, 30 Dec 2016 01:47:59 -0800 (PST) MIME-Version: 1.0 Received: by 10.50.29.41 with HTTP; Fri, 30 Dec 2016 01:47:39 -0800 (PST) From: Murtuza Zabuawala Date: Fri, 30 Dec 2016 15:17:39 +0530 Message-ID: Subject: PATCH: To fix the issue in exclusion constraint (pgAdmin4) To: pgadmin-hackers Content-Type: multipart/mixed; boundary=94eb2c03088ee2d8930544dd18fd X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --94eb2c03088ee2d8930544dd18fd Content-Type: multipart/alternative; boundary=94eb2c03088ee2d88e0544dd18fb --94eb2c03088ee2d88e0544dd18fb Content-Type: text/plain; charset=UTF-8 Hi, PFA patch to fix the issue where we were fetching wrong OID while generating node which was causing "index out of range". error when user try to access that exclusion constraint . RM#1896 -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --94eb2c03088ee2d88e0544dd18fb Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

PFA patch to fix the issue where we= were fetching wrong OID while generating node which was causing=C2=A0"index out of range".=C2=A0error when user try to access= that exclusion constraint=C2=A0.
RM#1896

--
Regards,
Murtuza Zabuawala
Enter= priseDB:=C2=A0http://www.enterpris= edb.com
The Enterprise PostgreSQL Company
--94eb2c03088ee2d88e0544dd18fb-- --94eb2c03088ee2d8930544dd18fd Content-Type: application/octet-stream; name="RM_1896.patch" Content-Disposition: attachment; filename="RM_1896.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_ixblxbtg0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50 cy9leGNsdXNpb25fY29uc3RyYWludC9fX2luaXRfXy5weSBiL3dlYi9wZ2Fk bWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9z Y2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9leGNsdXNpb25fY29uc3RyYWlu dC9fX2luaXRfXy5weQppbmRleCBkYmRhODA3Li45YjAzMGQ0IDEwMDY0NAot LS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVy cy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29uc3RyYWludHMvZXhjbHVz aW9uX2NvbnN0cmFpbnQvX19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4v YnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVt YXMvdGFibGVzL2NvbnN0cmFpbnRzL2V4Y2x1c2lvbl9jb25zdHJhaW50L19f aW5pdF9fLnB5CkBAIC02MjIsNyArNjIyLDcgQEAgY2xhc3MgRXhjbHVzaW9u Q29uc3RyYWludFZpZXcoUEdDaGlsZE5vZGVWaWV3KToKICAgICAgICAgICAg IHJldHVybiBtYWtlX2pzb25fcmVzcG9uc2UoCiAgICAgICAgICAgICAgICAg c3RhdHVzPTQwMCwKICAgICAgICAgICAgICAgICBzdWNjZXNzPTAsCi0gICAg ICAgICAgICAgICAgZXJyb3Jtc2c9ZQorICAgICAgICAgICAgICAgIGVycm9y bXNnPXN0cihlKQogICAgICAgICAgICAgKQogCiAgICAgQGNoZWNrX3ByZWNv bmRpdGlvbgpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3Rl bXBsYXRlcy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS4xX3BsdXMvZ2V0 X29pZC5zcWwgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMv c2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL2V4 Y2x1c2lvbl9jb25zdHJhaW50L3NxbC85LjFfcGx1cy9nZXRfb2lkLnNxbApp bmRleCAxNjhlMTNiLi42YjUwYzNiIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1p bi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2No ZW1hcy90YWJsZXMvdGVtcGxhdGVzL2V4Y2x1c2lvbl9jb25zdHJhaW50L3Nx bC85LjFfcGx1cy9nZXRfb2lkLnNxbAorKysgYi93ZWIvcGdhZG1pbi9icm93 c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90 YWJsZXMvdGVtcGxhdGVzL2V4Y2x1c2lvbl9jb25zdHJhaW50L3NxbC85LjFf cGx1cy9nZXRfb2lkLnNxbApAQCAtMSw0ICsxLDQgQEAKLVNFTEVDVCBjdC5v aWQKK1NFTEVDVCBjdC5jb25pbmRpZCBhcyBvaWQKIEZST00gcGdfY29uc3Ry YWludCBjdAogV0hFUkUgY29udHlwZT0neCcgQU5ECiBjdC5jb25uYW1lID0g e3sgbmFtZXxxdExpdGVyYWwgfX07ClwgTm8gbmV3bGluZSBhdCBlbmQgb2Yg ZmlsZQpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJf Z3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBs YXRlcy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS4xX3BsdXMvZ2V0X29p ZF93aXRoX3RyYW5zYWN0aW9uLnNxbCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIv c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxl cy90ZW1wbGF0ZXMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvc3FsLzkuMV9wbHVz L2dldF9vaWRfd2l0aF90cmFuc2FjdGlvbi5zcWwKaW5kZXggMGZjMWZhOC4u NzExMTFhNSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3Rl bXBsYXRlcy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS4xX3BsdXMvZ2V0 X29pZF93aXRoX3RyYW5zYWN0aW9uLnNxbAorKysgYi93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1h cy90YWJsZXMvdGVtcGxhdGVzL2V4Y2x1c2lvbl9jb25zdHJhaW50L3NxbC85 LjFfcGx1cy9nZXRfb2lkX3dpdGhfdHJhbnNhY3Rpb24uc3FsCkBAIC0xLDQg KzEsNCBAQAotU0VMRUNUIGN0Lm9pZCwKK1NFTEVDVCBjdC5jb25pbmRpZCAg YXMgb2lkLAogICAgIGN0LmNvbm5hbWUgYXMgbmFtZSwKICAgICBOT1QgY29u dmFsaWRhdGVkIGFzIGNvbnZhbGlkYXRlZAogRlJPTSBwZ19jb25zdHJhaW50 IGN0CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9n cm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxh dGVzL2V4Y2x1c2lvbl9jb25zdHJhaW50L3NxbC85LjJfcGx1cy9nZXRfb2lk LnNxbCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2 ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvZXhjbHVz aW9uX2NvbnN0cmFpbnQvc3FsLzkuMl9wbHVzL2dldF9vaWQuc3FsCmluZGV4 IDE2OGUxM2IuLjM4MjE3NzggMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jy b3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFz L3RhYmxlcy90ZW1wbGF0ZXMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvc3FsLzku Ml9wbHVzL2dldF9vaWQuc3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIv c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxl cy90ZW1wbGF0ZXMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvc3FsLzkuMl9wbHVz L2dldF9vaWQuc3FsCkBAIC0xLDQgKzEsNCBAQAotU0VMRUNUIGN0Lm9pZAor U0VMRUNUIGN0LmNvbmluZGlkICBhcyBvaWQKIEZST00gcGdfY29uc3RyYWlu dCBjdAogV0hFUkUgY29udHlwZT0neCcgQU5ECiBjdC5jb25uYW1lID0ge3sg bmFtZXxxdExpdGVyYWwgfX07ClwgTm8gbmV3bGluZSBhdCBlbmQgb2YgZmls ZQpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3Jv dXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRl cy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS4yX3BsdXMvZ2V0X29pZF93 aXRoX3RyYW5zYWN0aW9uLnNxbCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2Vy dmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90 ZW1wbGF0ZXMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvc3FsLzkuMl9wbHVzL2dl dF9vaWRfd2l0aF90cmFuc2FjdGlvbi5zcWwKaW5kZXggMGZjMWZhOC4uZGNh ZDI5NSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJf Z3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBs YXRlcy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS4yX3BsdXMvZ2V0X29p ZF93aXRoX3RyYW5zYWN0aW9uLnNxbAorKysgYi93ZWIvcGdhZG1pbi9icm93 c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90 YWJsZXMvdGVtcGxhdGVzL2V4Y2x1c2lvbl9jb25zdHJhaW50L3NxbC85LjJf cGx1cy9nZXRfb2lkX3dpdGhfdHJhbnNhY3Rpb24uc3FsCkBAIC0xLDQgKzEs NCBAQAotU0VMRUNUIGN0Lm9pZCwKK1NFTEVDVCBjdC5jb25pbmRpZCBhcyBv aWQsCiAgICAgY3QuY29ubmFtZSBhcyBuYW1lLAogICAgIE5PVCBjb252YWxp ZGF0ZWQgYXMgY29udmFsaWRhdGVkCiBGUk9NIHBnX2NvbnN0cmFpbnQgY3QK ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMv ZXhjbHVzaW9uX2NvbnN0cmFpbnQvc3FsLzkuNl9wbHVzL2dldF9vaWQuc3Fs IGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy9leGNsdXNpb25f Y29uc3RyYWludC9zcWwvOS42X3BsdXMvZ2V0X29pZC5zcWwKaW5kZXggMTY4 ZTEzYi4uMzgyMTc3OCAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nl ci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFi bGVzL3RlbXBsYXRlcy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS42X3Bs dXMvZ2V0X29pZC5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3Rl bXBsYXRlcy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS42X3BsdXMvZ2V0 X29pZC5zcWwKQEAgLTEsNCArMSw0IEBACi1TRUxFQ1QgY3Qub2lkCitTRUxF Q1QgY3QuY29uaW5kaWQgIGFzIG9pZAogRlJPTSBwZ19jb25zdHJhaW50IGN0 CiBXSEVSRSBjb250eXBlPSd4JyBBTkQKIGN0LmNvbm5hbWUgPSB7eyBuYW1l fHF0TGl0ZXJhbCB9fTsKXCBObyBuZXdsaW5lIGF0IGVuZCBvZiBmaWxlCmRp ZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMv c2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL2V4 Y2x1c2lvbl9jb25zdHJhaW50L3NxbC85LjZfcGx1cy9nZXRfb2lkX3dpdGhf dHJhbnNhY3Rpb24uc3FsIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJf Z3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBs YXRlcy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS42X3BsdXMvZ2V0X29p ZF93aXRoX3RyYW5zYWN0aW9uLnNxbAppbmRleCAwZmMxZmE4Li5kY2FkMjk1 IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91 cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVz L2V4Y2x1c2lvbl9jb25zdHJhaW50L3NxbC85LjZfcGx1cy9nZXRfb2lkX3dp dGhfdHJhbnNhY3Rpb24uc3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIv c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxl cy90ZW1wbGF0ZXMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvc3FsLzkuNl9wbHVz L2dldF9vaWRfd2l0aF90cmFuc2FjdGlvbi5zcWwKQEAgLTEsNCArMSw0IEBA Ci1TRUxFQ1QgY3Qub2lkLAorU0VMRUNUIGN0LmNvbmluZGlkIGFzIG9pZCwK ICAgICBjdC5jb25uYW1lIGFzIG5hbWUsCiAgICAgTk9UIGNvbnZhbGlkYXRl ZCBhcyBjb252YWxpZGF0ZWQKIEZST00gcGdfY29uc3RyYWludCBjdAo= --94eb2c03088ee2d8930544dd18fd Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers --94eb2c03088ee2d8930544dd18fd--