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 1lU3H9-0006ji-QD for pgadmin-hackers@arkaria.postgresql.org; Wed, 07 Apr 2021 08:10:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lU3H8-0003E7-N0 for pgadmin-hackers@arkaria.postgresql.org; Wed, 07 Apr 2021 08:10:58 +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 1lU3H8-0003CZ-GH for pgadmin-hackers@lists.postgresql.org; Wed, 07 Apr 2021 08:10:58 +0000 Received: from mail-lf1-x12f.google.com ([2a00:1450:4864:20::12f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lU3H4-0007jQ-EQ for pgadmin-hackers@postgresql.org; Wed, 07 Apr 2021 08:10:58 +0000 Received: by mail-lf1-x12f.google.com with SMTP id 12so26923915lfq.13 for ; Wed, 07 Apr 2021 01:10:53 -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=aU+MmgH5BAlypKrtjDh1HgNt6HcO/ZQpNIhiZJZvfuA=; b=Uzw5b5rY49vFtKe0EHq18bA5HNq8us7VpOmQxmyuP/COIPWsAKl0S0gpz3GX640Nw1 eLhy8HzZ7LzgYFYtSSlBVq5yVOFfwr8d6oj9GCXa+BbvAdDAnWzvf09OW94GbioF+O9W V33nOR2Lm4j51/fpOBaOfT3IDh8zpBAfvKJx3eAwkXH0Kg5JloMFr5dTNM/KZEqVHK88 1Pey2ydOzFYT/OUWv8s6sNMqaujA6nKQvi7s6RcgxBOBA1FMCQF00gKm4jToy2ixy3F6 daH0XX2rdMp8MQuQnC0ZhuQyINb5U0kL/+qh2OrpYuqfAAx+8MInVLi2c0A6/aNEtoyY 3FnA== 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=aU+MmgH5BAlypKrtjDh1HgNt6HcO/ZQpNIhiZJZvfuA=; b=KG5InO//+dQBeIKX/V3dGxOubH3SzRGtvBE4jPcdpNnEQoeGoDfJJkMiB14bwtOzmF WkzfM5Z/iIrsxfXUbKEKNspYrP/lvYIVOpBxbGfzr/S+UbcQbSuS7C35BVN6X3Xgy5RX mFfpb5tiQb7/jLzMO5jmWpz6cBbzED4HzV6k9LteNR8SUCwLpyShoT9UooeViJlLd6Qr 60bq9ONx+WE+rgOdqGkB84mjtzc2GjTlclaGEBR45z/kvfLIuvyo+EVS7pusYtYQaEfF h4iZFR5Ax3pXVXnrPlMq42AemzaF4nOyzM+McLTfff2dXzqImv3gZaB24/sjKBLSWT9g cVJQ== X-Gm-Message-State: AOAM530X/+f/aLE3gbv2m9XXpv98IoaIy7JqMPRZyyGkDDOnEMTaIKTu l4mJLMgoOpW+zPtYQbBwaQ/Nc9o6egJJdmWawnxlptlEbFwJWr/D7dL4BcgoTzcYynUzE21nirT /ioqkdj3Mv40YUKhSWGanNGZ5yGwNvvPqy9rZmN4TbCtFzHsdJHbF6mLfWOwm/Q7DwSzceNA/Va +kM/ZTgAOtis3SEPUu0OM8KXPP5zIxtHq+NiwQLgvXUr6nyRIBCPNAkU+zfZIrpV3+fg== X-Google-Smtp-Source: ABdhPJzsdIaQ+QuwT7Umc3UmkOcFqO1CBL7+jq34A8fUwAfUsWO1e7xu2VsWiO7QOs6oXF2E8/MeTwMJ7Gv1MZiPMIY= X-Received: by 2002:a05:6512:3327:: with SMTP id l7mr1728042lfe.639.1617783052526; Wed, 07 Apr 2021 01:10:52 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Yogesh Mahajan Date: Wed, 7 Apr 2021 13:40:16 +0530 Message-ID: Subject: Re: [pgAdmin][Patch] RM 6082 - Able to change connection when a long query is running To: pgadmin-hackers Cc: Akshay Joshi Content-Type: multipart/mixed; boundary="0000000000002b9b2e05bf5d788e" 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 --0000000000002b9b2e05bf5d788e Content-Type: multipart/alternative; boundary="0000000000002b9b2b05bf5d788c" --0000000000002b9b2b05bf5d788c Content-Type: text/plain; charset="UTF-8" Hello, Sorry for the inconvenience. Please update the patch. Thanks, Yogesh Mahajan EnterpriseDB On Tue, Apr 6, 2021 at 4:07 PM Akshay Joshi wrote: > Hi Yogesh > > The issue is not fixed yet. I am able to change the connection while the > transaction is in progress. Please check and resend the patch. > > On Tue, Apr 6, 2021 at 1:43 PM Yogesh Mahajan < > yogesh.mahajan@enterprisedb.com> wrote: > >> Hello, >> >> Please find a patch which diables change of connection from query tool >> while query tool transaction is in progress. >> >> >> Thanks, >> Yogesh Mahajan >> EnterpriseDB >> > > > -- > *Thanks & Regards* > *Akshay Joshi* > *pgAdmin Hacker | Principal Software Architect* > *EDB Postgres * > > *Mobile: +91 976-788-8246* > --0000000000002b9b2b05bf5d788c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,

So= rry for the inconvenience.
Please update the patch.

Thanks,
Yogesh Mahajan
EnterpriseDB


On Tue, Apr 6, 2021 at 4:07 PM Akshay Joshi <<= a href=3D"mailto:akshay.joshi@enterprisedb.com">akshay.joshi@enterprisedb.c= om> wrote:
Hi=C2=A0Yogesh=

The issue is not fixed=C2=A0yet. I am able to change th= e connection while the transaction is in progress. Please check and resend = the patch.

On Tue, Apr 6, 2021 at 1:43 PM Yogesh Mahajan <yogesh.mahaja= n@enterprisedb.com> wrote:
Hello,

Please find a patc= h which diables change of connection from query tool while query tool trans= action is in progress.


=
Thanks= ,
Yogesh Mahajan
=
EnterpriseDB
=


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

--0000000000002b9b2b05bf5d788c-- --0000000000002b9b2e05bf5d788e Content-Type: application/octet-stream; name="RM6082_v2.patch" Content-Disposition: attachment; filename="RM6082_v2.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kn768bli0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy9zcWxlZGl0b3IvZXhlY3V0ZV9xdWVy eS5qcyBiL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy9zcWxlZGl0b3IvZXhlY3V0ZV9xdWVyeS5qcwpp bmRleCAyYzk2NjU1MGMuLjhiM2UxZDkxYiAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vc3RhdGlj L2pzL3NxbGVkaXRvci9leGVjdXRlX3F1ZXJ5LmpzCisrKyBiL3dlYi9wZ2FkbWluL3N0YXRpYy9q cy9zcWxlZGl0b3IvZXhlY3V0ZV9xdWVyeS5qcwpAQCAtMTMsNiArMTMsNyBAQCBpbXBvcnQgdXJs X2ZvciBmcm9tICcuLi91cmxfZm9yJzsKIGltcG9ydCBheGlvcyBmcm9tICdheGlvcyc7CiBpbXBv cnQgKiBhcyBodHRwRXJyb3JIYW5kbGVyIGZyb20gJy4vcXVlcnlfdG9vbF9odHRwX2Vycm9yX2hh bmRsZXInOwogaW1wb3J0ICogYXMgcXVlcnlUeG5TdGF0dXMgZnJvbSAnc291cmNlcy9zcWxlZGl0 b3IvcXVlcnlfdHhuX3N0YXR1c19jb25zdGFudHMnOworaW1wb3J0ICogYXMgU3FsRWRpdG9yVXRp bHMgZnJvbSAnc291cmNlcy9zcWxlZGl0b3JfdXRpbHMnOwogCiBjbGFzcyBMb2FkaW5nU2NyZWVu IHsKICAgY29uc3RydWN0b3Ioc3FsRWRpdG9yKSB7CkBAIC03NSw2ICs3Niw4IEBAIGNsYXNzIEV4 ZWN1dGVRdWVyeSB7CiAKICAgICAgICAgaWYgKEV4ZWN1dGVRdWVyeS5pc1NxbENvcnJlY3QoaHR0 cE1lc3NhZ2VEYXRhKSkgewogICAgICAgICAgIHNlbGYubG9hZGluZ1NjcmVlbi5zZXRNZXNzYWdl KCdXYWl0aW5nIGZvciB0aGUgcXVlcnkgdG8gY29tcGxldGUuLi4nKTsKKyAgICAgICAgICAvLyBE aXNhYmxlIGRyb3AgZG93biBhcnJvdyB0byBjaGFuZ2UgY29ubmVjdGlvbnMKKyAgICAgICAgICBT cWxFZGl0b3JVdGlscy5kaXNhYmxlX2Nvbm5lY3Rpb25fZHJvcGRvd24odHJ1ZSk7CiAKICAgICAg ICAgICBzZWxmLnVwZGF0ZVNxbEVkaXRvclN0YXRlV2l0aEluZm9ybWF0aW9uRnJvbVNlcnZlciho dHRwTWVzc2FnZURhdGEuZGF0YSk7CiAKQEAgLTE2MSw2ICsxNjQsMTAgQEAgY2xhc3MgRXhlY3V0 ZVF1ZXJ5IHsKICAgICAgICAgICBzZWxmLmxvYWRpbmdTY3JlZW4uaGlkZSgpOwogICAgICAgICAg IHNlbGYuc3FsU2VydmVyT2JqZWN0LnVwZGF0ZV9tc2dfaGlzdG9yeShmYWxzZSwgJ0V4ZWN1dGlv biBDYW5jZWxsZWQhJywgdHJ1ZSk7CiAgICAgICAgIH0KKyAgICAgICAgLy8gRW5hYmxlIGRyb3Bk b3duIGFycm93IHRvIGNoYW5nZSBjb25uZWN0aW9uIGlmIHN0YXR1cyBpcyBub3QgQnVzeQorICAg ICAgICBpZighIEV4ZWN1dGVRdWVyeS5pc1F1ZXJ5U3RpbGxSdW5uaW5nKGh0dHBNZXNzYWdlKSl7 CisgICAgICAgICAgU3FsRWRpdG9yVXRpbHMuZGlzYWJsZV9jb25uZWN0aW9uX2Ryb3Bkb3duKGZh bHNlKTsKKyAgICAgICAgfQogICAgICAgfQogICAgICkuY2F0Y2goCiAgICAgICBlcnJvciA9PiB7 CkBAIC0xNjgsNiArMTc1LDggQEAgY2xhc3MgRXhlY3V0ZVF1ZXJ5IHsKICAgICAgICAgc2VsZi5z cWxTZXJ2ZXJPYmplY3QucmVzZXRRdWVyeUhpc3RvcnlPYmplY3Qoc2VsZi5zcWxTZXJ2ZXJPYmpl Y3QpOwogCiAgICAgICAgIHNlbGYubG9hZGluZ1NjcmVlbi5oaWRlKCk7CisgICAgICAgIC8vIEVu YWJsZSBkcm9wZG93biBhcnJvdyB0byBjaGFuZ2UgY29ubmVjdGlvbgorICAgICAgICBTcWxFZGl0 b3JVdGlscy5kaXNhYmxlX2Nvbm5lY3Rpb25fZHJvcGRvd24oZmFsc2UpOwogICAgICAgICBzZWxm LnNxbFNlcnZlck9iamVjdC5zZXRJc1F1ZXJ5UnVubmluZyhmYWxzZSk7CiAgICAgICAgIGlmIChz ZWxmLnNxbFNlcnZlck9iamVjdC5pc19xdWVyeV90b29sKSB7CiAgICAgICAgICAgc2VsZi5lbmFi bGVTUUxFZGl0b3JCdXR0b25zKCk7CkBAIC0yMjksNiArMjM4LDcgQEAgY2xhc3MgRXhlY3V0ZVF1 ZXJ5IHsKICAgICB0aGlzLmxvYWRpbmdTY3JlZW4uaGlkZSgpOwogICAgIHRoaXMuZW5hYmxlU1FM RWRpdG9yQnV0dG9ucygpOwogCisgICAgU3FsRWRpdG9yVXRpbHMuZGlzYWJsZV9jb25uZWN0aW9u X2Ryb3Bkb3duKGZhbHNlKTsKICAgICBpZiAoRXhlY3V0ZVF1ZXJ5Lndhc0Nvbm5lY3Rpb25Mb3N0 VG9QeXRob25TZXJ2ZXIoaHR0cE1lc3NhZ2UucmVzcG9uc2UpKSB7CiAgICAgICB0aGlzLmhhbmRs ZUNvbm5lY3Rpb25Ub1NlcnZlckxvc3QoKTsKICAgICAgIHJldHVybjsKZGlmZiAtLWdpdCBhL3dl Yi9wZ2FkbWluL3N0YXRpYy9qcy9zcWxlZGl0b3JfdXRpbHMuanMgYi93ZWIvcGdhZG1pbi9zdGF0 aWMvanMvc3FsZWRpdG9yX3V0aWxzLmpzCmluZGV4IDVmNWIxNDllMC4uZTUxY2FiNTdiIDEwMDY0 NAotLS0gYS93ZWIvcGdhZG1pbi9zdGF0aWMvanMvc3FsZWRpdG9yX3V0aWxzLmpzCisrKyBiL3dl Yi9wZ2FkbWluL3N0YXRpYy9qcy9zcWxlZGl0b3JfdXRpbHMuanMKQEAgLTU3LDYgKzU3LDE3IEBA IGRlZmluZShbJ2pxdWVyeScsICd1bmRlcnNjb3JlJywgJ3NvdXJjZXMvZ2V0dGV4dCcsICdzb3Vy Y2VzL3VybF9mb3InXSwKICAgICAgICAgcmV0dXJuIHN0cmluZy5jaGFyQXQoMCkudG9VcHBlckNh c2UoKSArIHN0cmluZy5zbGljZSgxKTsKICAgICAgIH0sCiAKKyAgICAgIC8vIERpc2FibGVzIGFy cm93IHRvIGNoYW5nZSBjb25uZWN0aW9uCisgICAgICBkaXNhYmxlX2Nvbm5lY3Rpb25fZHJvcGRv d246IGZ1bmN0aW9uIChzdGF0dXMpIHsKKyAgICAgICAgaWYgKHN0YXR1cyl7CisgICAgICAgICAg JCgnLmNvbm4taW5mby1kZCcpLnByb3AoJ2Rpc2FibGVkJyx0cnVlKTsKKyAgICAgICAgICAkKCcu Y29ubmVjdGlvbi1kYXRhJykuY3NzKHtwb2ludGVyRXZlbnRzOiAnbm9uZScsIGN1cnNvcjogJ2Fy cm93J30pOworICAgICAgICB9ZWxzZXsKKyAgICAgICAgICAkKCcuY29ubi1pbmZvLWRkJykucHJv cCgnZGlzYWJsZWQnLGZhbHNlKTsKKyAgICAgICAgICAkKCcuY29ubmVjdGlvbi1kYXRhJykuY3Nz KHtwb2ludGVyRXZlbnRzOiAnYXV0bycsIGN1cnNvcjogJ3BvaW50ZXInfSk7CisgICAgICAgIH0K KyAgICAgIH0sCisKICAgICAgIC8vIFN0YXR1cyBmbGFnCiAgICAgICBwcmV2aW91c1N0YXR1czog bnVsbCwKIAo= --0000000000002b9b2e05bf5d788e--