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 1maZYX-0006b4-MT for pgadmin-hackers@arkaria.postgresql.org; Wed, 13 Oct 2021 08:24:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maZY0-000592-RK for pgadmin-hackers@arkaria.postgresql.org; Wed, 13 Oct 2021 08:23:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maZY0-0004tp-7X for pgadmin-hackers@lists.postgresql.org; Wed, 13 Oct 2021 08:23:36 +0000 Received: from mail-ua1-x935.google.com ([2607:f8b0:4864:20::935]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1maZXZ-00054O-P5 for pgadmin-hackers@postgresql.org; Wed, 13 Oct 2021 08:23:11 +0000 Received: by mail-ua1-x935.google.com with SMTP id g13so2913083uaj.3 for ; Wed, 13 Oct 2021 01:23:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=gFVsVQRSL7GR838HmHq2R1eYXhzU4DHLipB2dogEHeg=; b=aTC8n/GNeWxWxHMjGcFY8cUbfjfEl7usuyH1YXb9Xxgzl0yf3Az4OOIHEiZoEM973B 3M/gOv/ImT9sWtokcuJLsGfRfxHXqRSVO2Y8vzpcyhQBuQ6+UQU7o0CPI3K8o/RbgzCn /fql42lkKT0njrjFjzIDfz9Gvc3797wujaAuHLYixotnxUkogRnRUcBP1w6l2tjKn7fE P1GOHFu5zi9xhHXNBNfH/0pXF5HsDeL370xKUccgob1qkzQrC66u2QGZWW6G8mmxbsDC ARyoAcwmcSB67YiYLNOOoILgNWi7Clp+EEMd3dkz2Q3fQuTVHktzoGuwXqVw0+qz01Au 7thg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=gFVsVQRSL7GR838HmHq2R1eYXhzU4DHLipB2dogEHeg=; b=ROHP9Fgz7dZYzYPZ4nFvrkAa4N1vOFL2Ugamnt9hXfaplD67d1bYABYv97bNUBrz32 9+j5CKKJn3kWMHSuuICQh9rQeazEEf0//M5g6qD0jY4BpVpzU5aJey6uBE6XfVivbKWi 1J3X803cZ5D42wbx9etl9Gf2/Qo0H0BiQWyEF3uGgc4kLfmbcodPx4A6oRfzA2pz6gpf nPYYCjscAsRomYAWHLWgbX6cETQTtYhVHjXaSNCHN+2D2+CexLgVi2lOYQbGMEEwOPa6 wDrHLqBBeo43QC5c/+NtAF0z0/lxE1ec/46bDUkDUliO8UX+sna5XeLxCOGtbz3F7nD9 P9ZA== X-Gm-Message-State: AOAM532oBlGMYkWnN1ZZx6nCw6s1Y1VRgRldT2a5sA+dD1MlqMqDyEtA yOPWDtfq+u3hP8SRBrTx4+YvUWjeXltlsaAxEBgXrgK0SmsOqFv7hPXvn3g1X0gdDNJW6KPWzSI Io617ttiD8gbRMo5MMyy1ELbQNDTQegw5ODCKTkKpUrBTiOnkpdfiZIPMOalfVTYEY3vEbbEjAt 8PyqbV/HwtV5jy0IO0LcUrxeczAg9E7jOVb+JN7k0fjWfm6WUxsoD7lBkXEQ== X-Google-Smtp-Source: ABdhPJwz3E8f5gXo68bloJMTpSmXVhVDEPAQmXR0T4yKCvTf48QC4acW1oKO74C8e0ivtOPUQ/NjaRZduY13W/9MAmI= X-Received: by 2002:ab0:619a:: with SMTP id h26mr17281668uan.64.1634113386966; Wed, 13 Oct 2021 01:23:06 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Wed, 13 Oct 2021 13:52:30 +0530 Message-ID: Subject: Re: [pgAdmin][RM6891] Composite foreign keys in ERD To: Akshay Joshi Cc: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000f44bef05ce37ab4c" 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 --000000000000f44bef05ce37ab4c Content-Type: multipart/alternative; boundary="000000000000f44bed05ce37ab4a" --000000000000f44bed05ce37ab4a Content-Type: text/plain; charset="UTF-8" Hi, Attached is the updated patch. On Wed, Oct 13, 2021 at 12:53 PM Akshay Joshi wrote: > Hi Aditya > > Jasmine test cases are failing after applying the patch. Can you please > fix and resend it. > > On Wed, Oct 13, 2021 at 12:35 PM Aditya Toshniwal < > aditya.toshniwal@enterprisedb.com> wrote: > >> Hi Hackers, >> >> Please review the attached patch which adds support for composite foreign >> keys in ERD. >> >> -- >> Thanks, >> Aditya Toshniwal >> pgAdmin Hacker | Software Architect | *edbpostgres.com* >> >> "Don't Complain about Heat, Plant a TREE" >> > > > -- > *Thanks & Regards* > *Akshay Joshi* > *pgAdmin Hacker | Principal Software Architect* > *EDB Postgres * > > *Mobile: +91 976-788-8246* > -- Thanks, Aditya Toshniwal pgAdmin Hacker | Software Architect | *edbpostgres.com* "Don't Complain about Heat, Plant a TREE" --000000000000f44bed05ce37ab4a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Attached is the updated patch.

On Wed, Oct 13= , 2021 at 12:53 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi=C2=A0Aditya
=
Jasmine test cases are failing after applying=C2=A0the patch= . Can you please fix and resend it.

On Wed, Oct 13, 2021 at 12:35 PM A= ditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft:1px solid rgb(204,204,204);padding-left:1ex">
Hi Hackers,
Please review the attached patch which adds support for composite foreig= n keys in ERD.

--
<= font size=3D"2" color=3D"#000000" face=3D"arial, sans-serif">Thanks,=
Aditya Toshniwal
pg= Admin Hacker=C2=A0| Software Architect=C2=A0| edbpostgres.com
"Don't Co= mplain about Heat, Plant a TREE"
=


--
Thank= s & Regards
Akshay Joshi
pgAdmin Hacker | Principal Softw= are Architect
EDB Po= stgres
Mobile: +91 976-788-8246



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Software A= rchitect=C2=A0| edbpostgres.com
"Don't Complain about Heat, Plant a TREE&qu= ot;
--000000000000f44bed05ce37ab4a-- --000000000000f44bef05ce37ab4c Content-Type: application/octet-stream; name="RM6891_v2.patch" Content-Disposition: attachment; filename="RM6891_v2.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kup8w9l00 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9mb3JlaWduX2tleS9zdGF0aWMvanMv Zm9yZWlnbl9rZXkudWkuanMgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2Vy dmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29uc3RyYWludHMvZm9yZWlnbl9rZXkvc3Rh dGljL2pzL2ZvcmVpZ25fa2V5LnVpLmpzCmluZGV4IDJkZmZhNWYwMi4uNGFhZTIzYmRiIDEwMDY0 NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy90YWJsZXMvY29uc3RyYWludHMvZm9yZWlnbl9rZXkvc3RhdGljL2pzL2ZvcmVp Z25fa2V5LnVpLmpzCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2 ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9mb3JlaWduX2tleS9zdGF0 aWMvanMvZm9yZWlnbl9rZXkudWkuanMKQEAgLTI1Niw3ICsyNTYsMTMgQEAgZXhwb3J0IGRlZmF1 bHQgY2xhc3MgRm9yZWlnbktleVNjaGVtYSBleHRlbmRzIEJhc2VVSVNjaGVtYSB7CiAgICAgICAg ICAgfQogICAgICAgICB9CiAKLSAgICAgICAgbGV0IG9sZGluZGV4ID0gJ2ZraV8nK2FjdGlvbk9i ai5vbGRTdGF0ZS5uYW1lOworICAgICAgICBsZXQgb2xkaW5kZXg7CisgICAgICAgIGlmKG9iai5p blRhYmxlKSB7CisgICAgICAgICAgbGV0IG9sZEZrID0gXy5nZXQoYWN0aW9uT2JqLm9sZFN0YXRl LCBfLnNsaWNlKGFjdGlvbk9iai5wYXRoLCAwLCAtMSkpOworICAgICAgICAgIG9sZGluZGV4ID0g J2ZraV8nK29sZEZrLm5hbWU7CisgICAgICAgIH0gZWxzZSB7CisgICAgICAgICAgb2xkaW5kZXgg PSAnZmtpXycrYWN0aW9uT2JqLm9sZFN0YXRlLm5hbWU7CisgICAgICAgIH0KICAgICAgICAgaWYo c3RhdGUuaGFzaW5kZXgpIHsKICAgICAgICAgICByZXR1cm4ge307CiAgICAgICAgIH0gZWxzZSBp Zighc3RhdGUuYXV0b2luZGV4KSB7CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3Nl cnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvc3RhdGljL2pzL3Rh YmxlLnVpLmpzIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0 YWJhc2VzL3NjaGVtYXMvdGFibGVzL3N0YXRpYy9qcy90YWJsZS51aS5qcwppbmRleCA1ZDhkMWQw MzkuLmE4ZTFiOGNjYSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3Jv dXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3N0YXRpYy9qcy90YWJsZS51aS5q cworKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy90YWJsZXMvc3RhdGljL2pzL3RhYmxlLnVpLmpzCkBAIC0zNTIsNiArMzUyLDE1 IEBAIGV4cG9ydCBkZWZhdWx0IGNsYXNzIFRhYmxlU2NoZW1hIGV4dGVuZHMgQmFzZVVJU2NoZW1h IHsKICAgICAgIGRlbGV0ZSBjLmluaGVyaXRlZGZyb210YWJsZTsKICAgICAgIHJldHVybiBjOwog ICAgIH0pOworCisgICAgLyogTWFrZSBhdXRvaW5kZXggYXMgdHJ1ZSBpZiB0aGVyZSBpcyBjb3Zl cmluZ2luZGV4IHNpbmNlIEVSRCB3b3JrcyBpbiBjcmVhdGUgbW9kZSAqLworICAgIG5ld0RhdGEu Zm9yZWlnbl9rZXkgPSAobmV3RGF0YS5mb3JlaWduX2tleXx8W10pLm1hcCgoZmspPT57CisgICAg ICBmay5hdXRvaW5kZXggPSBmYWxzZTsKKyAgICAgIGlmKGZrLmNvdmVyaW5naW5kZXgpIHsKKyAg ICAgICAgZmsuYXV0b2luZGV4ID0gdHJ1ZTsKKyAgICAgIH0KKyAgICAgIHJldHVybiBmazsKKyAg ICB9KTsKICAgICByZXR1cm4gbmV3RGF0YTsKICAgfQogCmRpZmYgLS1naXQgYS93ZWIvcGdhZG1p bi90b29scy9lcmQvc3RhdGljL2pzL2VyZF90b29sL25vZGVzL1RhYmxlTm9kZS5qc3ggYi93ZWIv cGdhZG1pbi90b29scy9lcmQvc3RhdGljL2pzL2VyZF90b29sL25vZGVzL1RhYmxlTm9kZS5qc3gK aW5kZXggZGIyZmYzMDUwLi5mYjQzZmE3NjggMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3Rvb2xz L2VyZC9zdGF0aWMvanMvZXJkX3Rvb2wvbm9kZXMvVGFibGVOb2RlLmpzeAorKysgYi93ZWIvcGdh ZG1pbi90b29scy9lcmQvc3RhdGljL2pzL2VyZF90b29sL25vZGVzL1RhYmxlTm9kZS5qc3gKQEAg LTY1LDggKzY1LDkgQEAgZXhwb3J0IGNsYXNzIFRhYmxlTm9kZU1vZGVsIGV4dGVuZHMgRGVmYXVs dE5vZGVNb2RlbCB7CiAgIH0KIAogICBjbG9uZURhdGEobmFtZSkgeworICAgIGNvbnN0IFNLSVBf Q0xPTkVfS0VZUyA9IFsnZm9yZWlnbl9rZXknXTsKICAgICBsZXQgbmV3RGF0YSA9IHsKLSAgICAg IC4uLnRoaXMuZ2V0RGF0YSgpLAorICAgICAgLi4uXy5waWNrQnkodGhpcy5nZXREYXRhKCksIChf diwgayk9PihTS0lQX0NMT05FX0tFWVMuaW5kZXhPZihrKSA9PSAtMSkpLAogICAgIH07CiAgICAg aWYobmFtZSkgewogICAgICAgbmV3RGF0YVsnbmFtZSddID0gbmFtZTsKQEAgLTE0OCwxMiArMTQ5 LDE2IEBAIGV4cG9ydCBjbGFzcyBUYWJsZU5vZGVXaWRnZXQgZXh0ZW5kcyBSZWFjdC5Db21wb25l bnQgewogICAgIH0pOwogICB9CiAKLSAgZ2VuZXJhdGVDb2x1bW4oY29sKSB7CisgIGdlbmVyYXRl Q29sdW1uKGNvbCwgdGFibGVEYXRhKSB7CiAgICAgbGV0IHBvcnQgPSB0aGlzLnByb3BzLm5vZGUu Z2V0UG9ydCh0aGlzLnByb3BzLm5vZGUuZ2V0UG9ydE5hbWUoY29sLmF0dG51bSkpOwogICAgIGxl dCBpY29uID0gQ29sdW1uSWNvbjsKKyAgICBsZXQgbG9jYWxGa0NvbHMgPSBbXTsKKyAgICAodGFi bGVEYXRhLmZvcmVpZ25fa2V5fHxbXSkuZm9yRWFjaCgoZmspPT57CisgICAgICBsb2NhbEZrQ29s cy5wdXNoKC4uLmZrLmNvbHVtbnMubWFwKChjKT0+Yy5sb2NhbF9jb2x1bW4pKTsKKyAgICB9KTsK ICAgICBpZihjb2wuaXNfcHJpbWFyeV9rZXkpIHsKICAgICAgIGljb24gPSBQcmltYXJ5S2V5SWNv bjsKLSAgICB9IGVsc2UgaWYocG9ydCAmJiBwb3J0LmdldFN1YnR5cGUoKSA9PSAnbWFueScpIHsK KyAgICB9IGVsc2UgaWYobG9jYWxGa0NvbHMuaW5kZXhPZihjb2wubmFtZSkgPiAtMSkgewogICAg ICAgaWNvbiA9IEZvcmVpZ25LZXlJY29uOwogICAgIH0KICAgICByZXR1cm4gKApAQCAtMTg2LDcg KzE5MSw3IEBAIGV4cG9ydCBjbGFzcyBUYWJsZU5vZGVXaWRnZXQgZXh0ZW5kcyBSZWFjdC5Db21w b25lbnQgewogICB9CiAKICAgcmVuZGVyKCkgewotICAgIGxldCBub2RlX2RhdGEgPSB0aGlzLnBy b3BzLm5vZGUuZ2V0RGF0YSgpOworICAgIGxldCB0YWJsZURhdGEgPSB0aGlzLnByb3BzLm5vZGUu Z2V0RGF0YSgpOwogICAgIHJldHVybiAoCiAgICAgICA8ZGl2IGNsYXNzTmFtZT17J3RhYmxlLW5v ZGUgJyArICh0aGlzLnByb3BzLm5vZGUuaXNTZWxlY3RlZCgpID8gJ3NlbGVjdGVkJzogJycpIH0g b25Eb3VibGVDbGljaz17KCk9Pnt0aGlzLnByb3BzLm5vZGUuZmlyZUV2ZW50KHt9LCAnZWRpdFRh YmxlJyk7fX0+CiAgICAgICAgIDxkaXYgY2xhc3NOYW1lPSJ0YWJsZS10b29sYmFyIj4KQEAgLTE5 OCwxNCArMjAzLDE0IEBAIGV4cG9ydCBjbGFzcyBUYWJsZU5vZGVXaWRnZXQgZXh0ZW5kcyBSZWFj dC5Db21wb25lbnQgewogICAgICAgICA8L2Rpdj4KICAgICAgICAgPGRpdiBjbGFzc05hbWU9ImQt ZmxleCB0YWJsZS1zY2hlbWEtZGF0YSI+CiAgICAgICAgICAgPFJvd0ljb24gaWNvbj17U2NoZW1h SWNvbn0vPgotICAgICAgICAgIDxkaXYgY2xhc3NOYW1lPSJ0YWJsZS1zY2hlbWEgbXktYXV0byI+ e25vZGVfZGF0YS5zY2hlbWF9PC9kaXY+CisgICAgICAgICAgPGRpdiBjbGFzc05hbWU9InRhYmxl LXNjaGVtYSBteS1hdXRvIj57dGFibGVEYXRhLnNjaGVtYX08L2Rpdj4KICAgICAgICAgPC9kaXY+ CiAgICAgICAgIDxkaXYgY2xhc3NOYW1lPSJkLWZsZXggdGFibGUtbmFtZS1kYXRhIj4KICAgICAg ICAgICA8Um93SWNvbiBpY29uPXtUYWJsZUljb259IC8+Ci0gICAgICAgICAgPGRpdiBjbGFzc05h bWU9InRhYmxlLW5hbWUgbXktYXV0byI+e25vZGVfZGF0YS5uYW1lfTwvZGl2PgorICAgICAgICAg IDxkaXYgY2xhc3NOYW1lPSJ0YWJsZS1uYW1lIG15LWF1dG8iPnt0YWJsZURhdGEubmFtZX08L2Rp dj4KICAgICAgICAgPC9kaXY+CiAgICAgICAgIDxkaXYgY2xhc3NOYW1lPSJ0YWJsZS1jb2xzIj4K LSAgICAgICAgICB7Xy5tYXAobm9kZV9kYXRhLmNvbHVtbnMsIChjb2wpPT50aGlzLmdlbmVyYXRl Q29sdW1uKGNvbCkpfQorICAgICAgICAgIHtfLm1hcCh0YWJsZURhdGEuY29sdW1ucywgKGNvbCk9 PnRoaXMuZ2VuZXJhdGVDb2x1bW4oY29sLCB0YWJsZURhdGEpKX0KICAgICAgICAgPC9kaXY+CiAg ICAgICA8L2Rpdj4KICAgICApOwpkaWZmIC0tZ2l0IGEvd2ViL3JlZ3Jlc3Npb24vamF2YXNjcmlw dC9zY2hlbWFfdWlfZmlsZXMvZm9yZWlnbl9rZXkudWkuc3BlYy5qcyBiL3dlYi9yZWdyZXNzaW9u L2phdmFzY3JpcHQvc2NoZW1hX3VpX2ZpbGVzL2ZvcmVpZ25fa2V5LnVpLnNwZWMuanMKaW5kZXgg N2I3Mjg4ZWFhLi5kODQxYmIzZDIgMTAwNjQ0Ci0tLSBhL3dlYi9yZWdyZXNzaW9uL2phdmFzY3Jp cHQvc2NoZW1hX3VpX2ZpbGVzL2ZvcmVpZ25fa2V5LnVpLnNwZWMuanMKKysrIGIvd2ViL3JlZ3Jl c3Npb24vamF2YXNjcmlwdC9zY2hlbWFfdWlfZmlsZXMvZm9yZWlnbl9rZXkudWkuc3BlYy5qcwpA QCAtMTcwLDkgKzE3MCwxMyBAQCBkZXNjcmliZSgnRm9yZWlnbktleVNjaGVtYScsICgpPT57CiAK ICAgaXQoJ2RlcENoYW5nZScsICgpPT57CiAgICAgbGV0IHN0YXRlID0ge2NvbHVtbnM6IFt7bG9j YWxfY29sdW1uOiAnaWQnfV19OwotICAgIGxldCBhY3Rpb25PYmogPSB7b2xkU3RhdGU6e25hbWU6 ICdma25hbWUnfX07CisgICAgbGV0IGFjdGlvbk9iaiA9IHsKKyAgICAgIHBhdGg6IFsnbmFtZSdd LAorICAgICAgb2xkU3RhdGU6IHsKKyAgICAgICAgbmFtZTogJ2ZrbmFtZScsCisgICAgICB9Cisg ICAgfTsKIAotICAgIHNjaGVtYU9iai5ub2RlSW5mbyA9IHtmb3JlaWduX2tleToge319OwogICAg IHN0YXRlLmF1dG9pbmRleCA9IHRydWU7CiAgICAgc3RhdGUubmFtZSA9ICdma25hbWUnOwogICAg IGV4cGVjdChnZXRGaWVsZERlcENoYW5nZShzY2hlbWFPYmosICdhdXRvaW5kZXgnKShzdGF0ZSwg bnVsbCwgbnVsbCwgYWN0aW9uT2JqKSkudG9FcXVhbCh7Cg== --000000000000f44bef05ce37ab4c--