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 1mbKmv-00053q-HI for pgadmin-hackers@arkaria.postgresql.org; Fri, 15 Oct 2021 10:50:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mbKmt-00053V-CX for pgadmin-hackers@arkaria.postgresql.org; Fri, 15 Oct 2021 10:50:07 +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 1mbKms-00053M-Pa for pgadmin-hackers@lists.postgresql.org; Fri, 15 Oct 2021 10:50:07 +0000 Received: from mail-vk1-xa33.google.com ([2607:f8b0:4864:20::a33]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mbKmo-0005xQ-42 for pgadmin-hackers@postgresql.org; Fri, 15 Oct 2021 10:50:06 +0000 Received: by mail-vk1-xa33.google.com with SMTP id j12so4906262vka.4 for ; Fri, 15 Oct 2021 03:50:01 -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=9dOMcwQo+bUcML7cTzYXLYW0TQdvEtxicbpSwXa7Rkw=; b=ZyJxZ23wbVyOLmsL74LusqhsiBztkgGGwJngvRXtbQrw+YeXOgnlkT5ouPmj5HpI0G +lP+ybEsqsixEOAWfWFI5mX38RH/Bpo/c2Y8wA9VsgLVVu+OlHw8vn+vWWeXBwBaWlyk XjWogGBQnJ1gBxBVOZkOxzyftVNUHHcxJskW17LneQokeXMt7K6IP8rNtUMs0S1rm4Cg qnpaadV7jeu4yKzbCm6Yw/yRmjN2goj84rynjBqApt3XlZPkP0r0bBCfHDvlUjPHFIMs gNG7NghLjwhv/w6ns5pWPl51hbQ/WVT4W3kLMfSp+oUUw41ESUyglumOFCjauMhSTSNU yrpg== 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=9dOMcwQo+bUcML7cTzYXLYW0TQdvEtxicbpSwXa7Rkw=; b=kLPD3KPSKvgrY2YJ5QcV4XzDnI3su8zMulaAEzUNFCg+7876P+skbtU+FCQ7O6nbmw D/brWe+59tzExNYOS5Gco4UYy+/0kNCkHseqmsL1czT5RtVCSucix5w432AigMEwgwGj G00R4bLvvRwZD3PkbbkuFj56afL7hzjF83xYzobWVd/NIONBopmuzeJRdYE7JAV8IeMk v1l+buQUsinyf/UmZiiawXvW86d69HhHuYCmfYLseMb+d9rTRkj9rS0ibPhyJ4SxuZLy Kl4kzdNeW9xzxSqEWM1GT7HnQjipnWG6iG7aRRsLFNL46JPyJsnAVYx0w46yNgHmewHv H/Bw== X-Gm-Message-State: AOAM5315D96vERqYtRynu9/4vGnVCcakJe0W6PXZEB7r52tDDaQBoUkA LJiLE1sWBS6xc/n5vRgI21UPat7IjSveEp0WUfF/s3DDqrgCw7iaGeHx57+DqAMnT0O1hkNkRgL p88FqY4RCJuVAPfehu6VPaFRZ1Az/bjmLAKBOIiiuY3YfUFqlVNKGX7qQWI9afJBQed5/rbnL1o mMpRyI5Q0um0WPGEFUfssq7fitHowpnkRxW8vdbjCWB04HflDlqsoHXoTScA== X-Google-Smtp-Source: ABdhPJyJZZkmeDGriHEkmXIPoy3VddAR0riaWat1fQQYK70Nx17IpOdKJxI0RykvCh5J/1s8pwhgGZ+y025r61kWEjU= X-Received: by 2002:a1f:608a:: with SMTP id u132mr11669959vkb.19.1634295000201; Fri, 15 Oct 2021 03:50:00 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Fri, 15 Oct 2021 16:19:24 +0530 Message-ID: Subject: Re: [pgAdmin][RM6891] Composite foreign keys in ERD To: Akshay Joshi Cc: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000f2296d05ce61f425" 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 --000000000000f2296d05ce61f425 Content-Type: multipart/alternative; boundary="000000000000f2296a05ce61f423" --000000000000f2296a05ce61f423 Content-Type: text/plain; charset="UTF-8" Hi, The patch fixes the issue where all FKs are removed if one of the multiple FKs on the same column is removed. Please review. On Wed, Oct 13, 2021 at 2:30 PM Akshay Joshi wrote: > Thanks, the patch applied. > > On Wed, Oct 13, 2021 at 1:53 PM Aditya Toshniwal < > aditya.toshniwal@enterprisedb.com> wrote: > >> Hi, >> >> Attached is the updated patch. >> >> On Wed, Oct 13, 2021 at 12:53 PM Akshay Joshi < >> akshay.joshi@enterprisedb.com> 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" >> > > > -- > *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" --000000000000f2296a05ce61f423 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

The patch fixes the issue where all FKs are removed if= one of the multiple FKs on the same column is removed.
Please review.

On Wed, Oct 13, 2021 at 2:30 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Thank= s, the patch applied.

On Wed, Oct 13, 2021 at 1:53 PM Aditya Toshniwal <<= a href=3D"mailto:aditya.toshniwal@enterprisedb.com" target=3D"_blank">adity= a.toshniwal@enterprisedb.com> wrote:
Hi,

Attached is the update= d patch.

On Wed, Oct 13, 2021 at 12:53 PM Akshay Joshi <akshay.joshi@en= terprisedb.com> wrote:
Hi=C2=A0Aditya

Jasmine te= st cases are failing after applying=C2=A0the patch. Can you please fix and = resend it.

On Wed, Oct 13, 2021 at 12:35 PM Aditya Toshniwal <aditya.to= shniwal@enterprisedb.com> wrote:
Hi Hackers,

Please review the atta= ched patch which adds support for composite foreign keys in ERD.
=
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2= =A0| S= oftware Architect=C2=A0| edbpostgr= es.com
<= font face=3D"arial, sans-serif">"Don't Complain about Heat, Plant = a TREE"
<= /div>


--
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 Architect=C2=A0| = edbpostgres.com
=
&q= uot;Don't Complain 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;
--000000000000f2296a05ce61f423-- --000000000000f2296d05ce61f425 Content-Type: application/octet-stream; name="RM6891.dropfk.patch" Content-Disposition: attachment; filename="RM6891.dropfk.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kus90lp80 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3Rvb2xzL2VyZC9zdGF0aWMvanMvZXJkX3Rvb2wvRVJE Q29yZS5qcyBiL3dlYi9wZ2FkbWluL3Rvb2xzL2VyZC9zdGF0aWMvanMvZXJkX3Rvb2wvRVJEQ29y ZS5qcwppbmRleCA2MGRiZjRlMzQuLjM5YTYwZmE0NiAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4v dG9vbHMvZXJkL3N0YXRpYy9qcy9lcmRfdG9vbC9FUkRDb3JlLmpzCisrKyBiL3dlYi9wZ2FkbWlu L3Rvb2xzL2VyZC9zdGF0aWMvanMvZXJkX3Rvb2wvRVJEQ29yZS5qcwpAQCAtMzQxLDggKzM0MSw4 IEBAIGV4cG9ydCBkZWZhdWx0IGNsYXNzIEVSRENvcmUgewogICAgIHRhYmxlRGF0YS5mb3JlaWdu X2tleT8uZm9yRWFjaCgodGhlRmtSb3cpPT57CiAgICAgICBsZXQgdGhlRmsgPSB0aGVGa1Jvdy5j b2x1bW5zWzBdOwogICAgICAgbGV0IGF0dG51bSA9IF8uZmluZCh0YWJsZU5vZGUuZ2V0Q29sdW1u cygpLCAoY29sKT0+Y29sLm5hbWU9PXRoZUZrLmxvY2FsX2NvbHVtbikuYXR0bnVtOwotICAgICAg LyogU2tpcCBhbGwgdGhvc2Ugd2hvc2UgYXR0bnVtIG1hdGNoZXMgdG8gdGhlIGxpbmsgKi8KLSAg ICAgIGlmKGxpbmtEYXRhLmxvY2FsX2NvbHVtbl9hdHRudW0gIT0gYXR0bnVtKSB7CisgICAgICAv KiBTa2lwIGFsbCB0aG9zZSB3aG9zZSBhdHRudW0gYW5kIHRhYmxlIG1hdGNoZXMgdG8gdGhlIGxp bmsgKi8KKyAgICAgIGlmKGxpbmtEYXRhLmxvY2FsX2NvbHVtbl9hdHRudW0gIT0gYXR0bnVtIHx8 IGxpbmtEYXRhLnJlZmVyZW5jZWRfdGFibGVfdWlkICE9IHRoZUZrLnJlZmVyZW5jZXMpIHsKICAg ICAgICAgbmV3Rm9yZWluZ0tleXMucHVzaCh0aGVGa1Jvdyk7CiAgICAgICB9CiAgICAgfSk7Cg== --000000000000f2296d05ce61f425--