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 1mXfBM-0006fp-B4 for pgadmin-hackers@arkaria.postgresql.org; Tue, 05 Oct 2021 07:48:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mXfBK-00050H-QW for pgadmin-hackers@arkaria.postgresql.org; Tue, 05 Oct 2021 07:48:10 +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 1mXfBK-000509-2y for pgadmin-hackers@lists.postgresql.org; Tue, 05 Oct 2021 07:48:10 +0000 Received: from mail-vs1-xe31.google.com ([2607:f8b0:4864:20::e31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mXfBH-000052-7q for pgadmin-hackers@postgresql.org; Tue, 05 Oct 2021 07:48:08 +0000 Received: by mail-vs1-xe31.google.com with SMTP id w13so4596023vsa.2 for ; Tue, 05 Oct 2021 00:48:06 -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=Uwkenl5giIZigBZfFs2I5YV+1JyDrEpy+i1GRlh8wJA=; b=V5XocTzfvawbC2KvSfalWUUigGSXWt9oFunjkAOFiW+FnNOGWxTZpgUsjoQKCtgLRw HUbTD6S/oQsCjAi0W8EPYNOZ+ifhLV2jprlfFboUYFHSN45PseGohFD97FMxXt3RYA1t XkzeIB0XinPlC8CgVXtDN0ERw8AXwPV1Fs3kOU07/TL+cXLkaa8i9Y3ed679oLIcAJz1 Se3BXvR466eAF4BombRdToXv8e7pDOiBoFrg0fY2Xr/UPcEwJSgVtGYpQEOqxv+LrY/C +aeffqaG2/s1YMYTBNgmowJBfUBASFD3bqxVkJcJKNUyuXzCgtWU3II7UZyKg0MN3Ucg wYdQ== 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=Uwkenl5giIZigBZfFs2I5YV+1JyDrEpy+i1GRlh8wJA=; b=lF9h0xs8C+plk4HDBA7UujX+9fqowXUggITQGS5+OIwkeIEA6bxl+iYexDsOMLlBzO TKDUgsrbcUYFW34zUY6tlraJP/Q918fp2mF063OtInRCMpsvOsydkOOB1beXACrQBqLi rOPyfjp7sy33vALBVOa0x0f6y99wldB8+/vKnpPDl2A8EX3z+oZxKlD6hSiTpgeggrtP 9/Eli103iLG7RS8Hj/M8nscfXjxDexISmI1xoKSvhAHvdXntTlZMtUJgH2DUK+p3QKeU nabCGhYlEWtKDsYnG7wcam5q2HwQAjUpw42gxkpe3z8zodWLsZn9QtjggHrdTVgCwCKx 6OrQ== X-Gm-Message-State: AOAM5303vi8q72y831Kmh1nw3Hoq+aiV/WqyxEOruG2lTxigkNweOcsH 8vXz+8dSsm7vBLSiTeZiqu5Bqb5boeeawfsM0Pi1yxy9ZMF9r+Qx/BL1DzGtR4LwdWul3yRDsT0 3bmEf+Gf+u4UJAt0O1mCJiN8qD9I/S42MbQUL4Tqc8JP494txJWAzsrxgAUeez/rkgzIbYRXWT7 F/Z5OnSH1ojGSkDoj+u+eN2iA+QFL3LLlqUM46jpVtN5kB6SD8PHADapWwlo/NUp1dWw== X-Google-Smtp-Source: ABdhPJyrMK6fh8gmAEjrD5uNEKDCIvLDm9GxxXUe3X+JufUnI8guEu+KPYjSsxfJ21kohbBIQ13VbH4R2uN8NOTNGcc= X-Received: by 2002:a05:6102:2421:: with SMTP id l1mr17177028vsi.16.1633420085646; Tue, 05 Oct 2021 00:48:05 -0700 (PDT) MIME-Version: 1.0 From: Aditya Toshniwal Date: Tue, 5 Oct 2021 13:17:29 +0530 Message-ID: Subject: [pgAdmin][patch] Exclusion constraint and vacuum related fixes To: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000f9eb6c05cd963fba" 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 --000000000000f9eb6c05cd963fba Content-Type: multipart/alternative; boundary="000000000000f9eb6a05cd963fb8" --000000000000f9eb6a05cd963fb8 Content-Type: text/plain; charset="UTF-8" Hi Hackers, Please review the attached patch which fixes: 1. Operators dropdown disabled. Fixes #6771. 2. Vacuum options value is not considered for M-SQL when creating. Fixes #6781. -- Thanks, Aditya Toshniwal pgAdmin Hacker | Software Architect | *edbpostgres.com* "Don't Complain about Heat, Plant a TREE" --000000000000f9eb6a05cd963fb8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Please review the attached patch which fixes:<= /div>
= 1. Operators dropdown disabled. Fixes #6771.
2. Vacuum options value is not= considered for M-SQL when creating. Fixes #6781.

--
Thanks,
Aditya Toshniwal<= /font>
pgAdmin Hacker=C2=A0| Software Architect=C2=A0| edbpostgres.com<= /div>
"Don't Complain about Heat, Plant a TREE"
--000000000000f9eb6a05cd963fb8-- --000000000000f9eb6c05cd963fba Content-Type: application/octet-stream; name="RM6771_6781.patch" Content-Disposition: attachment; filename="RM6771_6781.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kudrxxue0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9leGNsdXNpb25fY29uc3RyYWludC9z dGF0aWMvanMvZXhjbHVzaW9uX2NvbnN0cmFpbnQudWkuanMgYi93ZWIvcGdhZG1pbi9icm93c2Vy L3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29uc3RyYWlu dHMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvc3RhdGljL2pzL2V4Y2x1c2lvbl9jb25zdHJhaW50LnVp LmpzCmluZGV4IDMzNjJjZDc4NS4uYmY4MDI0NGQ1IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29u c3RyYWludHMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvc3RhdGljL2pzL2V4Y2x1c2lvbl9jb25zdHJh aW50LnVpLmpzCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJz L2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9leGNsdXNpb25fY29uc3RyYWlu dC9zdGF0aWMvanMvZXhjbHVzaW9uX2NvbnN0cmFpbnQudWkuanMKQEAgLTE2OSw3ICsxNjksOSBA QCBjbGFzcyBFeGNsdXNpb25Db2x1bW5TY2hlbWEgZXh0ZW5kcyBCYXNlVUlTY2hlbWEgewogICAg IH0sewogICAgICAgaWQ6ICdvcGVyYXRvcicsIGxhYmVsOiBnZXR0ZXh0KCdPcGVyYXRvcicpLCB0 eXBlOiAnc2VsZWN0JywKICAgICAgIHdpZHRoOiA5NSwKLSAgICAgIGVkaXRhYmxlOiBvYmouaXNF ZGl0YWJsZSwKKyAgICAgIGVkaXRhYmxlOiBmdW5jdGlvbigpIHsKKyAgICAgICAgcmV0dXJuIG9i ai5pc05ld0V4Q29uczsKKyAgICAgIH0sCiAgICAgICBjZWxsOiAoc3RhdGUpPT57CiAgICAgICAg IHJldHVybiB7CiAgICAgICAgICAgY2VsbDogJ3NlbGVjdCcsCmRpZmYgLS1naXQgYS93ZWIvcGdh ZG1pbi9zdGF0aWMvanMvU2NoZW1hVmlldy9pbmRleC5qc3ggYi93ZWIvcGdhZG1pbi9zdGF0aWMv anMvU2NoZW1hVmlldy9pbmRleC5qc3gKaW5kZXggZTVlODJiOGQ3Li4wZjMwNzNlOWUgMTAwNjQ0 Ci0tLSBhL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy9TY2hlbWFWaWV3L2luZGV4LmpzeAorKysgYi93 ZWIvcGdhZG1pbi9zdGF0aWMvanMvU2NoZW1hVmlldy9pbmRleC5qc3gKQEAgLTExNCw3ICsxMTQs NyBAQCBjb25zdCBkaWZmQXJyYXlPcHRpb25zID0gewogICBjb21wYXJlRnVuY3Rpb246IG9iamVj dENvbXBhcmF0b3IsCiB9OwogCi1mdW5jdGlvbiBnZXRDaGFuZ2VkRGF0YSh0b3BTY2hlbWEsIHZp ZXdIZWxwZXJQcm9wcywgc2Vzc0RhdGEsIHN0cmluZ2lmeT1mYWxzZSkgeworZnVuY3Rpb24gZ2V0 Q2hhbmdlZERhdGEodG9wU2NoZW1hLCB2aWV3SGVscGVyUHJvcHMsIHNlc3NEYXRhLCBzdHJpbmdp Znk9ZmFsc2UsIGluY2x1ZGVTa2lwQ2hhbmdlPXRydWUpIHsKICAgbGV0IGNoYW5nZWREYXRhID0g e307CiAgIGxldCBpc0VkaXQgPSB2aWV3SGVscGVyUHJvcHMubW9kZSA9PT0gJ2VkaXQnOwogCkBA IC0xNDcsOCArMTQ3LDkgQEAgZnVuY3Rpb24gZ2V0Q2hhbmdlZERhdGEodG9wU2NoZW1hLCB2aWV3 SGVscGVyUHJvcHMsIHNlc3NEYXRhLCBzdHJpbmdpZnk9ZmFsc2UpIHsKICAgICAgIGxldCB7bW9k ZVN1cHBvcnRlZH0gPSBnZXRGaWVsZE1ldGFEYXRhKGZpZWxkLCBzY2hlbWEsIHt9LCB2aWV3SGVs cGVyUHJvcHMsIHRydWUpOwogCiAgICAgICAvKiBJZiBza2lwQ2hhbmdlIGlzIHRydWUsIHRoZW4g ZmllbGQgd2lsbCBub3QgYmUgY29uc2lkZXJlZCBmb3IgY2hhbmdlZCBkYXRhLAorICAgICAgVGhp cyBpcyBoZWxwZnVsIHdoZW4gU2F2ZSBvciBSZXNldCBzaG91bGQgbm90IGJlIGVuYWJsZWQgb24g dGhpcyBmaWVsZCBjaGFuZ2UgYWxvbmUuCiAgICAgICBObyBjaGFuZ2UgaW4gb3RoZXIgYmVoYXZp b3VyICovCi0gICAgICBpZighbW9kZVN1cHBvcnRlZCB8fCBmaWVsZC5za2lwQ2hhbmdlKSB7Cisg ICAgICBpZighbW9kZVN1cHBvcnRlZCB8fCAoZmllbGQuc2tpcENoYW5nZSAmJiAhaW5jbHVkZVNr aXBDaGFuZ2UpKSB7CiAgICAgICAgIHJldHVybjsKICAgICAgIH0KICAgICAgIGlmKHR5cGVvZihm aWVsZC50eXBlKSA9PSAnc3RyaW5nJyAmJiBmaWVsZC50eXBlLnN0YXJ0c1dpdGgoJ25lc3RlZC0n KSkgewpAQCAtNDc3LDcgKzQ3OCw3IEBAIGZ1bmN0aW9uIFNjaGVtYURpYWxvZ1ZpZXcoewogICAg IGlmKCFpc05vdFZhbGlkKSBzZXRGb3JtRXJyKHt9KTsKIAogICAgIC8qIGNoZWNrIGlmIGFueXRo aW5nIGNoYW5nZWQgKi8KLSAgICBsZXQgY2hhbmdlZERhdGEgPSBnZXRDaGFuZ2VkRGF0YShzY2hl bWEsIHZpZXdIZWxwZXJQcm9wcywgc2Vzc0RhdGEpOworICAgIGxldCBjaGFuZ2VkRGF0YSA9IGdl dENoYW5nZWREYXRhKHNjaGVtYSwgdmlld0hlbHBlclByb3BzLCBzZXNzRGF0YSwgZmFsc2UsIGZh bHNlKTsKICAgICBsZXQgaXNEYXRhQ2hhbmdlZCA9IE9iamVjdC5rZXlzKGNoYW5nZWREYXRhKS5s ZW5ndGggPiAwOwogICAgIHNldERpcnR5KGlzRGF0YUNoYW5nZWQpOwogCg== --000000000000f9eb6c05cd963fba--