Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ibhTv-0002G2-DP for pgadmin-hackers@arkaria.postgresql.org; Mon, 02 Dec 2019 08:55:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ibhTt-0003MF-AH for pgadmin-hackers@arkaria.postgresql.org; Mon, 02 Dec 2019 08:54:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ibhTs-0003M8-Qs for pgadmin-hackers@lists.postgresql.org; Mon, 02 Dec 2019 08:54:57 +0000 Received: from mail-lf1-x129.google.com ([2a00:1450:4864:20::129]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ibhTp-0000nL-N5 for pgadmin-hackers@postgresql.org; Mon, 02 Dec 2019 08:54:55 +0000 Received: by mail-lf1-x129.google.com with SMTP id v201so26209813lfa.11 for ; Mon, 02 Dec 2019 00:54:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=EsfnQOgpov4kjSWuodg9AHmBi/A0v9tfQUaM/A9+8co=; b=GVaOX2O4D71VIx11f2eABr2OkzACFELgOxXk4JBGZfB70b2S5HyDJgGOWxUPaWlJ0F nSSio4FNa3u95KKrsiPzTDUed3eVfeELI052xDnKokjrX71+QJG+IXKP70TvQ/2Udwux Wblxalvk3nCEFJNULa/9DHecpSnPV9EJfGExrrGpmSGvdrDJcGOLClMJyc1qBW7dW2WC J3voGlVGpxm7eYIL+E7mu6SOrIyI0cyhEyzG/Ge3Bp1N5x3UmOMeywz/9JIqYMqQx50N 2z8EzvuyvbFGeyga4XtcPELd52czkqYQM9/mJF9u0A2Xe9pG41tvhbk+MUP6xoIkr3st QmCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=EsfnQOgpov4kjSWuodg9AHmBi/A0v9tfQUaM/A9+8co=; b=M821vxB7U9YV3e01sobICbV7uJYz5JHrBZ+ReGg9L6XXT57HO/Sc48+u2fUlqn0sws Ij4T1/z8fj6hprLd74dbIWyP8UH6SW5MtQ+d8rIoBJjoY5rOJ2oD5yWpJCkIIO6bKvCc AcmG8yuC72tFphlIdWwjrN7sHR4C/xJBwVmcgUHvSr2Hm0LTk/YuW7hn9Q9ZYeEH4+PH G8DcxHZNji70/rllIpWZwCqvUshaZB+Nz+/GQ+bZ8kJjSNDKX6HCj+Bb2SX/jHBzWG/M sFqXDMJr40982RLor2vsf4AAFC6dnV8CXe2YZNdH+crRnK/+TV+Fjj+/XK58/4lD4dEY exHA== X-Gm-Message-State: APjAAAU0oqlGwSNYlSZyVP0XEONIo1653fIoKtzw1WMIDdEVbMJaPF5w j88yuSlMEcZVuwXX+/VhggEjTJoT+xuPBCjz+Tk6BH2g8KZx3IHz/JrDm5W3cJy/MlKV+uvCBlG i8lVLFF9/PNzLNlq53tfyAIBQNYhf7w/RGdJc/wTi/9n2NHveiorIqrTPRprjTB2f2/ji+cF4Q/ QW8OH8s5r7ILHAz4LcKIzTHZ3cWSRiYvbHA+P8rn+0aZrz7agybkV+OnZi X-Google-Smtp-Source: APXvYqz5XpBw/SC4nmTeKhhZMmVs+UnYgLMKR7+MteUadHd9K0Qm3YHWRzjE/nXl4K7My2ZdbAlKklIwX7WomN8mkuY= X-Received: by 2002:a19:9149:: with SMTP id y9mr43637255lfj.15.1575276891167; Mon, 02 Dec 2019 00:54:51 -0800 (PST) MIME-Version: 1.0 From: Khushboo Vashi Date: Mon, 2 Dec 2019 14:24:42 +0530 Message-ID: Subject: [pgAdmin 4][Patch] - RM #4953 - Unable to retrieve table node if trigger is already disabled and user Click on Enable All To: pgadmin-hackers Content-Type: multipart/mixed; boundary="0000000000008596220598b4bbb7" X-CLOUD-SEC-AV-Info: edb,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 --0000000000008596220598b4bbb7 Content-Type: multipart/alternative; boundary="00000000000085961f0598b4bbb5" --00000000000085961f0598b4bbb5 Content-Type: text/plain; charset="UTF-8" Hi, Please find the attached patch to fix the RM #4953 - Unable to retrieve table node if trigger is already disabled and user Click on Enable All. Thanks, Khushboo --00000000000085961f0598b4bbb5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Please find the at= tached patch to fix the RM #4953 -=C2=A0Unable to retrieve table node if trigger = is already disabled and user Click on Enable All.

Thanks= ,
Khushboo

--00000000000085961f0598b4bbb5-- --0000000000008596220598b4bbb7 Content-Type: application/octet-stream; name="RM_4953.patch" Content-Disposition: attachment; filename="RM_4953.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_k3o74wy30 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy90cmVlL3BnYWRtaW5fdHJlZV9ub2Rl LmpzIGIvd2ViL3BnYWRtaW4vc3RhdGljL2pzL3RyZWUvcGdhZG1pbl90cmVlX25vZGUuanMKaW5k ZXggMmE3NGZkMTE1Li5mNWEzZTZlOTEgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3N0YXRpYy9q cy90cmVlL3BnYWRtaW5fdHJlZV9ub2RlLmpzCisrKyBiL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy90 cmVlL3BnYWRtaW5fdHJlZV9ub2RlLmpzCkBAIC00Myw2ICs0Myw3IEBAIGV4cG9ydCBmdW5jdGlv biBnZXRUcmVlTm9kZUhpZXJhcmNoeUZyb21FbGVtZW50KHBnQnJvd3NlciwgdHJlZU5vZGUpIHsK IGV4cG9ydCBmdW5jdGlvbiBnZXRUcmVlTm9kZUhpZXJhcmNoeUZyb21JZGVudGlmaWVyKGFjaVRy ZWVOb2RlSWRlbnRpZmllcikgewogICBsZXQgaWRlbnRpZmllciA9IHRoaXMudHJlZU1lbnUudHJh bnNsYXRlVHJlZU5vZGVJZEZyb21BQ0lUcmVlKGFjaVRyZWVOb2RlSWRlbnRpZmllcik7CiAgIGxl dCBjdXJyZW50Tm9kZSA9IHRoaXMudHJlZU1lbnUuZmluZE5vZGUoaWRlbnRpZmllcik7CisgIGlm IChjdXJyZW50Tm9kZSA9PT0gbnVsbCkgcmV0dXJuIG51bGw7CiAgIHJldHVybiBnZXRUcmVlTm9k ZUhpZXJhcmNoeS5jYWxsKHRoaXMsIGN1cnJlbnROb2RlKTsKIH0KIApkaWZmIC0tZ2l0IGEvd2Vi L3BnYWRtaW4vc3RhdGljL2pzL3RyZWUvcGdhZG1pbl90cmVlX3NhdmVfc3RhdGUuanMgYi93ZWIv cGdhZG1pbi9zdGF0aWMvanMvdHJlZS9wZ2FkbWluX3RyZWVfc2F2ZV9zdGF0ZS5qcwppbmRleCBk NDM0MDgzM2EuLjk5OTAyN2U5ZSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vc3RhdGljL2pzL3Ry ZWUvcGdhZG1pbl90cmVlX3NhdmVfc3RhdGUuanMKKysrIGIvd2ViL3BnYWRtaW4vc3RhdGljL2pz L3RyZWUvcGdhZG1pbl90cmVlX3NhdmVfc3RhdGUuanMKQEAgLTIxMSw3ICsyMTEsNyBAQCBfLmV4 dGVuZChwZ0Jyb3dzZXIuYnJvd3NlclRyZWVTdGF0ZSwgewogICAgICAgbm9kZSA9IGRhdGEgJiYg cGdCcm93c2VyLk5vZGVzW2RhdGEuX3R5cGVdLAogICAgICAgdHJlZUhpZXJhcmNoeSA9IG5vZGUg JiYgbm9kZS5nZXRUcmVlTm9kZUhpZXJhcmNoeShpdGVtKTsKIAotICAgIGlmICghcGdCcm93c2Vy LnRyZWUuaGFzUGFyZW50KGl0ZW0pIHx8ICEoc2VsZi5wYXJlbnQgaW4gdHJlZUhpZXJhcmNoeSkp CisgICAgaWYgKHRyZWVIaWVyYXJjaHkgPT09IG51bGwgfHwgIXBnQnJvd3Nlci50cmVlLmhhc1Bh cmVudChpdGVtKSB8fCAhKHNlbGYucGFyZW50IGluIHRyZWVIaWVyYXJjaHkpKQogICAgICAgcmV0 dXJuOwogCiAgICAgbGV0IHRvcFBhcmVudCA9IHRyZWVIaWVyYXJjaHkgJiYgdHJlZUhpZXJhcmNo eVtzZWxmLnBhcmVudF1bJ19pZCddLApAQCAtMjY5LDcgKzI2OSw3IEBAIF8uZXh0ZW5kKHBnQnJv d3Nlci5icm93c2VyVHJlZVN0YXRlLCB7CiAgICAgICB0cmVlSGllcmFyY2h5ID0gbm9kZSAmJiBu b2RlLmdldFRyZWVOb2RlSGllcmFyY2h5KGl0ZW0pOwogCiAKLSAgICBpZiAoIXBnQnJvd3Nlci50 cmVlLmhhc1BhcmVudChpdGVtKSB8fCAhKHNlbGYucGFyZW50IGluIHRyZWVIaWVyYXJjaHkpKQor ICAgIGlmICh0cmVlSGllcmFyY2h5ID09PSBudWxsIHx8ICFwZ0Jyb3dzZXIudHJlZS5oYXNQYXJl bnQoaXRlbSkgfHwgIShzZWxmLnBhcmVudCBpbiB0cmVlSGllcmFyY2h5KSkKICAgICAgIHJldHVy bjsKIAogICAgIC8vIElmIHRoZSBzZXJ2ZXIgbm9kZSBpcyBvcGVuIHRoZW4gb25seSB3ZSBzaG91 bGQgcG9wdWxhdGUgdGhlIHRyZWUK --0000000000008596220598b4bbb7--