Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bSO7O-0005Fk-34 for pgadmin-hackers@arkaria.postgresql.org; Wed, 27 Jul 2016 12:39:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bSO7M-0006Y9-Sd for pgadmin-hackers@arkaria.postgresql.org; Wed, 27 Jul 2016 12:39:20 +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 1bSO78-0006JV-Vd for pgadmin-hackers@postgresql.org; Wed, 27 Jul 2016 12:39:07 +0000 Received: from mail-qk0-f181.google.com ([209.85.220.181]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bSO75-0006rt-5J for pgadmin-hackers@postgresql.org; Wed, 27 Jul 2016 12:39:06 +0000 Received: by mail-qk0-f181.google.com with SMTP id x1so32473019qkb.3 for ; Wed, 27 Jul 2016 05:39:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=8s7TMO1lNsKZEDX3CepylNoQT1IjDJY+aTSb0hR4JtQ=; b=BTsV9KFfY+KJEznU1TDjrdSEv+VoxUm13Gupb6L8ios5NfD2Sj20rKONt8jBlMAKbt fUr69YBsknsaZo43yb/uLsQQS6Tlta5FE9BRBJMsmLKNwB4qJqbvAQU/sjkY56+YhRxN OFMsY07wUPuewWQuYiOkhASPbEEVgG1fx9OuF9Ma92UZLqius8fzYrnkKA0UpBi/ailF 4eRJDtzvyDwPp0VZTDvhcuS7eF/j62zhnToucSa9RTtElhtY2YNDfCbAOM2ChQ8SjHyA EWL4pIpvPF00e0908+1qbNNniBAcy+uTwvrTm90BKyriL9QLxpME5YG60YaOuCGpOxIe CTjA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=8s7TMO1lNsKZEDX3CepylNoQT1IjDJY+aTSb0hR4JtQ=; b=Cyn7e9iL5I/naEK2YeeRa/xn49qODaEmMH50OoanmmK99ff2sLXwYxdZgr8YXRrCbw 0odW/5apK85WRak8He/GYCYapsHiPgVcba1n50ADQdRLTRwNS64H9bXVt4IgAd906FqE c3s6AKisy1833X6TERmZ9qOUWSRrjc5lBJCjBjPgSLI6f+lEclu5mFRNAfoAslYAs54T DTh5u2jAMEJ2LRRoi5Xzet64hDgnteFdRo15gvScC13Gih14KwB/6l6Np9nfOj0yJqYo E8ydu8rQGDKqieF9L6k6cSFkViJFRqW9P33Y9sjNusHHADXOIW9a/MpNuDUiA6zaCNub 9JXQ== X-Gm-Message-State: AEkoouvqh35656DF66rTM+9A1SzBSfbjfu07WPtuBsKzCumg8PrS2kA0BZ4+NchhxO6Z5ZT6HtcTCI/U4XRXYsAH X-Received: by 10.55.185.131 with SMTP id j125mr34175582qkf.170.1469623081348; Wed, 27 Jul 2016 05:38:01 -0700 (PDT) MIME-Version: 1.0 Received: by 10.55.8.3 with HTTP; Wed, 27 Jul 2016 05:37:41 -0700 (PDT) In-Reply-To: References: From: Murtuza Zabuawala Date: Wed, 27 Jul 2016 18:07:41 +0530 Message-ID: Subject: Re: PATCH: Encoding issue with qtLiteral function (pgAdmin4) To: Dave Page Cc: pgadmin-hackers Content-Type: multipart/mixed; boundary=94eb2c049078b7de4e05389d496f 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 --94eb2c049078b7de4e05389d496f Content-Type: multipart/alternative; boundary=94eb2c049078b7de4805389d496d --94eb2c049078b7de4805389d496d Content-Type: text/plain; charset=UTF-8 Okay, Let me check on that. Meanwhile I'm attaching patch for making Provider optional in security labels control. Regards, Murtuza -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Wed, Jul 27, 2016 at 5:04 PM, Dave Page wrote: > Hi > > On Wed, Jul 27, 2016 at 12:18 PM, Murtuza Zabuawala > wrote: > > Hi Dave, > > > > 1) Unicode conversion was working properly for function node, It was > failing > > due to wrong sql templates. > > - I've fixed them. > > I just did a test, and it's still failing - see the attached > screenshot. Aside from the encoding issue, it looks like it's adding > extra quotes around the parameter data type - double-double quoting > the schema and type, and then quoting the whole lot again in the > CREATE part. The ALTER part looks fine. > > > 2) Type is also working fine with encoding for me(PFA screenshots), Can > you > > please provide error you got? > > Hmm, I can't reproduce that now. Weird. > > > This patch also makes Provider optional in security label control & > > templates. > > > > ------- > > Regarding enforcing to utf-8, In my opinion we can enforce everything to > > utf-8 if we use any of one python version but to make it compatible with > > both python2 and python3 version by forcing utf-8 encoding it will be > > difficult to handle its side effects. > > Urgh. Ok, thanks. > > > Python2, > > > >>>> txt_sample = 'Hello' > >>>> isinstance(txt_sample, str) > > True > >>>> isinstance(txt_sample, bytes) > > True > >>>> isinstance(txt_sample, unicode) > > False > >>>> txt_sample.encode('utf-8') > > 'Hello' > >>>> txt_sample.decode('utf-8') > > u'Hello' > > > > Forcing to unicode in Python2, > > > >>>> txt_sample = u'Hello' > >>>> isinstance(txt_sample, str) > > False > >>>> isinstance(txt_sample, bytes) > > False > >>>> isinstance(txt_sample, unicode) > > True > > > > Python3, > > > >>>> txt_sample = 'Hello' > >>>> isinstance(txt_sample, str) > > True > >>>> isinstance(txt_sample, bytes) > > False > >>>> txt_sample.encode('utf-8') > > b'Hello' > >>>> txt_sample.decode('utf-8') > > Traceback (most recent call last): > > File "", line 1, in > > AttributeError: 'str' object has no attribute 'decode' > > > > > > And also psycopg2 driver returns text as string in Python2 even if that > text > > contains unicode characters, In python3 that just works fine because > string > > is Unicode by default. > > > > > > Regards, > > Murtuza > > > > -- > > Regards, > > Murtuza Zabuawala > > EnterpriseDB: http://www.enterprisedb.com > > The Enterprise PostgreSQL Company > > > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > --94eb2c049078b7de4805389d496d Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Okay, Let me check on that.

