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 1maHiB-0002vk-Oi for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Oct 2021 13:20:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maHi9-00038A-FK for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Oct 2021 13:20: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 1maHi8-000382-Qd for pgadmin-hackers@lists.postgresql.org; Tue, 12 Oct 2021 13:20:53 +0000 Received: from mail-ua1-x92d.google.com ([2607:f8b0:4864:20::92d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1maHi2-0005R0-2f for pgadmin-hackers@postgresql.org; Tue, 12 Oct 2021 13:20:51 +0000 Received: by mail-ua1-x92d.google.com with SMTP id u5so18434273uao.13 for ; Tue, 12 Oct 2021 06:20:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:from:date:message-id:subject:to; bh=vN6GqEk7yvQcgNMAcph70NQe+Ou1Yi63uZl5Xz+zJdQ=; b=lIY64icixauZHtL5UAWHajorVR99FQiuCh+Q1OvcJJJwak+MGU30wTfC8ReEQrviZU FrCjWVq7ng//+1KyYhidrja1UUeJXBdw12MjlK8UIeMrQcwKU4bi9dHNWqL8UoHkA2G+ RaCNrrbuS87w2RYMB2IgUip8fLfWG0xP564JJKH8lS1Ups81IFPhjMTbrazVEUiIgtve RDf7IbYEyMs4DI3V4rz43DG+RANJ7sPnUwKhyvkarG9nSbunmQygeD8G7Dv+JMizWF+V 4s+aTfhC03XB7pwRmazQMEGIJC7pcoLVNWLA96KxAcV40sW0MMk4zBhXt/CwGQQCJBO3 t3Ug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=vN6GqEk7yvQcgNMAcph70NQe+Ou1Yi63uZl5Xz+zJdQ=; b=AxuFc8L2dBD5jq4l7i5sgi4XX52gJebv3dfAIKrNHMTVnE+rvrs9ZrGoYLPUiimBJJ YDVetHAbtxUjGDWGofB2VAQqhbd1ZzYKXE0oCY0E7MF0bBck+CqN/+o7Owd2PMOglZrK TXweFU3kaNCLAuvcnCKnwPRLqey0kciV3TmB73u65Jv1xmI3un2qf0TOhc4KmUtIik6J Sdx9cCeMaw6tDm0Fm97Kv+EkFDACwt+yd/VXVdnE8BmTNF1nrM+D/Iy5sYP6+iRtQEg6 sM75Qrt0oos5cFw0l+nZk9KhnEwKi9X7ssi/6wPf1lWXrlEbDTwhSu7hj2jPKoCigd6n mTYw== X-Gm-Message-State: AOAM531vup/9+6jeXVLChlolNPbvn5cKE5FOfV254Icp+zhan+j1Zghs 3LeAnOQciwzm1gUb094d9PcSubij2fYf7car0CZClSqQcEFjrO8hyQShCGZuD1pyd78qlXIiNb7 PwoqqY2L4ziT6uhbObr/tRLXZF+5YEfKFmgOiwB1IAPzsyuPyINBY/0cipjQbjSDrNqlSKzah2U TIVETQQCdKYvqdHg9xaf7qAch7K3y/gQg1uR/MnWIoBxHvMlNlor5uvc5DyfxulVU= X-Google-Smtp-Source: ABdhPJyRztxoHeTiEHS9Fx+hIllFFu8wFNSjyoB5CgpRnMGBdi2ELwwgzzZfxfW63mG2gf+UJvC8YMpH/6NSTSyaWss= X-Received: by 2002:a05:6102:11e5:: with SMTP id e5mr29253976vsg.7.1634044844414; Tue, 12 Oct 2021 06:20:44 -0700 (PDT) MIME-Version: 1.0 From: Aditya Toshniwal Date: Tue, 12 Oct 2021 18:50:08 +0530 Message-ID: Subject: [pgAdmin][RM6900] Unable to create exclusion constraint from table properties To: pgadmin-hackers Content-Type: multipart/mixed; boundary="00000000000080015105ce27b637" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000080015105ce27b637 Content-Type: multipart/alternative; boundary="00000000000080014f05ce27b633" --00000000000080014f05ce27b633 Content-Type: text/plain; charset="UTF-8" Hi Hackers, Attached patch fixes the issue where exclusion constraint cannot be created from table dialog if the access method name is changed once. The dialog is certainly not crashing, and not stuck. On access method change, instead of removing ex const columns, it is removing table columns. Please review. -- Thanks, Aditya Toshniwal pgAdmin Hacker | Software Architect | *edbpostgres.com* "Don't Complain about Heat, Plant a TREE" --00000000000080014f05ce27b633 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Attached patch fixes the issue where exclusion= constraint cannot be created from table dialog if the access method name i= s changed once.
The dialog is certainly=C2=A0not crashing, and not=C2=A0stu= ck. On access method change, instead=C2=A0of removing ex const columns, it = is removing table columns.

Please review.

--
<= div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature= ">
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Software Architect=C2=A0| = edbpostgres.com
=
&q= uot;Don't Complain about Heat, Plant a TREE"
--00000000000080014f05ce27b633-- --00000000000080015105ce27b637 Content-Type: application/octet-stream; name="RM6900.patch" Content-Disposition: attachment; filename="RM6900.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kuo42tk70 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy9TY2hlbWFWaWV3L0RlcExpc3RlbmVy LmpzIGIvd2ViL3BnYWRtaW4vc3RhdGljL2pzL1NjaGVtYVZpZXcvRGVwTGlzdGVuZXIuanMKaW5k ZXggODRmZGY3N2JlLi5kZDM0MThiMWIgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3N0YXRpYy9q cy9TY2hlbWFWaWV3L0RlcExpc3RlbmVyLmpzCisrKyBiL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy9T Y2hlbWFWaWV3L0RlcExpc3RlbmVyLmpzCkBAIC00Nyw4ICs0Nyw5IEBAIGV4cG9ydCBkZWZhdWx0 IGNsYXNzIERlcExpc3RlbmVyIHsKIAogICAvKiBDYWxsZWQgd2hlbiBhbnkgZmllbGQgY2hhbmdl ZCBhbmQgdHJpZ2dlciBjYWxsYmFja3MgKi8KICAgZ2V0RGVwQ2hhbmdlKGN1cnJQYXRoLCBzdGF0 ZSwgYWN0aW9uT2JqKSB7Ci0gICAgaWYoYWN0aW9uT2JqLmRlcENoYW5nZVJlc29sdmVkKSB7Ci0g ICAgICBzdGF0ZSA9IHRoaXMuX2dldExpc3RlbmVyRGF0YShzdGF0ZSwge2NhbGxiYWNrOiBhY3Rp b25PYmouZGVwQ2hhbmdlUmVzb2x2ZWR9LCBhY3Rpb25PYmopOworICAgIC8qIElmIHRoaXMgY29t ZXMgZnJvbSBkZWZlcnJlZCBjaGFuZ2UgKi8KKyAgICBpZihhY3Rpb25PYmoubGlzdGVuZXI/LmNh bGxiYWNrKSB7CisgICAgICBzdGF0ZSA9IHRoaXMuX2dldExpc3RlbmVyRGF0YShzdGF0ZSwgYWN0 aW9uT2JqLmxpc3RlbmVyLCBhY3Rpb25PYmopOwogICAgIH0gZWxzZSB7CiAgICAgICBsZXQgYWxs TGlzdGVuZXJzID0gXy5maWx0ZXIodGhpcy5fZGVwTGlzdGVuZXJzLCAoZW50cnkpPT5fLmpvaW4o Y3VyclBhdGgsICd8Jykuc3RhcnRzV2l0aChfLmpvaW4oZW50cnkuc291cmNlLCAnfCcpKSk7CiAg ICAgICBpZihhbGxMaXN0ZW5lcnMpIHsKQEAgLTcxLDYgKzcyLDcgQEAgZXhwb3J0IGRlZmF1bHQg Y2xhc3MgRGVwTGlzdGVuZXIgewogICAgICAgICAgICAgZGVmZXJyZWRMaXN0LnB1c2goewogICAg ICAgICAgICAgICBhY3Rpb246IGFjdGlvbk9iaiwKICAgICAgICAgICAgICAgcHJvbWlzZTogdGhl UHJvbWlzZSwKKyAgICAgICAgICAgICAgbGlzdGVuZXI6IGxpc3RlbmVyLAogICAgICAgICAgICAg fSk7CiAgICAgICAgICAgfQogICAgICAgICB9CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9zdGF0 aWMvanMvU2NoZW1hVmlldy9pbmRleC5qc3ggYi93ZWIvcGdhZG1pbi9zdGF0aWMvanMvU2NoZW1h Vmlldy9pbmRleC5qc3gKaW5kZXggZDc4YmE3YTdiLi4xZjMyNmYwZGEgMTAwNjQ0Ci0tLSBhL3dl Yi9wZ2FkbWluL3N0YXRpYy9qcy9TY2hlbWFWaWV3L2luZGV4LmpzeAorKysgYi93ZWIvcGdhZG1p bi9zdGF0aWMvanMvU2NoZW1hVmlldy9pbmRleC5qc3gKQEAgLTMxMyw3ICszMTMsNyBAQCBjb25z dCBnZXREZXBDaGFuZ2UgPSAoY3VyclBhdGgsIG5ld1N0YXRlLCBvbGRTdGF0ZSwgYWN0aW9uKT0+ ewogICAgICAgcGF0aDogYWN0aW9uLnBhdGgsCiAgICAgICB2YWx1ZTogYWN0aW9uLnZhbHVlLAog ICAgICAgb2xkU3RhdGU6IF8uY2xvbmVEZWVwKG9sZFN0YXRlKSwKLSAgICAgIGRlcENoYW5nZVJl c29sdmVkOiBhY3Rpb24uZGVwQ2hhbmdlUmVzb2x2ZWQsCisgICAgICBsaXN0ZW5lcjogYWN0aW9u Lmxpc3RlbmVyLAogICAgIH0pOwogICB9CiAgIHJldHVybiBuZXdTdGF0ZTsKQEAgLTQ4MCw3ICs0 ODAsMTAgQEAgZnVuY3Rpb24gU2NoZW1hRGlhbG9nVmlldyh7CiAgICAgICAgICAgdHlwZTogU0NI RU1BX1NUQVRFX0FDVElPTlMuREVGRVJSRURfREVQQ0hBTkdFLAogICAgICAgICAgIHBhdGg6IGl0 ZW0uYWN0aW9uLnBhdGgsCiAgICAgICAgICAgZGVwQ2hhbmdlOiBpdGVtLmFjdGlvbi5kZXBDaGFu Z2UsCi0gICAgICAgICAgZGVwQ2hhbmdlUmVzb2x2ZWQ6IHJlc0Z1bmMsCisgICAgICAgICAgbGlz dGVuZXI6IHsKKyAgICAgICAgICAgIC4uLml0ZW0ubGlzdGVuZXIsCisgICAgICAgICAgICBjYWxs YmFjazogcmVzRnVuYywKKyAgICAgICAgICB9LAogICAgICAgICB9KTsKICAgICAgIH0pOwogICAg IH0K --00000000000080015105ce27b637--