Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFdDt-0008D9-5h for pgadmin-hackers@arkaria.postgresql.org; Tue, 30 May 2017 09:13:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dFdDs-00079K-K4 for pgadmin-hackers@arkaria.postgresql.org; Tue, 30 May 2017 09:13:52 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dFdDd-0006jw-Rc for pgadmin-hackers@postgresql.org; Tue, 30 May 2017 09:13:38 +0000 Received: from mail-wm0-x22e.google.com ([2a00:1450:400c:c09::22e]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dFdDa-0004z6-Fb for pgadmin-hackers@postgresql.org; Tue, 30 May 2017 09:13:36 +0000 Received: by mail-wm0-x22e.google.com with SMTP id b84so83665945wmh.0 for ; Tue, 30 May 2017 02:13:34 -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=GlZBt6ZONBNpBH6K2Y+tedxCjjXsiS+Yi+UKv9usMiA=; b=dDlsyRJW930JDHJO67o63QeyfIzXgMqV+PNFZx9qYzjGeEOjbqVOd2wU9Krz5or6xr KV/xMURf79aA8w0IBwU6GIOtVCK1jY+DCfC5lNLzqahaE4Jam3wtZgKWloX5wgX0w7l9 FTsATfWpSgtJkvbJrnIYYgtlRi3MrHGrMSQR0A1xmPwkBbMyaQ2NnMGOa2fC/VyfBoAe 4US6WY0LBi30oZj9RPltwCv/284VVHNQcR8LsfhEhFI4dQQWc7T8THatVnjRA+qEOQSU GI3MXILxryZLQBdDzbdA07MBP/zzyPDqDVN5QutBJpkwRBNFHd/EyKVj4aFofshAL5Qx QaYA== 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=GlZBt6ZONBNpBH6K2Y+tedxCjjXsiS+Yi+UKv9usMiA=; b=W4WitS6pOSQgTII6noIxawwem63NbxKIokRX8VkQaa9xu+mZHAW0SCFcj0Hg4WW7Qg kBXUMZPSfd+m1BmqircnPwNDA+iQ44G5hF0n7DDMkNp3JfIQpGl10VBcZtmgh3T/XUJ/ LmuuOGy/mjR1INVFxK8DW/amd6vdwi4OHbSC9uigKiKVEljFvHCvqmj7u86CJ8LAs+FR VA1D4csaiXzD+0ac5Ys+8z6gm/YoL9H6X2UWkW9LMi1U6n47sz8DyE6IaHpHDUWuJrzq 0QeRfpHxnvB8oXMtK4jYaemNUz7OMfj+XZT+jNlwOHQ0MQppUNc08WrdtPjvSyp1KWxi VOsw== X-Gm-Message-State: AODbwcClW7PHQ6sIDdD7tFxIzjdrwk16MwQk3MICPgHMkZI2XVgq2xvP ffLEtfJH7H0PHnTH3p7hUraJh4Wsodc3Y+g= X-Received: by 10.223.179.92 with SMTP id k28mr13150236wrd.118.1496135612034; Tue, 30 May 2017 02:13:32 -0700 (PDT) MIME-Version: 1.0 Received: by 10.223.161.199 with HTTP; Tue, 30 May 2017 02:13:11 -0700 (PDT) From: Murtuza Zabuawala Date: Tue, 30 May 2017 14:43:11 +0530 Message-ID: Subject: [pgAdmin4][Patch] To display proper SQL for Procedure node To: pgadmin-hackers Content-Type: multipart/mixed; boundary="94eb2c1b6038b12a880550ba37d1" 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 --94eb2c1b6038b12a880550ba37d1 Content-Type: multipart/alternative; boundary="94eb2c1b6038b12a830550ba37cf" --94eb2c1b6038b12a830550ba37cf Content-Type: text/plain; charset="UTF-8" Hi, PFA patch to fix to display procedure options like IMMUTABLE STRICT SECURITY DEFINER PARALLEL RESTRICTED in SQL (Reverse Engineered). RM#2280 -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --94eb2c1b6038b12a830550ba37cf Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

PFA patch to fix to display procedu= re options like=C2=A0IMMUTABLE STRICT SECURITY DEFINER PARALLEL RESTRICTED = in SQL (Reverse Engineered).
RM#2280

=
--
Regards,
Murtuza Zabuawala
EnterpriseDB= :=C2=A0http://www.enterprisedb.com=
The Enterprise PostgreSQL Company
--94eb2c1b6038b12a830550ba37cf-- --94eb2c1b6038b12a880550ba37d1 Content-Type: text/plain; charset="US-ASCII"; name="RM_2280.diff" Content-Disposition: attachment; filename="RM_2280.diff" Content-Transfer-Encoding: base64 X-Attachment-Id: f_j3bch04h0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy9fX2luaXRf Xy5weSBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2 ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy9fX2luaXRfXy5weQpp bmRleCBlMjkyMTM1Li43N2YyMWI4IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1p bi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2No ZW1hcy9mdW5jdGlvbnMvX19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4v YnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVt YXMvZnVuY3Rpb25zL19faW5pdF9fLnB5CkBAIC05MzMsNiArOTMzLDcgQEAg Y2xhc3MgRnVuY3Rpb25WaWV3KFBHQ2hpbGROb2RlVmlldywgRGF0YVR5cGVS ZWFkZXIpOgogICAgICAgICBhcmdzX3dpdGhvdXRfbmFtZSA9IFtdCiAgICAg ICAgIGNudCA9IDEKICAgICAgICAgYXJnc19saXN0ID0gW10KKyAgICAgICAg dm9sX2RpY3QgPSB7J3YnOiAnVk9MQVRJTEUnLCAncyc6ICdTVEFCTEUnLCAn aSc6ICdJTU1VVEFCTEUnfQogCiAgICAgICAgIGlmICdhcmd1bWVudHMnIGlu IHJlc3BfZGF0YSBhbmQgbGVuKHJlc3BfZGF0YVsnYXJndW1lbnRzJ10pID4g MDoKICAgICAgICAgICAgIGFyZ3NfbGlzdCA9IHJlc3BfZGF0YVsnYXJndW1l bnRzJ10KQEAgLTk2MSw2ICs5NjIsMTAgQEAgY2xhc3MgRnVuY3Rpb25WaWV3 KFBHQ2hpbGROb2RlVmlldywgRGF0YVR5cGVSZWFkZXIpOgogCiAgICAgICAg IGlmIHNlbGYubm9kZV90eXBlID09ICdwcm9jZWR1cmUnOgogICAgICAgICAg ICAgb2JqZWN0X3R5cGUgPSAncHJvY2VkdXJlJworICAgICAgICAgICAgaWYg J3Byb3ZvbGF0aWxlJyBpbiByZXNwX2RhdGE6CisgICAgICAgICAgICAgICAg cmVzcF9kYXRhWydwcm92b2xhdGlsZSddID0gdm9sX2RpY3QuZ2V0KAorICAg ICAgICAgICAgICAgICAgICByZXNwX2RhdGFbJ3Byb3ZvbGF0aWxlJ10sICcn CisgICAgICAgICAgICAgICAgKQogCiAgICAgICAgICAgICAjIEdldCBTY2hl bWEgTmFtZSBmcm9tIGl0cyBPSUQuCiAgICAgICAgICAgICBpZiAncHJvbmFt ZXNwYWNlJyBpbiByZXNwX2RhdGE6CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1p bi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2No ZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3Byb2NlZHVyZS9wcGFzL3NxbC85 LjVfcGx1cy9jcmVhdGUuc3FsIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rpb25z L3RlbXBsYXRlcy9wcm9jZWR1cmUvcHBhcy9zcWwvOS41X3BsdXMvY3JlYXRl LnNxbAppbmRleCAzMjI0OWY2Li5iMmVkNDA2IDEwMDY0NAotLS0gYS93ZWIv cGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3Byb2NlZHVyZS9wcGFz L3NxbC85LjVfcGx1cy9jcmVhdGUuc3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jy b3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFz L2Z1bmN0aW9ucy90ZW1wbGF0ZXMvcHJvY2VkdXJlL3BwYXMvc3FsLzkuNV9w bHVzL2NyZWF0ZS5zcWwKQEAgLTExLDEwICsxMSw5IEBAIENSRUFURSBPUiBS RVBMQUNFIFBST0NFRFVSRSB7eyBjb25ufHF0SWRlbnQoZGF0YS5wcm9uYW1l c3BhY2UsIGRhdGEubmFtZSkgfX17JSBpCiB7JSBpZiBub3QgbG9vcC5sYXN0 ICV9LCB7JSBlbmRpZiAlfQogeyUgZW5kZm9yIC0lfQogKXslIGVuZGlmICV9 Ci17JSBlbmRpZiAlfQoteyUgaWYgcXVlcnlfdHlwZSAhPSAnY3JlYXRlJyAl fQogCi0gICAge3sgZGF0YS5wcm92b2xhdGlsZSB9fXslIGlmIGRhdGEucHJv bGVha3Byb29mICV9IExFQUtQUk9PRiB7JSBlbmRpZiAlfQoreyUgZW5kaWYg JX0KKyAgICB7eyBkYXRhLnByb3ZvbGF0aWxlIH19IHslIGlmIGRhdGEucHJv bGVha3Byb29mICV9TEVBS1BST09GIHslIGVuZGlmICV9CiB7JSBpZiBkYXRh LnByb2lzc3RyaWN0ICV9U1RSSUNUIHslIGVuZGlmICV9CiB7JSBpZiBkYXRh LnByb3NlY2RlZiAlfVNFQ1VSSVRZIERFRklORVIgeyUgZW5kaWYgJX17JSBp ZiBkYXRhLnByb2Nvc3QgJX0KIApAQCAtMjMsNyArMjIsNyBAQCBDUkVBVEUg T1IgUkVQTEFDRSBQUk9DRURVUkUge3sgY29ubnxxdElkZW50KGRhdGEucHJv bmFtZXNwYWNlLCBkYXRhLm5hbWUpIH19eyUgaQogICAgIFJPV1Mge3tkYXRh LnByb3Jvd3N9fXslIGVuZGlmIC0lfXslIGlmIGRhdGEudmFyaWFibGVzICV9 eyUgZm9yIHYgaW4gZGF0YS52YXJpYWJsZXMgJX0KIAogICAgIFNFVCB7eyBj b25ufHF0SWRlbnQodi5uYW1lKSB9fT17eyB2LnZhbHVlfHF0TGl0ZXJhbCB9 fXslIGVuZGZvciAtJX0KLXslIGVuZGlmICV9eyUgZW5kaWYgJX0KK3slIGVu ZGlmICV9CiAKIEFTCiB7eyBkYXRhLnByb3NyYyB9fTsKZGlmZiAtLWdpdCBh L3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvcHJvY2VkdXJl L3BwYXMvc3FsLzkuNl9wbHVzL2NyZWF0ZS5zcWwgYi93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1h cy9mdW5jdGlvbnMvdGVtcGxhdGVzL3Byb2NlZHVyZS9wcGFzL3NxbC85LjZf cGx1cy9jcmVhdGUuc3FsCmluZGV4IDRlMDJhZDcuLmU4MDc1ZjUgMTAwNjQ0 Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2 ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvcHJv Y2VkdXJlL3BwYXMvc3FsLzkuNl9wbHVzL2NyZWF0ZS5zcWwKKysrIGIvd2Vi L3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJh c2VzL3NjaGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy9wcm9jZWR1cmUvcHBh cy9zcWwvOS42X3BsdXMvY3JlYXRlLnNxbApAQCAtMTEsMTggKzExLDIwIEBA IENSRUFURSBPUiBSRVBMQUNFIFBST0NFRFVSRSB7eyBjb25ufHF0SWRlbnQo ZGF0YS5wcm9uYW1lc3BhY2UsIGRhdGEubmFtZSkgfX17JSBpCiB7JSBpZiBu b3QgbG9vcC5sYXN0ICV9LCB7JSBlbmRpZiAlfQogeyUgZW5kZm9yIC0lfQog KXslIGVuZGlmICV9Ci17JSBlbmRpZiAlfQoteyUgaWYgcXVlcnlfdHlwZSAh PSAnY3JlYXRlJyAlfQogCi0gICAge3sgZGF0YS5wcm92b2xhdGlsZSB9fXsl IGlmIGRhdGEucHJvbGVha3Byb29mICV9IExFQUtQUk9PRiB7JSBlbmRpZiAl fQoreyUgZW5kaWYgJX0KKyAgICB7eyBkYXRhLnByb3ZvbGF0aWxlIH19IHsl IGlmIGRhdGEucHJvbGVha3Byb29mICV9TEVBS1BST09GIHslIGVuZGlmICV9 CiB7JSBpZiBkYXRhLnByb2lzc3RyaWN0ICV9U1RSSUNUIHslIGVuZGlmICV9 CiB7JSBpZiBkYXRhLnByb3NlY2RlZiAlfVNFQ1VSSVRZIERFRklORVIgeyUg ZW5kaWYgJX0KIHslIGlmIGRhdGEucHJvcGFyYWxsZWwgYW5kIChkYXRhLnBy b3BhcmFsbGVsID09ICdyJyBvciBkYXRhLnByb3BhcmFsbGVsID09ICdzJykg JX0KIHslIGlmIGRhdGEucHJvcGFyYWxsZWwgPT0gJ3InICV9UEFSQUxMRUwg UkVTVFJJQ1RFRHslIGVsaWYgZGF0YS5wcm9wYXJhbGxlbCA9PSAncycgJX1Q QVJBTExFTCBTQUZFeyUgZW5kaWYgJX17JSBlbmRpZiAlfXslIGlmIGRhdGEu cHJvY29zdCAlfQorCiAgICAgQ09TVCB7e2RhdGEucHJvY29zdH19eyUgZW5k aWYgJX17JSBpZiBkYXRhLnByb3Jvd3MgJX0KKwogICAgIFJPV1Mge3tkYXRh LnByb3Jvd3N9fXslIGVuZGlmIC0lfXslIGlmIGRhdGEudmFyaWFibGVzICV9 eyUgZm9yIHYgaW4gZGF0YS52YXJpYWJsZXMgJX0KKwogICAgIFNFVCB7eyBj b25ufHF0SWRlbnQodi5uYW1lKSB9fT17eyB2LnZhbHVlfHF0TGl0ZXJhbCB9 fXslIGVuZGZvciAtJX0KLXslIGVuZGlmICV9eyUgZW5kaWYgJX0KK3slIGVu ZGlmICV9CiAKIEFTCiB7eyBkYXRhLnByb3NyYyB9fTsK --94eb2c1b6038b12a880550ba37d1 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 --94eb2c1b6038b12a880550ba37d1--