Meanwhile I= 'm attaching patch for making Provider optional in security labels cont= rol.

Regards,
Murtuza

--
Regards,

On Wed, Jul 27, 2016 at 5:04 PM, Dave Page <= span dir=3D"ltr"><dpage@pgadmin.org> wrote:
= Hi

On Wed, Jul 27, 2016 at 12:18 PM, Murtuza Zabuawala
<murtuza.zabuawala= @enterprisedb.com> wrote:
> Hi Dave,
>
> 1) Unicode conversion was working properly for function node, It was f= ailing
> due to wrong sql templates.
> - I've fixed them.

I just did a test, and it's still failing - see the attached
screenshot. Aside from the encoding issue, it looks like it's adding
extra quotes around the parameter data type - double-double quoting
the schema and type, and then quoting the whole lot again in the
CREATE part. The ALTER part looks fine.

> 2) Type is also working fine with encoding for me(PFA screenshots), Ca= n you
> please provide error you got?

Hmm, I can't reproduce that now. Weird.

> This patch also makes Provider optional in security label control &= ;
> templates.
>
> -------
> Regarding enforcing to utf-8, In my opinion we can enforce everything = to
> utf-8 if we use any of one python version but to make it compatible wi= th
> both python2 and python3 version by forcing utf-8 encoding it will be<= br> > difficult to handle its side effects.

Urgh. Ok, thanks.

