Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dHpDi-0003Jy-EE for pgadmin-hackers@arkaria.postgresql.org; Mon, 05 Jun 2017 10:26:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dHpDg-0000Wh-Mq for pgadmin-hackers@arkaria.postgresql.org; Mon, 05 Jun 2017 10:26:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dHpDR-00006S-FT for pgadmin-hackers@postgresql.org; Mon, 05 Jun 2017 10:26:29 +0000 Received: from mail-oi0-x22d.google.com ([2607:f8b0:4003:c06::22d]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dHpDM-00035J-Rj for pgadmin-hackers@postgresql.org; Mon, 05 Jun 2017 10:26:28 +0000 Received: by mail-oi0-x22d.google.com with SMTP id s3so61860142oia.0 for ; Mon, 05 Jun 2017 03:26:24 -0700 (PDT) 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=BJOdDh/Y203/1Nbu17X6Qh1+12IfrRKjHSuMFLdJUNo=; b=hItSHOORenNrgIucu+R2pdB2fmpMXdOQ3t8yz9VLg7FjIU1xq4v8c3AJXuGTEE8cHF k8+qaIL/mOkpOwqljOzRcRnL0FfGj+Ik5UWO7W3tM+9Qg+lvXI/GiQPff0v5twIjxJUN qNOyUapuSVocDsyoIaJ8cV4U1cK+0eyELcxN4dPNukVyOmFFD3TTO0I9w+sffoiChtKS d8h/tCS4+0fqtva0Ea65rbRg0P7JXaDdUhrh0UEQb65sMUUMR8f0E+36gvY3QGDX4ID/ dehzWrErGH2hFZDOwo+hBy3SqTSAkLjKwkwNxK5iJBQs+9IoKgs5U3eCjpjOxUAHtT5i ADCw== 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=BJOdDh/Y203/1Nbu17X6Qh1+12IfrRKjHSuMFLdJUNo=; b=o6t756zvHafyL50fYH+vy03JrAsxJR5QJXJzTqnxbdKYcAr8ivv5HdOOPDu7U2FZt3 MghE30YzATbz2IN6SbbXewPA7ONUS/49YFNKpMMoBd9BekykTOgt6pLIEGTut7Zo3Z82 E/E+EwiVeTcu72ZfSVuutcvssxmiiPL/3ZGAmBTNvwMFvnL6RljTL6GFFjkHEyqNNWnb ngh97eHtAeC+PEoLZghOuT5ezzjXCa931obYEYYCAjwCFjgfVCPbggLX6yN91IkRsO2X 6Li2t4/BjYKKLg3hIfhprGDUq6WcvJgPPy7/itGnl41H5ENvfxxfJv8kzgTDLc4KzVSI IiqQ== X-Gm-Message-State: AKS2vOw5VlohtMA1kqqlAA22cbfLHVUNGvSqUnvH1WXSczczw9XUmxVl 23g0YYRFD2SJ3najvWYSiLruZkfmHDPkplY= X-Received: by 10.157.61.101 with SMTP id a92mr21464otc.168.1496658382630; Mon, 05 Jun 2017 03:26:22 -0700 (PDT) MIME-Version: 1.0 Received: by 10.74.137.212 with HTTP; Mon, 5 Jun 2017 03:26:21 -0700 (PDT) From: Khushboo Vashi Date: Mon, 5 Jun 2017 15:56:21 +0530 Message-ID: Subject: [pgAdmin4][Patch]: Fixed RM 2381 - "Create Script" for view assigns incorrect schema to trigger functions in "public" schema. To: pgadmin-hackers Content-Type: multipart/mixed; boundary="001a11c021203f61bd055133ef54" X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --001a11c021203f61bd055133ef54 Content-Type: multipart/alternative; boundary="001a11c021203f61b8055133ef52" --001a11c021203f61b8055133ef52 Content-Type: text/plain; charset="UTF-8" Hi, Please find the attached patch to fix RM 2381: "Create Script" for view assigns incorrect schema to trigger functions in "public" schema. Fixed the trigger function schema name in the view SQL tab. Thanks, Khushboo --001a11c021203f61b8055133ef52 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Please find the attached patch to f= ix RM 2381: "Create Script" for view assigns incorrect schema to = trigger functions in "public" schema.

Fi= xed the trigger function schema name in the view SQL tab.


Thanks,
Khushboo

--001a11c021203f61b8055133ef52-- --001a11c021203f61bd055133ef54 Content-Type: text/x-patch; charset="US-ASCII"; name="RM_2381.patch" Content-Disposition: attachment; filename="RM_2381.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_j3jz9ch70 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3ZpZXdzL19faW5pdF9fLnB5 IGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvdmlld3MvX19pbml0X18ucHkKaW5kZXggODM2 MDE4Yi4uMTdhN2RmNiAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nl ci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdmll d3MvX19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdmlld3MvX19p bml0X18ucHkKQEAgLTg5NiwxNSArODk2LDI2IEBAIGNsYXNzIFZpZXdOb2Rl KFBHQ2hpbGROb2RlVmlldywgVmFjdXVtU2V0dGluZ3MpOgogICAgICAgICAg ICAgICAgICAgICB0cmlnZ2VyWydvaWQnXSwgY29sdW1ucykKICAgICAgICAg ICAgIHJlc19yb3dzID0gdHJpZ2dlcl9kZWZpbml0aW9uKHJlc19yb3dzKQog Ci0gICAgICAgICAgICByZXNfcm93c1snc2NoZW1hJ10gPSByZXNfcm93c1sn bnNwbmFtZSddCi0KICAgICAgICAgICAgICMgSXQgc2hvdWxkIGJlIHJlbG5h bWUgYW5kIG5vdCB0YWJsZSwgYnV0IGluIGNyZWF0ZS5zcWwKICAgICAgICAg ICAgICMgKHdoaWNoIGlzIHJlZmVycmVkIGZyb20gbWFueSBwbGFjZXMpIHdl IGhhdmUgdXNlZAogICAgICAgICAgICAgIyBkYXRhLnRhYmxlIGFuZCBub3Qg ZGF0YS5yZWxuYW1lIHNvIGNvbXBhdGliaWxpdHkgYWRkIG5ldyBrZXkgYXMK ICAgICAgICAgICAgICMgdGFibGUgaW4gcmVzX3Jvd3MuCiAgICAgICAgICAg ICByZXNfcm93c1sndGFibGUnXSA9IHJlc19yb3dzWydyZWxuYW1lJ10KIAot ICAgICAgICAgICAgcmVzX3Jvd3NbJ3RmdW5jdGlvbiddID0gc2VsZi5xdElk ZW50KHNlbGYuY29ubiwgcmVzX3Jvd3NbJ3NjaGVtYSddLCByZXNfcm93c1sn dGZ1bmN0aW9uJ10pCisgICAgICAgICAgICAjIEdldCB0cmlnZ2VyIGZ1bmN0 aW9uIHdpdGggaXRzIHNjaGVtYSBuYW1lCisgICAgICAgICAgICBTUUwgPSBy ZW5kZXJfdGVtcGxhdGUoIi8iLmpvaW4oW3NlbGYudHJpZ2dlcl90ZW1wX3Bh dGgsCisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICdzcWwvI3swfSMvZ2V0X3RyaWdnZXJmdW5jdGlvbnMuc3FsJy5mb3Jt YXQoc2VsZi5tYW5hZ2VyLnZlcnNpb24pXSksCisgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgdGdmb2lkPXJlc19yb3dzWyd0Z2ZvaWQnXSwK KyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBzaG93X3N5c3Rl bV9vYmplY3RzPXNlbGYuYmx1ZXByaW50LnNob3dfc3lzdGVtX29iamVjdHMp CisKKyAgICAgICAgICAgIHN0YXR1cywgcmVzdWx0ID0gc2VsZi5jb25uLmV4 ZWN1dGVfZGljdChTUUwpCisgICAgICAgICAgICBpZiBub3Qgc3RhdHVzOgor ICAgICAgICAgICAgICAgIHJldHVybiBpbnRlcm5hbF9zZXJ2ZXJfZXJyb3Io ZXJyb3Jtc2c9cmVzdWx0KQorCisgICAgICAgICAgICAjIFVwZGF0ZSB0aGUg dHJpZ2dlciBmdW5jdGlvbiB3aGljaCB3ZSBoYXZlIGZldGNoZWQgd2l0aCBz Y2hlbWEgbmFtZQorICAgICAgICAgICAgaWYgJ3Jvd3MnIGluIHJlc3VsdCBh bmQgbGVuKHJlc3VsdFsncm93cyddKSA+IDAgYW5kIFwKKyAgICAgICAgICAg ICAgICAgICAgICAgICAgICAndGZ1bmN0aW9ucycgaW4gcmVzdWx0Wydyb3dz J11bMF06CisgICAgICAgICAgICAgICAgcmVzX3Jvd3NbJ3RmdW5jdGlvbidd ID0gcmVzdWx0Wydyb3dzJ11bMF1bJ3RmdW5jdGlvbnMnXQogCiAgICAgICAg ICAgICAjIEZvcm1hdCBhcmd1bWVudHMKICAgICAgICAgICAgIGlmIGxlbihy ZXNfcm93c1snY3VzdG9tX3RnYXJncyddKSA+IDE6Cg== --001a11c021203f61bd055133ef54 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers --001a11c021203f61bd055133ef54--