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 1nUoO3-0002us-Nu for pgadmin-hackers@arkaria.postgresql.org; Thu, 17 Mar 2022 11:33:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nUoO2-0001Vu-KI for pgadmin-hackers@arkaria.postgresql.org; Thu, 17 Mar 2022 11:33:46 +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 1nUoO2-0001Vl-2Q for pgadmin-hackers@lists.postgresql.org; Thu, 17 Mar 2022 11:33:46 +0000 Received: from mail-io1-xd2d.google.com ([2607:f8b0:4864:20::d2d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nUoNx-0000Rl-Lz for pgadmin-hackers@postgresql.org; Thu, 17 Mar 2022 11:33:45 +0000 Received: by mail-io1-xd2d.google.com with SMTP id r2so5504542iod.9 for ; Thu, 17 Mar 2022 04:33:41 -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=lEl/ug3aMOQ80mWjnTFOxRgtzLvB9N17R7JzQbrvOZY=; b=k3ikVTg/tFMqj6nO2wSj+U76cOlAA2gFHGzmbrHODZuLsGbvHozOdY0fUc+4TUpRKZ Nfgg2prvKmtapB7PhuYQtavVG584JWBCwMo/S86oFyB6YLzKxg88UVJYIYMnMnaQtDLa UakHV0iNg1Ps/colNzcQ3vsrHsYFGYjJAf8c8deYuMVYVljx5mNzjzaf1dUCeGJGhNZg oqe5BOd27V4tk7kSwO4NsV+AjkS9VfhYoNNmSiZ5qY2SC5KuD4f8ACSjHRhQTvDMa40c /7vdFGAq8OTorPeH8UrZu4R0DFKfRm9SPhAIUEJJCyiy214RDx/hO2wUCsiSY+GSIooD bdJQ== 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=lEl/ug3aMOQ80mWjnTFOxRgtzLvB9N17R7JzQbrvOZY=; b=0OVB5ipocBlr0gFf9kGDmO5pCYSTeJmaxVu1Xe67x7Q7bP8dAmHfcdATMIa3cHPlIu L5UntuResXX9SHOwX3ZQeeH+8D5RNBERrgQ8TS55hsYOaj65vRzqaN/BmmqpmrDdADEU W2Q0TyAsI8AI8xC2t8g6JQnV2+35JrCjLAKA5QcLswusGgrebbEzQZSBkBJWuKl8lB2H uIK2SAs35pNMk9+WpMHFBo9XZ39YCazKgojbm/Y0A7CoWx5svQLmLlzujH2BM4VE7J7z 5MR6QMhxJDzVg2NDwBGyTAXC0o56azbiFopYpLBgT6jtVbym70b/eCkB30KroSaiWb2l S/BQ== X-Gm-Message-State: AOAM533NlaDhsh0e5xQKadeB+UOwcjaLNcZNHBqEHt/Wy5DwOCXwLSQu KGuwPheXY4KuWkPcMPZQieZxl1s7hd/FeIVvOVg/ySuYaHPG0YyEgDi85XV8EvJxdVVSZMkR2+C 6Ar7b4tclOtxpvu383XLIBhzM49QIlMm51M9LQUHv3xccBlz8PaPzdItBk4zPr/CPN8T82LHGqB cGI51Mvb0dkglt7grq9kiGPHZcJ2EjXZHGKpyQM7hsAmxL8FCKxZI7pmTyJg== X-Google-Smtp-Source: ABdhPJzynAaj3mQAlS/yd8swejHvgR9aW5JUCsuHEKfAh5Qr++ZFEFrup5wMx48bEz1Dv3Uc2pots8WveVDIyYYbIoc= X-Received: by 2002:a05:6638:150d:b0:319:a297:49a6 with SMTP id b13-20020a056638150d00b00319a29749a6mr1720105jat.128.1647516819506; Thu, 17 Mar 2022 04:33:39 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Thu, 17 Mar 2022 17:03:28 +0530 Message-ID: Subject: Re: [pgAdmin][RM7238] ERD: Remove foreign references when table node is removed To: Aditya Toshniwal Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000c9dde205da686665" 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 --000000000000c9dde205da686665 Content-Type: text/plain; charset="UTF-8" Thanks, the patch applied. On Thu, Mar 17, 2022 at 3:23 PM Aditya Toshniwal < aditya.toshniwal@enterprisedb.com> wrote: > Hi Hackers, > > Attached patch fixes issue where foreign key is not removed even if the > referred table is removed in ERD. I have also added a check to not allow > duplicate table names. > > Please review. > > -- > 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* --000000000000c9dde205da686665 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, the patch applied.

On Thu, Mar 17, 2022= at 3:23 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

At= tached patch fixes issue where foreign key is not removed even if the refer= red table is removed in ERD. I have also added a check to not allow duplica= te table names.

Please review.

--
Thanks,
Aditya Toshniwal<= /font>
pgAdmin Hacker=C2=A0| Software Architect=C2=A0| edbpostgres.com<= /div>
"Don't Complain about Heat, Plant a TREE"


--
Thanks & Regards
Akshay Joshi
pgAdmi= n Hacker | Principal Software Architect
EDB Postgres
Mobile: +91 976-788-8246

--000000000000c9dde205da686665--