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 1kKEVc-0002WD-HN for pgadmin-hackers@arkaria.postgresql.org; Mon, 21 Sep 2020 05:37:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kKEVb-0006e2-EQ for pgadmin-hackers@arkaria.postgresql.org; Mon, 21 Sep 2020 05:37:03 +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 1kKEVb-0006dv-9D for pgadmin-hackers@lists.postgresql.org; Mon, 21 Sep 2020 05:37:03 +0000 Received: from mail-il1-x142.google.com ([2607:f8b0:4864:20::142]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kKEVY-0000o0-Ei for pgadmin-hackers@postgresql.org; Mon, 21 Sep 2020 05:37:02 +0000 Received: by mail-il1-x142.google.com with SMTP id u18so12456481iln.13 for ; Sun, 20 Sep 2020 22:37:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=L32KHk19y3CTpeBR39Um1KmM8DXsSqXEvFAnOFNhNO4=; b=dfbecffP3wt0NWYu7r5vLDKbK7tc+o0OdPtmMfLvXlm/bfs7y+z9EmvZ+NN8c+qxKX NYhCA8PpaO9I21flzHcDuRmfdm8aHWnWmF/+qKOaM8V22oo489D2dCg/YLILc4T9F0ar HmaE4V0ZBo3p793gh3sAdin/Qs6cMDEUiCXHot2acDVj5Ob4ZROHGMr3pSVyiFvnEzjV 1SrOsyEdYu1wWtJJu2IBQJxOtIrieZREFh6PDa0dDa6SsKgzEosF6MPGggHiE/J02Cgr 5cpe1FR4uX/f+iIyhvUSUhQKXFMTbW/icc/7SauLG9m15/OoFo4qDDAJB8SytJ9v3lyH JQMQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=L32KHk19y3CTpeBR39Um1KmM8DXsSqXEvFAnOFNhNO4=; b=tVKYH1697+q8QLiHrjMKgd+OX5m7nVwmu0Pmb4TqOTcwbG1KtbMB/AdhYwuDA+w17b wgP+7qskh2YgJdn3smoxepv7UtIP8Sdpb6LelWt9rX2oTw2m/iRNCnsTMnRP2gbien7F z5hBD/2PlwWXFyPnubcNyjL/DeyKOJK+dP+pK0dmGrHtxKzhjrMs6av/BiH7ReVVJQ7t +V4a3V3RFT0kIMV3wPlhyEZaVdWMHumiOfM9HmiJnvRQcRYtWQREJuEBFFsn3d6T01TH CxDhQPFsUt7WB5Ct9MO1Z8QuAgb6sC5MNZHXUr/N+UlOXIqcpLgAUGdTut418YKq8Ju3 YxxA== X-Gm-Message-State: AOAM532PfPO4MnpL9DAUX4JmyTnsuZus8NXHBCmh3fxR1FnajMeV84d9 yqIUc3TQr2FPnYUUAFau4BA0bn5a5mCAQ1c05Dp3tBQeb9n230a0/RSJZbBluPIThJrzEfzUusv 7nA2iuL2x0xS8EEobhNTrlX3edtcnfkLg5AU9onvdij5GdgGL/mH3czV+vwAoTGtLh6tjEJ9pPA DGdq2NgyyqzVnzNdh1aCs33DjCd1t9sZ+Zai50r8p7QJtFuQLYXbRJRXV4lg== X-Google-Smtp-Source: ABdhPJzoQunG5p2kLc8Lz3EPJExUKUIQLs+jqUUbKs4lBsaYLG18LJLUcTnGwjPlLlDXteYuYq25uEEOsFCcjwB8J1c= X-Received: by 2002:a92:7711:: with SMTP id s17mr30435234ilc.236.1600666618003; Sun, 20 Sep 2020 22:36:58 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Mon, 21 Sep 2020 11:06:47 +0530 Message-ID: Subject: Re: [pgAdmin][RM5807] Removed columns use modified name in generated script To: Aditya Toshniwal Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000002c639005afcc3dbd" 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: Precedence: bulk --0000000000002c639005afcc3dbd Content-Type: text/plain; charset="UTF-8" Thanks, patch applied. On Thu, Sep 17, 2020 at 3:29 PM Aditya Toshniwal < aditya.toshniwal@enterprisedb.com> wrote: > Hi Hackers, > > If a column is renamed and then removed, then drop SQL query takes the > renamed column and not the original one. > Attached is the patch to fix this issue. > > -- > Thanks, > Aditya Toshniwal > pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* > > "Don't Complain about Heat, Plant a TREE" > -- *Thanks & Regards* *Akshay Joshi* *pgAdmin Hacker | Sr. Software Architect* *EDB Postgres * *Mobile: +91 976-788-8246* --0000000000002c639005afcc3dbd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, patch applied.

On Thu, Sep 17, 2020 at 3:29 PM = Aditya Toshniwal <a= ditya.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

If a column i= s renamed and then removed, then drop SQL query takes the renamed column an= d not the original one.
Attached is the patch to fix this issue.
=
--
Thanks,
Aditya Toshniwal
pgAdmin hacker=C2= =A0| S= r. Software Engineer | edbpostgr= es.com
<= font face=3D"arial, sans-serif">"Don't Complain about Heat, Plant = a TREE"
<= /div>


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