> Python2,
>
>>>> txt_sample =3D 'Hello'
>>>> isinstance(txt_sample, str)
> True
>>>> isinstance(txt_sample, bytes)
> True
>>>> isinstance(txt_sample, unicode)
> False
>>>> txt_sample.encode('utf-8')
> 'Hello'
>>>> txt_sample.decode('utf-8')
> u'Hello'
>
> Forcing to unicode in Python2,
>
>>>> txt_sample =3D u'Hello'
>>>> isinstance(txt_sample, str)
> False
>>>> isinstance(txt_sample, bytes)
> False
>>>> isinstance(txt_sample, unicode)
> True
>
> Python3,
>
>>>> txt_sample =3D 'Hello'
>>>> isinstance(txt_sample, str)
> True
>>>> isinstance(txt_sample, bytes)
> False
>>>> txt_sample.encode('utf-8')
> b'Hello'
>>>> txt_sample.decode('utf-8')
> Traceback (most recent call last):
>=C2=A0 =C2=A0File "<stdin>", line 1, in <module><= br> > AttributeError: 'str' object has no attribute 'decode'=
>
>
> And also psycopg2 driver returns text as string in Python2 even if tha= t text
> contains unicode characters, In python3 that just works fine because s= tring
> is Unicode by default.
>
>
> Regards,
> Murtuza
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--94eb2c049078b7de4805389d496d-- --94eb2c049078b7de4e05389d496f Content-Type: application/octet-stream; name="Fix_SecLabls.patch" Content-Disposition: attachment; filename="Fix_SecLabls.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_ir4vmcyu1 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMv Y29sdW1uL21hY3Jvcy9zZWN1cml0eS5tYWNyb3MgYi93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1h cy90YWJsZXMvdGVtcGxhdGVzL2NvbHVtbi9tYWNyb3Mvc2VjdXJpdHkubWFj cm9zCmluZGV4IDM5NTg3YzMuLjFiZWIyNTkgMTAwNjQ0Ci0tLSBhL3dlYi9w Z2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNl cy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvY29sdW1uL21hY3Jvcy9zZWN1 cml0eS5tYWNyb3MKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJf Z3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBs YXRlcy9jb2x1bW4vbWFjcm9zL3NlY3VyaXR5Lm1hY3JvcwpAQCAtMSw2ICsx LDYgQEAKIHslIG1hY3JvIEFQUExZKGNvbm4sIHR5cGUsIHNjaGVtYV9uYW1l LCBwYXJlbnRfb2JqZWN0LCBjaGlsZF9vYmplY3QsIHByb3ZpZGVyLCBsYWJl bCkgLSV9Ci1TRUNVUklUWSBMQUJFTCBGT1Ige3sgY29ubnxxdElkZW50KHBy b3ZpZGVyKSB9fSBPTiB7eyB0eXBlIH19IHt7IGNvbm58cXRJZGVudChzY2hl bWFfbmFtZSwgcGFyZW50X29iamVjdCwgY2hpbGRfb2JqZWN0KSB9fSBJUyB7 eyBsYWJlbHxxdExpdGVyYWwgfX07CitTRUNVUklUWSBMQUJFTHslIGlmIHBy b3ZpZGVyIGFuZCBwcm92aWRlciAhPSAnJyAlfSBGT1Ige3sgY29ubnxxdElk ZW50KHByb3ZpZGVyKSB9fXslIGVuZGlmICV9IE9OIHt7IHR5cGUgfX0ge3sg Y29ubnxxdElkZW50KHNjaGVtYV9uYW1lLCBwYXJlbnRfb2JqZWN0LCBjaGls ZF9vYmplY3QpIH19IElTIHt7IGxhYmVsfHF0TGl0ZXJhbCB9fTsKIHslLSBl bmRtYWNybyAlfQogeyUgbWFjcm8gRFJPUChjb25uLCB0eXBlLCBzY2hlbWFf bmFtZSwgcGFyZW50X29iamVjdCwgY2hpbGRfb2JqZWN0LCBwcm92aWRlcikg LSV9Ci1TRUNVUklUWSBMQUJFTCBGT1Ige3sgY29ubnxxdElkZW50KHByb3Zp ZGVyKSB9fSBPTiB7eyB0eXBlIH19IHt7IGNvbm58cXRJZGVudChzY2hlbWFf bmFtZSwgcGFyZW50X29iamVjdCwgY2hpbGRfb2JqZWN0KSB9fSBJUyBOVUxM OworU0VDVVJJVFkgTEFCRUx7JSBpZiBwcm92aWRlciBhbmQgcHJvdmlkZXIg IT0gJycgJX0gRk9SIHt7IGNvbm58cXRJZGVudChwcm92aWRlcikgfX17JSBl bmRpZiAlfSBPTiB7eyB0eXBlIH19IHt7IGNvbm58cXRJZGVudChzY2hlbWFf bmFtZSwgcGFyZW50X29iamVjdCwgY2hpbGRfb2JqZWN0KSB9fSBJUyBOVUxM OwogeyUtIGVuZG1hY3JvICV9CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1h cy90ZW1wbGF0ZXMvbWFjcm9zL2Z1bmN0aW9ucy9zZWN1cml0eS5tYWNyb3Mg Yi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9k YXRhYmFzZXMvc2NoZW1hcy90ZW1wbGF0ZXMvbWFjcm9zL2Z1bmN0aW9ucy9z ZWN1cml0eS5tYWNyb3MKaW5kZXggZGQyYTA4Ni4uNWQ5ZTJhNiAxMDA2NDQK LS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZl cnMvZGF0YWJhc2VzL3NjaGVtYXMvdGVtcGxhdGVzL21hY3Jvcy9mdW5jdGlv bnMvc2VjdXJpdHkubWFjcm9zCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIv c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RlbXBs YXRlcy9tYWNyb3MvZnVuY3Rpb25zL3NlY3VyaXR5Lm1hY3JvcwpAQCAtMiw3 ICsyLDcgQEAKIHsjIE1hY3JvcyBmb3IgU2VjdXJpdHkgTGFiZWxzIChmdW5j dGlvbnMgbW9kdWxlKSAjfQogeyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyN9CiB7JSBtYWNybyBTRVQoY29ubiwg dHlwZSwgbmFtZSwgcHJvdmlkZXIsIGxhYmVsLCBzY2hlbWEsIGZ1bmNfYXJn cykgLSV9Ci1TRUNVUklUWSBMQUJFTCBGT1Ige3sgcHJvdmlkZXIgfX0gT04g e3sgdHlwZSB9fSB7eyBjb25ufHF0SWRlbnQoc2NoZW1hLCBuYW1lKSB9fSh7 e2Z1bmNfYXJnc319KSBJUyB7eyBsYWJlbHxxdExpdGVyYWwgfX07CitTRUNV UklUWSBMQUJFTHslIGlmIHByb3ZpZGVyIGFuZCBwcm92aWRlciAhPSAnJyAl fSBGT1Ige3sgY29ubnxxdElkZW50KHByb3ZpZGVyKSB9fXslIGVuZGlmICV9 IE9OIHt7IHR5cGUgfX0ge3sgY29ubnxxdElkZW50KHNjaGVtYSwgbmFtZSkg fX0oe3tmdW5jX2FyZ3N9fSkgSVMge3sgbGFiZWx8cXRMaXRlcmFsIH19Owog eyUtIGVuZG1hY3JvICV9CiB7JSBtYWNybyBVTlNFVChjb25uLCB0eXBlLCBu YW1lLCBwcm92aWRlciwgc2NoZW1hLCBmdW5jX2FyZ3MpIC0lfQogU0VDVVJJ VFkgTEFCRUwgRk9SIHt7IHByb3ZpZGVyIH19IE9OIHt7IHR5cGUgfX0ge3sg Y29ubnxxdElkZW50KHNjaGVtYSwgbmFtZSkgfX0oe3tmdW5jX2FyZ3N9fSkg SVMgTlVMTDsKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2Vy dmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RlbXBsYXRl cy9tYWNyb3Mvc2NoZW1hcy9zZWN1cml0eS5tYWNyb3MgYi93ZWIvcGdhZG1p bi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2No ZW1hcy90ZW1wbGF0ZXMvbWFjcm9zL3NjaGVtYXMvc2VjdXJpdHkubWFjcm9z CmluZGV4IGUxMTI2YjEuLjdkNzY0YzUgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2Fk bWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9z Y2hlbWFzL3RlbXBsYXRlcy9tYWNyb3Mvc2NoZW1hcy9zZWN1cml0eS5tYWNy b3MKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3Nl cnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGVtcGxhdGVzL21hY3Jvcy9zY2hl bWFzL3NlY3VyaXR5Lm1hY3JvcwpAQCAtMiw3ICsyLDcgQEAKIHsjIE1hY3Jv cyBmb3Igc2NoZW1hIGFuZCBpdHMgY2hpbGQgbm9kZXMgICN9CiB7IyMjIyMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjfQogeyUgbWFj cm8gU0VUKGNvbm4sIHR5cGUsIG5hbWUsIHByb3ZpZGVyLCBsYWJlbCwgc2No ZW1hKSAtJX0KLVNFQ1VSSVRZIExBQkVMIEZPUiB7eyBwcm92aWRlciB9fSBP TiB7eyB0eXBlIH19IHt7IGNvbm58cXRJZGVudChzY2hlbWEsIG5hbWUpIH19 IElTIHt7IGxhYmVsfHF0TGl0ZXJhbCB9fTsKK1NFQ1VSSVRZIExBQkVMIEZP UnslIGlmIHByb3ZpZGVyIGFuZCBwcm92aWRlciAhPSAnJyAlfSBGT1Ige3sg Y29ubnxxdElkZW50KHByb3ZpZGVyKSB9fXslIGVuZGlmICV9IE9OIHt7IHR5 cGUgfX0ge3sgY29ubnxxdElkZW50KHNjaGVtYSwgbmFtZSkgfX0gSVMge3sg bGFiZWx8cXRMaXRlcmFsIH19OwogeyUtIGVuZG1hY3JvICV9CiB7JSBtYWNy byBVTlNFVChjb25uLCB0eXBlLCBuYW1lLCBwcm92aWRlciwgc2NoZW1hKSAt JX0KIFNFQ1VSSVRZIExBQkVMIEZPUiB7eyBwcm92aWRlciB9fSBPTiB7eyB0 eXBlIH19IHt7IGNvbm58cXRJZGVudChzY2hlbWEsIG5hbWUpIH19IElTIE5V TEw7CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9n cm91cHMvc2VydmVycy90ZW1wbGF0ZXMvbWFjcm9zL3NlY3VyaXR5Lm1hY3Jv cyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJz L3RlbXBsYXRlcy9tYWNyb3Mvc2VjdXJpdHkubWFjcm9zCmluZGV4IDgzZmI5 ZDIuLjQzNTBmOWEgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIv c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL3RlbXBsYXRlcy9tYWNyb3Mvc2VjdXJp dHkubWFjcm9zCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dy b3Vwcy9zZXJ2ZXJzL3RlbXBsYXRlcy9tYWNyb3Mvc2VjdXJpdHkubWFjcm9z CkBAIC0xLDUgKzEsNSBAQAogeyUgbWFjcm8gQVBQTFkoY29ubiwgdHlwZSwg bmFtZSwgcHJvdmlkZXIsIGxhYmVsKSAtJX0KLVNFQ1VSSVRZIExBQkVMIEZP UiB7eyBjb25ufHF0SWRlbnQocHJvdmlkZXIpIH19IE9OIHt7IHR5cGUgfX0g e3sgY29ubnxxdElkZW50KG5hbWUpIH19IElTIHt7IGxhYmVsfHF0TGl0ZXJh bCB9fTsKK1NFQ1VSSVRZIExBQkVMeyUgaWYgcHJvdmlkZXIgYW5kIHByb3Zp ZGVyICE9ICcnICV9IEZPUiB7eyBjb25ufHF0SWRlbnQocHJvdmlkZXIpIH19 eyUgZW5kaWYgJX0gT04ge3sgdHlwZSB9fSB7eyBjb25ufHF0SWRlbnQobmFt ZSkgfX0gSVMge3sgbGFiZWx8cXRMaXRlcmFsIH19OwogeyUtIGVuZG1hY3Jv ICV9CiB7JSBtYWNybyBEUk9QKGNvbm4sIHR5cGUsIG5hbWUsIHByb3ZpZGVy KSAtJX0KIFNFQ1VSSVRZIExBQkVMIEZPUiB7eyBjb25ufHF0SWRlbnQocHJv dmlkZXIpIH19IE9OIHt7IHR5cGUgfX0ge3sgY29ubnxxdElkZW50KG5hbWUp IH19IElTIE5VTEw7CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2Vy L3NlcnZlcl9ncm91cHMvc2VydmVycy90ZW1wbGF0ZXMvc2VydmVycy9zZXJ2 ZXJzLmpzIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3Nl cnZlcnMvdGVtcGxhdGVzL3NlcnZlcnMvc2VydmVycy5qcwppbmRleCAxYzhi ZmY4Li4wYTY0MTQzIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2Vy L3NlcnZlcl9ncm91cHMvc2VydmVycy90ZW1wbGF0ZXMvc2VydmVycy9zZXJ2 ZXJzLmpzCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL3RlbXBsYXRlcy9zZXJ2ZXJzL3NlcnZlcnMuanMKQEAgLTIz LDE0ICsyMyw2IEBAIGZ1bmN0aW9uKCQsIF8sIFMsIHBnQWRtaW4sIHBnQnJv d3NlciwgYWxlcnRpZnkpIHsKICAgICAgICAgICBlcnJtc2cgPSBudWxsOwog ICAgICAgICB0aGlzLmVycm9yTW9kZWwuY2xlYXIoKTsKIAotICAgICAgICBp ZiAoXy5pc1VuZGVmaW5lZCh0aGlzLmdldCgncHJvdmlkZXInKSkgfHwKLSAg ICAgICAgICBfLmlzTnVsbCh0aGlzLmdldCgncHJvdmlkZXInKSkgfHwKLSAg ICAgICAgICBTdHJpbmcodGhpcy5nZXQoJ3Byb3ZpZGVyJykpLnJlcGxhY2Uo L15ccyt8XHMrJC9nLCAnJykgPT0gJycpIHsKLSAgICAgICAgICAgIGVycm1z ZyA9ICd7eyBfKCdQcm92aWRlciBtdXN0IGJlIHNwZWNpZmllZC4nKSB9fSc7 Ci0gICAgICAgICAgICB0aGlzLmVycm9yTW9kZWwuc2V0KCdwcm92aWRlcics IGVycm1zZyk7Ci0gICAgICAgICAgICByZXR1cm4gZXJybXNnOwotICAgICAg ICB9Ci0KICAgICAgICAgaWYgKF8uaXNVbmRlZmluZWQodGhpcy5nZXQoJ2xh YmVsJykpIHx8CiAgICAgICAgICAgXy5pc051bGwodGhpcy5nZXQoJ2xhYmVs JykpIHx8CiAgICAgICAgICAgU3RyaW5nKHRoaXMuZ2V0KCdsYWJlbCcpKS5y ZXBsYWNlKC9eXHMrfFxzKyQvZywgJycpID09ICcnKSB7Cg== --94eb2c049078b7de4e05389d496f 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 --94eb2c049078b7de4e05389d496f--