Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bP7dt-0000OR-MH for pgadmin-hackers@arkaria.postgresql.org; Mon, 18 Jul 2016 12:27:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bP7dt-0001ZI-1b for pgadmin-hackers@arkaria.postgresql.org; Mon, 18 Jul 2016 12:27:25 +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 1bP7dr-0001Yt-PX for pgadmin-hackers@postgresql.org; Mon, 18 Jul 2016 12:27:23 +0000 Received: from mail-yw0-x236.google.com ([2607:f8b0:4002:c05::236]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bP7dn-0005Yz-1d for pgadmin-hackers@postgresql.org; Mon, 18 Jul 2016 12:27:23 +0000 Received: by mail-yw0-x236.google.com with SMTP id l125so157643026ywb.2 for ; Mon, 18 Jul 2016 05:27:18 -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=W8UXJbONXi1hsC6AngUWpa8nLk6J7ZVP3TebOBy5Dzw=; b=EO2E1+tzhdhcdgpkHaNDOr50HBZtLPYaXFPwP+h0vrK7dX7dWUVgb4hE0qK1KBzO3+ CwPIH7haRfulaMYrwell2PfFyBOueZ0tsrINhHq0P9q3/vsmkqkQwn1ZitjJJCrs0wWk q1CAbpbRCT5AXXkRVs3aIRi5GScms2hpUmZJLyXt9b7a1nN0VAiGosBmN6WSGtIdNwZ4 Lm9tXpXvGBhAkl+53zlg1E1L2PLkGQlNOzAZwsfhjMqwCtwhNR5WPBfW05ZcM7MvsCxX uf8wb7brJO+iU8kDk3OIYGZlAI8dYOdiCDIAupazsi10Af1/Yi1kLwYoyjXpXH0m16g7 6GOw== 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=W8UXJbONXi1hsC6AngUWpa8nLk6J7ZVP3TebOBy5Dzw=; b=MHP3GRY8Dt9BK3obEfGj55nVEmEkp0EkyE0xbFvxQKC/0Ax08+3j7dN+WiWhMhYYvq zjPredixkjzt8vV1G9vT9L/ldb9tGAnEEqKNO0cWVzho9HlMtIsA4ItwKrybWo0mfcaB D7jDI98mfU/7UE9HghoQYrxZFXF48s0R2D8R8I4LpM+6iw1cuIBHlLtJSNcRCVTG+qzC CUrI2Yvjxp4/C05178INDpwUt4heJfNl84pYJYgo7XSQpUY1m6BWa2/v3sFQ2gZrItJ6 bDmjFUzOytQcEshEztukL8LoKllrbkFy/4nfCd7AB52+bMASv1yrHKniHexZUbs5rb+d qxIQ== X-Gm-Message-State: ALyK8tLgvapeWUvB0X/SqY/cTMJEJ6060AfeA8D5nNWxob/Du5xE7nYVJ29OC9ck8ZymTaqZ1mhmIgoTq11ljqbA X-Received: by 10.37.25.69 with SMTP id 66mr21997398ybz.23.1468844837176; Mon, 18 Jul 2016 05:27:17 -0700 (PDT) MIME-Version: 1.0 Received: by 10.37.57.14 with HTTP; Mon, 18 Jul 2016 05:27:16 -0700 (PDT) In-Reply-To: References: <70470862-26C1-4281-838E-F2C755E5C645@enterprisedb.com> <671D8CC8-C1D8-4CC1-BC32-431C496C4C5C@enterprisedb.com> From: Neel Patel Date: Mon, 18 Jul 2016 17:57:16 +0530 Message-ID: Subject: Re: PATCH: Fix the issue for saving query output as CSV To: Harshal Dhumal Cc: Dave Page , Akshay Joshi , Murtuza Zabuawala , pgadmin-hackers Content-Type: multipart/mixed; boundary=001a113ecea0c0d75c0537e8160b 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 --001a113ecea0c0d75c0537e8160b Content-Type: multipart/alternative; boundary=001a113ecea0c0d7560537e81609 --001a113ecea0c0d7560537e81609 Content-Type: text/plain; charset=UTF-8 Hi, Please find attached patch file to support server side download in runtime application. NOTE: Before applying this patch, use above harshal's patch. Thanks, Neel Patel On Mon, Jul 18, 2016 at 5:31 PM, Harshal Dhumal < harshal.dhumal@enterprisedb.com> wrote: > Hi, > > PFA rebased patch RM1405 (version 4) > > Neel will be sending patch for QT issue for same functionality. > > -- > *Harshal Dhumal* > *Software Engineer* > > EnterpriseDB India: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > On Mon, Jul 18, 2016 at 4:02 PM, Dave Page wrote: > >> Perfect, thanks! >> >> On Mon, Jul 18, 2016 at 11:24 AM, Neel Patel > > wrote: >> >>> Yes. I am just testing with different OS. I will send it next 1-2 hour. >>> >>> Is it fine ? >>> >>> Thanks, >>> Neel Patel >>> >>> On Mon, Jul 18, 2016 at 3:53 PM, Dave Page wrote: >>> >>>> Any chance of getting that in the next couple of hours so I can get it >>>> into beta 3? >>>> >>>> On Mon, Jul 18, 2016 at 11:18 AM, Dave Page wrote: >>>> >>>>> Thanks! >>>>> >>>>> On Mon, Jul 18, 2016 at 10:42 AM, Neel Patel < >>>>> neel.patel@enterprisedb.com> wrote: >>>>> >>>>>> Hi Dave, >>>>>> >>>>>> Yes, it will break in runtime. If we need to support downloading at >>>>>> server side then we need to change the runtime code. >>>>>> I will send the patch for runtime to support server side download CSV >>>>>> file. >>>>>> >>>>>> Thanks, >>>>>> Neel Patel >>>>>> >>>>>> On Fri, Jul 15, 2016 at 3:05 PM, Dave Page wrote: >>>>>> >>>>>>> Hi >>>>>>> >>>>>>> This seems to break downloads in the runtime. It works in Safari and >>>>>>> Chrome, but in the runtime the suggested filename is >>>>>>> "6980287?query=SELECT+*+FROM+pem.probe_column%0AORDER+BY+id%0AASC+&filename=probe_column.csv", >>>>>>> and after changing that and hitting OK, the "Downloading file" dialogue is >>>>>>> shown indefinitely. >>>>>>> >>>>>>> On Wed, Jul 13, 2016 at 1:16 PM, Harshal Dhumal < >>>>>>> harshal.dhumal@enterprisedb.com> wrote: >>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> PFA rebased patch for RM1405 >>>>>>>> >>>>>>>> -- >>>>>>>> *Harshal Dhumal* >>>>>>>> *Software Engineer* >>>>>>>> >>>>>>>> EnterpriseDB India: http://www.enterprisedb.com >>>>>>>> The Enterprise PostgreSQL Company >>>>>>>> >>>>>>>> On Wed, Jul 13, 2016 at 5:15 PM, Harshal Dhumal < >>>>>>>> harshal.dhumal@enterprisedb.com> wrote: >>>>>>>> >>>>>>>>> Yes sure >>>>>>>>> >>>>>>>>> -- >>>>>>>>> *Harshal Dhumal* >>>>>>>>> *Software Engineer* >>>>>>>>> >>>>>>>>> EnterpriseDB India: http://www.enterprisedb.com >>>>>>>>> The Enterprise PostgreSQL Company >>>>>>>>> >>>>>>>>> On Wed, Jul 13, 2016 at 5:10 PM, Dave Page >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Hi >>>>>>>>>> >>>>>>>>>> Can you rebase this please? >>>>>>>>>> >>>>>>>>>> Thanks. >>>>>>>>>> >>>>>>>>>> On Mon, Jul 11, 2016 at 9:16 AM, Harshal Dhumal < >>>>>>>>>> harshal.dhumal@enterprisedb.com> wrote: >>>>>>>>>> >>>>>>>>>>> Hi, >>>>>>>>>>> >>>>>>>>>>> PFA patch for RM1405. Also to allow download in runtime we will >>>>>>>>>>> still need patch >>>>>>>>>>> >>>>>>>>>>> sent by Neel. >>>>>>>>>>> >>>>>>>>>>> Changes: To download query result to CSV directly from server >>>>>>>>>>> and not to use download attr. of anchor tag () as it's not support by >>>>>>>>>>> all of major browsers (e.g. Safari). >>>>>>>>>>> Also it's not feasible to load data in html to download if >>>>>>>>>>> result set of query is very huge (in GBs). >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> *Harshal Dhumal* >>>>>>>>>>> *Software Engineer* >>>>>>>>>>> >>>>>>>>>>> EnterpriseDB India: http://www.enterprisedb.com >>>>>>>>>>> The Enterprise PostgreSQL Company >>>>>>>>>>> >>>>>>>>>>> On Wed, Jun 29, 2016 at 4:53 PM, Akshay Joshi < >>>>>>>>>>> akshay.joshi@enterprisedb.com> wrote: >>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Wed, Jun 29, 2016 at 3:52 PM, Murtuza Zabuawala >>>>>>>>>>> zabuawala@enterprisedb.com> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Yes, It will not work in runtime as well but I think Neel is >>>>>>>>>>>>> working for fix in run time for this issue, We might able to fix it in run >>>>>>>>>>>>> time but issue persists in Safari unless they add support in browser itself. >>>>>>>>>>>>> >>>>>>>>>>>>> https://webkit.org/status/#feature-download-attribute >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> > On 29-Jun-2016, at 3:40 pm, Dave Page >>>>>>>>>>>>> wrote: >>>>>>>>>>>>> > >>>>>>>>>>>>> > On Tue, Jun 28, 2016 at 10:33 AM, Murtuza Zabuawala >>>>>>>>>>>>> > wrote: >>>>>>>>>>>>> >> Yes Dave, I agree that downloading files has been supported >>>>>>>>>>>>> in browsers since long . >>>>>>>>>>>>> >> >>>>>>>>>>>>> >> But in general we send request & then receives files from >>>>>>>>>>>>> web server but in our case we are fetching our data from Backbone models & >>>>>>>>>>>>> then converting it to CSV format for downloading as a file at client side >>>>>>>>>>>>> in browser itself. >>>>>>>>>>>>> > >>>>>>>>>>>>> > If Safari doesn't support client-side saving of files, then >>>>>>>>>>>>> I have to >>>>>>>>>>>>> > wonder if our runtime will either - both are webkit based. >>>>>>>>>>>>> > >>>>>>>>>>>>> > So I guess the next question to ask is; why don't we just >>>>>>>>>>>>> generate the >>>>>>>>>>>>> > CSV on the server side? >>>>>>>>>>>>> > >>>>>>>>>>>>> >>>>>>>>>>>>> @Akshay, >>>>>>>>>>>>> Can you please suggest on above? >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> As we already have complete data in backgrid's full >>>>>>>>>>>> collection, so I have used it instead of fetching it again. >>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> > -- >>>>>>>>>>>>> > Dave Page >>>>>>>>>>>>> > Blog: http://pgsnake.blogspot.com >>>>>>>>>>>>> > Twitter: @pgsnake >>>>>>>>>>>>> > >>>>>>>>>>>>> > EnterpriseDB UK: http://www.enterprisedb.com >>>>>>>>>>>>> > The Enterprise PostgreSQL Company >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> Sent via pgadmin-hackers mailing list ( >>>>>>>>>>>>> pgadmin-hackers@postgresql.org) >>>>>>>>>>>>> To make changes to your subscription: >>>>>>>>>>>>> http://www.postgresql.org/mailpref/pgadmin-hackers >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> *Akshay Joshi* >>>>>>>>>>>> *Principal Software Engineer * >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> *Phone: +91 20-3058-9517 <%2B91%2020-3058-9517>Mobile: +91 >>>>>>>>>>>> 976-788-8246* >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Dave Page >>>>>>>>>> Blog: http://pgsnake.blogspot.com >>>>>>>>>> Twitter: @pgsnake >>>>>>>>>> >>>>>>>>>> EnterpriseDB UK: 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 >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Dave Page >>>>> Blog: http://pgsnake.blogspot.com >>>>> Twitter: @pgsnake >>>>> >>>>> EnterpriseDB UK: 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 >>>> >>> >>> >> >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> > > --001a113ecea0c0d7560537e81609 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

Please find attached patch file to = support server side download in runtime application.

NOTE: Before applying this patch, use above harshal's patch.

Thanks,
Neel Patel

On Mon, Jul 18, 2016 at 5:31 PM, H= arshal Dhumal <harshal.dhumal@enterprisedb.com> wrote:
Hi,
PFA rebased patch RM1405 (version 4)

Neel wil= l be sending patch for QT issue for same functionality.

--=C2=A0
Harshal Dhumal
Software En= gineer

EnterpriseDB India:=C2=A0http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Jul 18= , 2016 at 4:02 PM, Dave Page <dpage@pgadmin.org> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex">
Perfect, thanks!
<= div>

On Mon, Jul 1= 8, 2016 at 11:24 AM, Neel Patel <neel.patel@enterprisedb.com= > wrote:
Yes. = I am just testing with different OS. I will send it next 1-2 hour.=C2=A0
Is it fine ?

Thanks,
Neel Pat= el

On Mon, Jul 18, 2016 at 3:53 PM, Dave Page &= lt;dpage@pgadmin.org= > wrote:
A= ny chance of getting that in the next couple of hours so I can get it into = beta 3?

On Mon, Jul 18, 2016 at 11:18 AM, Dave Page <dpage@pgadmin.org&g= t; wrote:
Thanks!=

O= n Mon, Jul 18, 2016 at 10:42 AM, Neel Patel <neel.patel@enterp= risedb.com> wrote:
Hi Dave,

Yes, it will break in runtime. If we n= eed to support downloading at server side then we need to change the runtim= e code.
I will send the patch for runtime to support server side = download CSV file.

Thanks,
Neel Patel

On Fri, Jul 15, 2016 at 3:05 PM, Dave Page <dpage@pgadmin.org> wrote:
Hi

=
This seems to break downloads in the runtime. It works in Safari= and Chrome, but in the runtime the suggested filename is "6980287?que= ry=3DSELECT+*+FROM+pem.probe_column%0AORDER+BY+id%0AASC+&filename=3Dpro= be_column.csv", and after changing that and hitting OK, the "Down= loading file" dialogue is shown indefinitely.

On Wed, Jul 13, 2016= at 1:16 PM, Harshal Dhumal <harshal.dhumal@enterprisedb.com= > wrote:
<= div>Hi,

PFA rebased patch for RM1405

--=C2=A0
Harshal Dhumal
Software Engineer

EnterpriseDB India:=C2=A0http://www= .enterprisedb.com
= The Enterprise Post= greSQL Company

On Wed, Jul 13, 2016 at 5:1= 5 PM, Harshal Dhumal <harshal.dhumal@enterprisedb.com>= ; wrote:
Yes sure=

--=C2=A0
Harshal Dhumal
Software Eng= ineer

EnterpriseDB India:=C2=A0http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jul 13, 2016 at 5:1= 0 PM, Dave Page <dpage@pgadmin.org> wrote:
Hi

Can you rebase this= please?

Thanks.

On Mon, Jul 11, 2016 at 9:1= 6 AM, Harshal Dhumal <harshal.dhumal@enterprisedb.com>= ; wrote:
Hi,

PFA patch for RM1405. Also to allow download in runtime = we will still need patch sent by Neel.

Changes: To download = query result to CSV directly from server and not to use download attr. of a= nchor tag (<a>) as it's not support by all of major browsers (e.g= . Safari).
Also it's not feasible to load data in html to download i= f result set of query is very huge (in GBs).<= br>




--= =C2=A0
Harshal Dhumal
Software Engineer

EnterpriseDB India:=C2=A0http://www.enterprisedb.com
The Ente= rprise PostgreSQL Company

On Wed, Jun 29, 2016 at 4:53 PM, Akshay Josh= i <akshay.joshi@enterprisedb.com> wrote:

=
On Wed, Jun 29, 2016 at 3:52 PM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wro= te:
Yes, It will not work in runtime as w= ell but I think Neel is working for fix in run time for this issue, We migh= t able to fix it in run time but issue persists in Safari unless they add s= upport in browser itself.

https://webkit.org/status/#feature-download-att= ribute


> On 29-Jun-2016, at 3:40 pm, Dave Page <dpage@pgadmin.org> wrote:
>
> On Tue, Jun 28, 2016 at 10:33 AM, Murtuza Zabuawala
> <murtuza.zabuawala@enterprisedb.com> wrote:
>> Yes Dave, I agree that downloading files has been supported in bro= wsers since long .
>>
>> But in general we send request & then receives files from web = server but in our case we are fetching our data from Backbone models & = then converting it to CSV format for downloading as a file at client side i= n browser itself.
>
> If Safari doesn't support client-side saving of files, then I have= to
> wonder if our runtime will either - both are webkit based.
>
> So I guess the next question to ask is; why don't we just generate= the
> CSV on the server side?
>

@Akshay,
Can you please suggest on above?

=C2=A0 =C2=A0As we already have complete data in backgrid's full collection, so I have used it instead of fetching it again. =C2=A0 = =C2=A0

> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company



--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers=


--
Akshay Joshi
Principal Software Enginee= r=C2=A0

=

+91 20-3058-9517
Mobile: +91 976-788-8246




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

EnterpriseDB UK: 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




--
=
Dave Page
Blog: http://pgsnake.blogspot.comTwitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterpris= e PostgreSQL Company



--
=
Dave Page
Blog: http://pgsnake.blogspot.comTwitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterpris= e PostgreSQL Company




--
=
Dave Page
Blog: http://pgsnake.blogspot.comTwitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterpris= e PostgreSQL Company


--001a113ecea0c0d7560537e81609-- --001a113ecea0c0d75c0537e8160b Content-Type: application/octet-stream; name="runtime_server_download.patch" Content-Disposition: attachment; filename="runtime_server_download.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_iqs09j6u1 ZGlmZiAtLWdpdCBhL3J1bnRpbWUvQnJvd3NlcldpbmRvdy5jcHAgYi9ydW50 aW1lL0Jyb3dzZXJXaW5kb3cuY3BwCmluZGV4IDZiOTYyYmQuLmQ1OGEwOTQg MTAwNjQ0Ci0tLSBhL3J1bnRpbWUvQnJvd3NlcldpbmRvdy5jcHAKKysrIGIv cnVudGltZS9Ccm93c2VyV2luZG93LmNwcApAQCAtMzUzLDggKzM1Myw5IEBA IHZvaWQgQnJvd3NlcldpbmRvdzo6ZG93bmxvYWRGaWxlUHJvZ3Jlc3MocWlu dDY0IHJlYWREYXRhLCBxaW50NjQgdG90YWxEYXRhKQogICAgICAgICBtX2Zp bGUtPndyaXRlKHJlcGx5LT5yZWFkKHJlYWREYXRhKSk7CiAgICAgICAgIG1f cHJvZ3Jlc3NEaWFsb2ctPnNldFZhbHVlKHJlYWREYXRhKTsKIAotICAgICAg ICAvLyBBcyByZWFkIGRhdGEgYW5kIHRvdGFsRGF0YSBkaWZmZXJlbmNlIGlz IHplcm8gbWVhbnMgZG93bmxvYWRpbmcgaXMgZmluaXNoZWQKLSAgICAgICAg aWYgKCh0b3RhbERhdGEgLSByZWFkRGF0YSkgPT0gMCkKKyAgICAgICAgLy8g QXMgcmVhZCBkYXRhIGFuZCB0b3RhbERhdGEgZGlmZmVyZW5jZSBpcyB6ZXJv IG1lYW5zIGRvd25sb2FkaW5nIGlzIGZpbmlzaGVkLgorICAgICAgICBpZiAo KHRvdGFsRGF0YSAtIHJlYWREYXRhKSA9PSAwIHx8CisgICAgICAgICAgICAo cmVhZERhdGEgIT0gMCAmJiB0b3RhbERhdGEgPT0gLTEpKQogICAgICAgICB7 CiAgICAgICAgICAgICAvLyBBcyBkb3dubG9hZGluZyBpcyBmaW5pc2hlZCBz byByZW1vdmUgcHJvZ3Jlc3MgYmFyIGRpYWxvZwogICAgICAgICAgICAgaWYg KG1fcHJvZ3Jlc3NEaWFsb2cpCkBAIC00MzgsNiArNDM5LDExIEBAIHZvaWQg QnJvd3NlcldpbmRvdzo6ZG93bmxvYWRGaW5pc2hlZCgpCiAvLyBCZWxvdyBz bG90IHdpbGwgYmUgY2FsbGVkIHdoZW4gdXNlciBkaXJlY3RseSBjbGljayBv biBhbnkgZG93bmxvYWQgbGluawogdm9pZCBCcm93c2VyV2luZG93Ojp1bnN1 cHBvcnRlZENvbnRlbnQoUU5ldHdvcmtSZXBseSAqIHJlcGx5KQogeworICAg IC8vIEV4dHJhY3QgZmlsZW5hbWUgYW5kIHF1ZXJ5IGZyb20gZW5jb2RlZCBV UkwKKyAgICBRVXJsUXVlcnkgcXVlcnlfZGF0YShyZXBseS0+dXJsKCkpOwor ICAgIFFTdHJpbmcgZmlsZV9uYW1lID0gcXVlcnlfZGF0YS5xdWVyeUl0ZW1W YWx1ZSgiZmlsZW5hbWUiKTsKKyAgICBRU3RyaW5nIHF1ZXJ5ID0gcXVlcnlf ZGF0YS5xdWVyeUl0ZW1WYWx1ZSgicXVlcnkiKTsKKwogICAgIGlmIChtX2Rv d25sb2FkU3RhcnRlZCkKICAgICB7CiAgICAgICAgIC8vIEluZm9ybSB1c2Vy IHRoYXQgZG93bmxvYWQgaXMgYWxyZWFkeSBzdGFydGVkCkBAIC00NDUsNyAr NDUxLDEyIEBAIHZvaWQgQnJvd3NlcldpbmRvdzo6dW5zdXBwb3J0ZWRDb250 ZW50KFFOZXR3b3JrUmVwbHkgKiByZXBseSkKICAgICAgICAgcmV0dXJuOwog ICAgIH0KIAotICAgIG1fZGVmYXVsdEZpbGVuYW1lID0gUUZpbGVJbmZvKHJl cGx5LT51cmwoKS50b1N0cmluZygpKS5maWxlTmFtZSgpOworICAgIC8vIElm IGVuY29kZWQgVVJMIGNvbnRhaW5zICdmaWxlbmFtZScgYXR0cmlidXRlIHRo ZW4gdXNlIHRoYXQgZmlsZW5hbWUgaW4gZmlsZSBkaWFsb2cuCisgICAgaWYg KGZpbGVfbmFtZS5pc0VtcHR5KCkgJiYgcXVlcnkuaXNFbXB0eSgpKQorICAg ICAgICBtX2RlZmF1bHRGaWxlbmFtZSA9IFFGaWxlSW5mbyhyZXBseS0+dXJs KCkudG9TdHJpbmcoKSkuZmlsZU5hbWUoKTsKKyAgICBlbHNlCisgICAgICAg IG1fZGVmYXVsdEZpbGVuYW1lID0gZmlsZV9uYW1lOworCiAgICAgUUZpbGVE aWFsb2cgc2F2ZV9kaWFsb2codGhpcyk7CiAgICAgc2F2ZV9kaWFsb2cuc2V0 QWNjZXB0TW9kZShRRmlsZURpYWxvZzo6QWNjZXB0U2F2ZSk7CiAgICAgc2F2 ZV9kaWFsb2cuc2V0V2luZG93VGl0bGUodHIoIlNhdmUgZmlsZSIpKTsK --001a113ecea0c0d75c0537e8160b 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 --001a113ecea0c0d75c0537e8160b--