Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b2bDI-0006gE-9c for pgadmin-hackers@arkaria.postgresql.org; Tue, 17 May 2016 09:22:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b2bDH-0006gz-Se for pgadmin-hackers@arkaria.postgresql.org; Tue, 17 May 2016 09:22:51 +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 1b2bD3-0006Bz-Hq for pgadmin-hackers@postgresql.org; Tue, 17 May 2016 09:22:37 +0000 Received: from mail-qg0-x232.google.com ([2607:f8b0:400d:c04::232]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1b2bD0-0008Ri-8y for pgadmin-hackers@postgresql.org; Tue, 17 May 2016 09:22:36 +0000 Received: by mail-qg0-x232.google.com with SMTP id 90so4707129qgz.1 for ; Tue, 17 May 2016 02:22:34 -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=b6zXw3suFbjDe2jOMq2O5iXdCMc15uSxVGIUaCIaSTY=; b=ZVF3ZHwN6zli2pq9wVLCE3Qm1Td3GjGkcpBwBBzv5f7PAsFivX+ENQ3RhrUYOtpkqJ Lu5G/dnMzDwT1gRy6LMZkggnGZVcs7mC83O2KBYhFXIyWac8PwFOI8mZCRe4givBQseW avzAbUskVO8hVs4sp1mjDcIa0OefM5Jp6jVe9yk9sp6cOVh2mv3bjpQVK+Ln7WLnDNMm tAd/HE6FK3GT307Kg1B2GHQxR6/HgUXaWF/3JqXVVxy4jThqFOcMsHEqZioCa2EqQssp lEGVS4KPdCX2Kqcxs9CqVAMkHVMFo5ZUKPSqafkPVagc07/IVgjUc8yqVQLhKwc4GStg 3xKw== 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=b6zXw3suFbjDe2jOMq2O5iXdCMc15uSxVGIUaCIaSTY=; b=mSRWjvWQublWH+v3gyC2CpoJ05kOkf+pYdsdZncJbtVTpLo/15PxfqHb4PlDSbPcj/ /k37nR404LlO43O7wDssXzM/taOjhE7eqercId8r8Blr7E6yDO3QLlSomFUo+5Ai0mq9 mKtAU4WRsE982y+EkcnaY3Q6TvK4n2CJ/cPiQ59Ongsc2JeUrkJDR939DBq1MA7rbo6V hc5Ni8mCwpRq+SGGhcLZnkYmzlEihJ9gpVL4rtBaogmj4EztBZ6k1LZzLpYRsMtRbKXT 1ovHDQktst2CI/fWR9xvh2LLpK2epjdWlUbUSXeZTSFJXkfnfKuT51CQKIm73ULL4WEI ORRg== X-Gm-Message-State: AOPr4FUC4R/NE+/Q29qTLhbAaNbwMhnAiITqV1lIriuwZqBkhEyyWIW4zNTq0Ydkhubr1bACOXEGmVKyNVRtIgfh X-Received: by 10.140.25.193 with SMTP id 59mr159028qgt.77.1463476953239; Tue, 17 May 2016 02:22:33 -0700 (PDT) MIME-Version: 1.0 Received: by 10.55.207.202 with HTTP; Tue, 17 May 2016 02:22:13 -0700 (PDT) In-Reply-To: References: From: Murtuza Zabuawala Date: Tue, 17 May 2016 14:52:13 +0530 Message-ID: Subject: Re: [PATCH] Tables node (pgAdmin4) To: Surinder Kumar Cc: Harshal Dhumal , pgadmin-hackers Content-Type: multipart/mixed; boundary=001a11c11d84f0a64105330647cb 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 --001a11c11d84f0a64105330647cb Content-Type: multipart/alternative; boundary=001a11c11d84f0a63a05330647c9 --001a11c11d84f0a63a05330647c9 Content-Type: text/plain; charset=UTF-8 Hi, PFA add-on patch to Ver.6 patch, Which will add CREATE/SELECT etc Script support into table node. Regards, Murtuza -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Tue, May 17, 2016 at 11:48 AM, Surinder Kumar < surinder.kumar@enterprisedb.com> wrote: > Hi, > > Please find attached add-on patch for table's subnode rule. > Apply this patch at end after applying previous patches in email thread. > > *Issue fixed*: "Do Instead" on Rule node under View/M-View node not > working in properties mode. Unable to generate proper SQL. > > On Mon, May 16, 2016 at 7:02 PM, Harshal Dhumal < > harshal.dhumal@enterprisedb.com> wrote: > >> Hi, >> >> PFA add-on patch for table and it's child node. (please apply this patch >> on version 6 patch) >> >> Murtuza and I fixed following issues: >> >> 1. SQL formatting >> 2. Vacuum grid should not be editable in properties mode. >> 3. Column datatype does not get displayed in the properties and edit mode. >> 4. Do not allow to add another primary key if one already exist. >> >> And another minor enhancements. >> >> >> -- >> *Harshal Dhumal* >> *Software Engineer * >> >> >> >> EenterpriseDB >> >> On Sat, May 14, 2016 at 2:03 AM, Harshal Dhumal < >> harshal.dhumal@enterprisedb.com> wrote: >> >>> >>> Hi, >>> >>> >>> PFA updated patches (version: 6) for table and it's child nodes. >>> >>> -- >>> *Harshal Dhumal* >>> *Software Engineer * >>> >>> >>> >>> EenterpriseDB >>> >>> On Fri, May 13, 2016 at 6:55 PM, Khushboo Vashi < >>> khushboo.vashi@enterprisedb.com> wrote: >>> >>>> Hi, >>>> >>>> Review Comments: >>>> >>>> - Please replace 'can not' with 'cannot' in all the validation >>>> messages. >>>> - PG 9.1+ Inheritance issue as below: >>>> >>>> CREATE TABLE public.table1 >>>> ( >>>> ) >>>> ( >>>> ) >>>> INHERITS (a) >>>> WITH ( >>>> OIDS = FALSE >>>> ) >>>> TABLESPACE pg_default; >>>> ALTER TABLE public.table1 >>>> OWNER to postgres; >>>> >>>> >>>> brackets are coming twice. >>>> >>> Fixed >>> >>> >>>> >>>> - Please maintain one line spacing between SQL queries In the SQL Tab. >>>> >>> TODO >>> >>> >>>> - Foreign Key Grid in Table css issue: Grid columns expands on the >>>> selection of the cell >>>> >>> Fixed >>> >>> >>>> - Check Constraint: Validated? option should be True by default >>>> >>> Not sure about this. I cross checked in pgadmin3. >>> >>> >>> >>>> - pg 9.4: Exclude constraint does not render in SQL tab >>>> >>> Fixed >>> >>> >>>> - Missing Security validation >>>> >>> Fixed >>> >>> >>>> - Vacuum grid should not be editable in properties mode. >>>> >>> TODO (It's editable but one cannot save it on server from here as there >>> is no save button.) >>> >>> >>>> - Edit mode, Fill Factor can be allowed to be null. >>>> >>> TODO (This is generic issue in Integer and Numeric controls. This issue >>> is covered in this partial patch >>> >>> ) >>> >>> >>>> - While dropping inheritance, related table columns drop SQL are also >>>> populated in the SQL Tab >>>> >>>> ALTER TABLE public."Tbl" >>>> NO INHERIT b; >>>> ALTER TABLE public."Tbl" DROP COLUMN id; >>>> ALTER TABLE public."Tbl" DROP COLUMN name; >>>> >>>> >>> Fixed >>> >>> >>> >>>> >>>> And also render error while clicking on the save button. >>>> >>>> ERROR: syntax error at or near "[" >>>> LINE 2: INHERIT [; >>>> >>>> ^ >>>> >>>> Fixed >>> >>> >>>> - in a Reverse Engineering SQL tab, schema_name.tablename should be >>>> there, currently only table_name displays. >>>> >>> Fixed >>> >>> >>> >>>> - Column SQL is showing below text with HTML >>>> >>>> >>>> -- Column: id -- ALTER TABLE public.a DROIP >>>> COLUMN id; ALTER TABLE public.a ADD COLUMN id integer; >>>> >>>> >>> I was not able to reproduce exact issue but still I have fixed other >>> issue which I found related to column SQL. Hopefully that will fix this >>> issue as well. >>> >>> >>>> - The column datatype dependency does not get cleared upon selection of >>>> another datatype. >>>> >>> For example, if I select numeric and gives the length and precision. >>>> After that I change the dat-type then, dependent fields should be get >>>> cleared. >>>> >>> Fixed. >>> >>> >>>> >>>> - The column datatype does not get displayed in the properties and edit >>>> mode if the length and precision are given while creating a column. >>>> >>> >>> TODO ( I cannot fix this blindly as this might introduce another >>> issue(s) in column node. I will need Murtuza's help as he has worked on >>> column node) >>> >>> >>>> >>>> - Statistics is showing null value even after having value. >>>> >>> Fixed >>> >>> >>>> >>>> - if the check constraints are not validated then put proper icon in >>>> tree and also it should be validated in edit mode. >>>> >>> Not reproducible. >>> >>> >>>> >>>> NOTE: I have not checked the Indexes, Triggers and Rules nodes as I do >>>> not have much knowledge about it. >>>> >>>> >>> >>> >>>> Thanks, >>>> Khushboo >>>> >>>> On Fri, May 13, 2016 at 5:24 PM, Harshal Dhumal < >>>> harshal.dhumal@enterprisedb.com> wrote: >>>> >>>>> Hi >>>>> >>>>> PFA attached patches for table and it's child nodes with python 2.7 >>>>> compatibility. >>>>> >>>>> >>> >> >> >> -- >> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgadmin-hackers >> >> > > > -- > Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-hackers > > --001a11c11d84f0a63a05330647c9 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

PFA add-on patch to Ver.6 patch, = =C2=A0Which will add CREATE/SELECT etc Script support into table node.=C2= =A0

Regards,
Murtuza

--
Regards,
= Murtuza Zabuawala
EnterpriseDB:=C2=A0http://www.enterprisedb.com
The Enterprise PostgreSQL Compa= ny

On Tue, May 17, 2016 at 11:48 AM, Surinder K= umar <surinder.kumar@enterprisedb.com> wrote:<= br>
Hi,

P= lease find attached add-on patch for table's subnode rule.
Ap= ply this patch at end after applying previous patches in email thread.

Issue fixed:=C2=A0"Do Instead" on Rule node under View/M-View node not working in= properties mode. Unable to generate proper SQL.

On Mon, May 16, 2016 = at 7:02 PM, Harshal Dhumal <harshal.dhumal@enterprisedb.com<= /a>> wrote:
Hi,

PFA add-on patch for table and it's child node. (please a= pply this patch on version 6 patch)

Murtuza and I fixed= following issues:

1. SQL formatting
2. Vacuum grid should no= t be editable in properties mode.
3. Column datatype does not get displa= yed in the properties and edit mode.
4. Do not allow to add another primary key if one already exist.=

And another minor enh= ancements.
<= br>


On Sat, May 14, 2016 at 2:03 = AM, Harshal Dhumal <harshal.dhumal@enterprisedb.com><= /span> wrote:
<= div dir=3D"ltr">
Hi,


PFA updated patch= es (version: 6) for table and it's child nodes.

--=C2=A0
= Harshal Dhumal
Software Engineer=C2=A0



On Fri, May 13, 2016 at = 6:55 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com= > wrote:
Hi,

Review Comments:

- Please replace 'can not' with 'cannot&#= 39; =C2=A0in all the validation messages.
- PG 9.1+ Inheritance i= ssue as below:
CREATE TABLE public.table1
=
(
)
<= /div>
(
)
=C2=A0 =C2=A0 INHERITS (a)
WITH (
=C2=A0 =C2=A0 OIDS =3D FALSE
)
TABLESPACE pg= _default;
ALTER TABLE public.table1<= /div>
=C2=A0 =C2=A0 OWNER to postgres;

brackets are coming twi= ce.
Fixed
=C2= =A0

- Please maintain one line spacing between SQL qu= eries In the SQL Tab.
TODO
=C2=A0
- Foreign Key Grid in Table css issue: Grid col= umns expands on the selection of the cell
Fixed
=C2=A0
- Check Constraint: Va= lidated? option should be True by default
Not sure about this. I cross checked in pgadmin3.
<= div>
=C2=A0
- pg 9.4: Exclude constraint does not render in SQL t= ab
Fixed
=C2=A0
<= div>- Missing Security validation
Fixed<= br>
=C2=A0
- Vacuum grid should not be editable in p= roperties mode.
TODO (It's ed= itable but one cannot save it on server from here as there is no save butto= n.)
=C2=A0
- Edit mode, Fill Factor can be allow= ed to be null.
TODO (This is gene= ric issue in Integer and Numeric controls. This issue is covered in this partial patch)=
=C2=A0
- While dropping inheritance, related ta= ble columns drop SQL are also populated in the SQL Tab
ALTER TABLE public."Tbl"
=C2=A0 =C2= =A0 NO INHERIT b;
ALTER TABLE public."Tbl" D= ROP COLUMN id;
ALTER TABLE public."Tbl" DROP= COLUMN name;

Fi= xed

=C2=A0

And also render er= ror while clicking on the save button.
ERROR: syntax= error at or near "["
LINE 2: INHERIT [;
^
=
Fixed
=C2=A0
- in= a Reverse Engineering SQL tab, schema_name.tablename should be there, curr= ently only table_name displays.
F= ixed

=C2=A0
- Column SQL is showing below t= ext with HTML

<h= tml><head></head><body>-- Column: id -- ALTER TABLE pu= blic.a DROIP COLUMN id; ALTER TABLE public.a ADD COLUMN id integer;</bod= y></html>

I wa= s not able to reproduce exact issue but still I have fixed other issue whic= h I found related to column SQL. Hopefully that will fix this issue as well= .
=C2=A0
- The column datatype dependency does= not get cleared upon selection of another datatype.
=
=C2=A0For example, if I select numeric and gives the length = and precision. After that I change the dat-type then, dependent fields shou= ld be get cleared.
Fixed.
=C2=A0
=

- The column datatype does not ge= t displayed in the properties and edit mode if the length and precision are= given while creating a column.=C2=A0
=

TODO ( I cannot fix this blindly as this might introduce another i= ssue(s) in column node. I will need Murtuza's help as he has worked on = column node)
=C2=A0

- Statistics = is showing null value even after having value.=C2=A0
Fixed
=C2=A0

= - if the check constraints are not validated then put proper icon in tree a= nd also it should be validated in edit mode.
=
Not reproducible.
=C2=A0

<= div>NOTE: I have not checked the Indexes, Triggers and Rules nodes as I do = not have much knowledge about it.


=C2=A0
=
Thanks,
Khushboo

=
=

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




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


--001a11c11d84f0a63a05330647c9-- --001a11c11d84f0a64105330647cb Content-Type: application/octet-stream; name="Added_CREATE_Script_on_Table_v8.patch" Content-Disposition: attachment; filename="Added_CREATE_Script_on_Table_v8.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_iob8c1911 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9fX2luaXRfXy5w eSBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJz L2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9fX2luaXRfXy5weQppbmRleCBj NTYxMTU5Li5hZGY3MDAxIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93 c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90 YWJsZXMvX19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9z ZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVz L19faW5pdF9fLnB5CkBAIC0xOTcsNiArMTk3LDE4IEBAIGNsYXNzIFRhYmxl VmlldyhQR0NoaWxkTm9kZVZpZXcsIERhdGFUeXBlUmVhZGVyLCBWYWN1dW1T ZXR0aW5ncyk6CiAgICAgKiBnZXRfaW5kZXhfY29uc3RyYWludF9zcWwoc2Vs ZiwgdGlkLCBkYXRhKToKICAgICAgIC0gVGhpcyBmdW5jdGlvbiB3aWxsIGdl bmVyYXRlIG1vZGlmaWVkIHNxbCBmb3IgaW5kZXggY29uc3RyYWludHMKICAg ICAgICAgKFByaW1hcnkgS2V5ICYgVW5pcXVlKQorCisgICAgKiBzZWxlY3Rf c3FsKGdpZCwgc2lkLCBkaWQsIHNjaWQsIGZvaWQpOgorICAgICAgLSBSZXR1 cm5zIHNxbCBmb3IgU2NyaXB0CisKKyAgICAqIGluc2VydF9zcWwoZ2lkLCBz aWQsIGRpZCwgc2NpZCwgZm9pZCk6CisgICAgICAtIFJldHVybnMgc3FsIGZv ciBTY3JpcHQKKworICAgICogdXBkYXRlX3NxbChnaWQsIHNpZCwgZGlkLCBz Y2lkLCBmb2lkKToKKyAgICAgIC0gUmV0dXJucyBzcWwgZm9yIFNjcmlwdAor CisgICAgKiBkZWxldGVfc3FsKGdpZCwgc2lkLCBkaWQsIHNjaWQsIGZvaWQp OgorICAgICAgLSBSZXR1cm5zIHNxbCBmb3IgU2NyaXB0CiAiIiIKIAogICAg IG5vZGVfdHlwZSA9IGJsdWVwcmludC5ub2RlX3R5cGUKQEAgLTIzOCw3ICsy NTAsMTIgQEAgY2xhc3MgVGFibGVWaWV3KFBHQ2hpbGROb2RlVmlldywgRGF0 YVR5cGVSZWFkZXIsIFZhY3V1bVNldHRpbmdzKToKICAgICAgICAgJ2FsbF90 YWJsZXMnOiBbe30sIHsnZ2V0JzogJ2dldF9hbGxfdGFibGVzJ31dLAogICAg ICAgICAnZ2V0X2FjY2Vzc19tZXRob2RzJzogW3t9LCB7J2dldCc6ICdnZXRf YWNjZXNzX21ldGhvZHMnfV0sCiAgICAgICAgICdnZXRfb3Blcl9jbGFzcyc6 IFt7fSwgeydnZXQnOiAnZ2V0X29wZXJfY2xhc3MnfV0sCi0gICAgICAgICdn ZXRfb3BlcmF0b3InOiBbe30sIHsnZ2V0JzogJ2dldF9vcGVyYXRvcid9XQor ICAgICAgICAnZ2V0X29wZXJhdG9yJzogW3t9LCB7J2dldCc6ICdnZXRfb3Bl cmF0b3InfV0sCisgICAgICAgICdzZWxlY3Rfc3FsJzogW3snZ2V0JzogJ3Nl bGVjdF9zcWwnfV0sCisgICAgICAgICdpbnNlcnRfc3FsJzogW3snZ2V0Jzog J2luc2VydF9zcWwnfV0sCisgICAgICAgICd1cGRhdGVfc3FsJzogW3snZ2V0 JzogJ3VwZGF0ZV9zcWwnfV0sCisgICAgICAgICdkZWxldGVfc3FsJzogW3sn Z2V0JzogJ2RlbGV0ZV9zcWwnfV0KKwogICAgIH0pCiAKICAgICBkZWYgY2hl Y2tfcHJlY29uZGl0aW9uKGYpOgpAQCAtMjYyOSw0ICsyNjQ2LDE3NiBAQCBj bGFzcyBUYWJsZVZpZXcoUEdDaGlsZE5vZGVWaWV3LCBEYXRhVHlwZVJlYWRl ciwgVmFjdXVtU2V0dGluZ3MpOgogCiAgICAgICAgIHJldHVybiBhamF4X3Jl c3BvbnNlKHJlc3BvbnNlPXNxbC5zdHJpcCgnXG4nKSkKIAorICAgIEBjaGVj a19wcmVjb25kaXRpb24KKyAgICBkZWYgc2VsZWN0X3NxbChzZWxmLCBnaWQs IHNpZCwgZGlkLCBzY2lkLCB0aWQpOgorICAgICAgICAiIiIKKyAgICAgICAg U0VMRUNUIHNjcmlwdCBzcWwgZm9yIHRoZSBvYmplY3QKKworICAgICAgICBB cmdzOgorICAgICAgICAgICAgZ2lkOiBTZXJ2ZXIgR3JvdXAgSWQKKyAgICAg ICAgICAgIHNpZDogU2VydmVyIElkCisgICAgICAgICAgICBkaWQ6IERhdGFi YXNlIElkCisgICAgICAgICAgICBzY2lkOiBTY2hlbWEgSWQKKyAgICAgICAg ICAgIHRpZDogVGFibGUgSWQKKworICAgICAgICBSZXR1cm5zOgorICAgICAg ICAgICAgU0VMRUNUIFNjcmlwdCBzcWwgZm9yIHRoZSBvYmplY3QKKyAgICAg ICAgIiIiCisgICAgICAgIFNRTCA9IHJlbmRlcl90ZW1wbGF0ZSgiLyIuam9p bihbc2VsZi50ZW1wbGF0ZV9wYXRoLAorICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICdwcm9wZXJ0aWVzLnNxbCddKSwKKyAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIHNjaWQ9c2NpZCwgdGlkPXRpZCwK KyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGRhdGxhc3RzeXNvaWQ9 c2VsZi5kYXRsYXN0c3lzb2lkKQorICAgICAgICBzdGF0dXMsIHJlcyA9IHNl bGYuY29ubi5leGVjdXRlX2RpY3QoU1FMKQorICAgICAgICBpZiBub3Qgc3Rh dHVzOgorICAgICAgICAgICAgcmV0dXJuIGludGVybmFsX3NlcnZlcl9lcnJv cihlcnJvcm1zZz1yZXMpCisKKyAgICAgICAgZGF0YSA9IHJlc1sncm93cydd WzBdCisgICAgICAgIGRhdGEgPSBzZWxmLl9mb3JtYXR0ZXIoc2NpZCwgdGlk LCBkYXRhKQorCisgICAgICAgIGNvbHVtbnMgPSBbXQorCisgICAgICAgICMg Tm93IHdlIGhhdmUgYWxsIGxpc3Qgb2YgY29sdW1ucyB3aGljaCB3ZSBuZWVk CisgICAgICAgIGlmICdjb2x1bW5zJyBpbiBkYXRhOgorICAgICAgICAgICAg Zm9yIGMgaW4gZGF0YVsnY29sdW1ucyddOgorICAgICAgICAgICAgICAgIGNv bHVtbnMuYXBwZW5kKHNlbGYucXRJZGVudChzZWxmLmNvbm4sIGNbJ2F0dG5h bWUnXSkpCisKKyAgICAgICAgaWYgbGVuKGNvbHVtbnMpID4gMDoKKyAgICAg ICAgICAgIGNvbHVtbnMgPSAiLCAiLmpvaW4oY29sdW1ucykKKyAgICAgICAg ZWxzZToKKyAgICAgICAgICAgIGNvbHVtbnMgPSAnKicKKworICAgICAgICBz cWwgPSAiU0VMRUNUIHswfVxuXHRGUk9NIHsxfTsiLmZvcm1hdCgKKyAgICAg ICAgICAgIGNvbHVtbnMsCisgICAgICAgICAgICBzZWxmLnF0SWRlbnQoc2Vs Zi5jb25uLCBkYXRhWydzY2hlbWEnXSwgZGF0YVsnbmFtZSddKQorICAgICAg ICApCisgICAgICAgIHJldHVybiBhamF4X3Jlc3BvbnNlKHJlc3BvbnNlPXNx bCkKKworICAgIEBjaGVja19wcmVjb25kaXRpb24KKyAgICBkZWYgaW5zZXJ0 X3NxbChzZWxmLCBnaWQsIHNpZCwgZGlkLCBzY2lkLCB0aWQpOgorICAgICAg ICAiIiIKKyAgICAgICAgSU5TRVJUIHNjcmlwdCBzcWwgZm9yIHRoZSBvYmpl Y3QKKworICAgICAgICBBcmdzOgorICAgICAgICAgICAgZ2lkOiBTZXJ2ZXIg R3JvdXAgSWQKKyAgICAgICAgICAgIHNpZDogU2VydmVyIElkCisgICAgICAg ICAgICBkaWQ6IERhdGFiYXNlIElkCisgICAgICAgICAgICBzY2lkOiBTY2hl bWEgSWQKKyAgICAgICAgICAgIHRpZDogVGFibGUgSWQKKworICAgICAgICBS ZXR1cm5zOgorICAgICAgICAgICAgSU5TRVJUIFNjcmlwdCBzcWwgZm9yIHRo ZSBvYmplY3QKKyAgICAgICAgIiIiCisgICAgICAgIFNRTCA9IHJlbmRlcl90 ZW1wbGF0ZSgiLyIuam9pbihbc2VsZi50ZW1wbGF0ZV9wYXRoLAorICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICdwcm9wZXJ0aWVz LnNxbCddKSwKKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHNjaWQ9 c2NpZCwgdGlkPXRpZCwKKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IGRhdGxhc3RzeXNvaWQ9c2VsZi5kYXRsYXN0c3lzb2lkKQorICAgICAgICBz dGF0dXMsIHJlcyA9IHNlbGYuY29ubi5leGVjdXRlX2RpY3QoU1FMKQorICAg ICAgICBpZiBub3Qgc3RhdHVzOgorICAgICAgICAgICAgcmV0dXJuIGludGVy bmFsX3NlcnZlcl9lcnJvcihlcnJvcm1zZz1yZXMpCisKKyAgICAgICAgZGF0 YSA9IHJlc1sncm93cyddWzBdCisgICAgICAgIGRhdGEgPSBzZWxmLl9mb3Jt YXR0ZXIoc2NpZCwgdGlkLCBkYXRhKQorCisgICAgICAgIGNvbHVtbnMgPSBb XQorICAgICAgICB2YWx1ZXMgPSBbXQorCisgICAgICAgICMgTm93IHdlIGhh dmUgYWxsIGxpc3Qgb2YgY29sdW1ucyB3aGljaCB3ZSBuZWVkCisgICAgICAg IGlmICdjb2x1bW5zJyBpbiBkYXRhOgorICAgICAgICAgICAgZm9yIGMgaW4g ZGF0YVsnY29sdW1ucyddOgorICAgICAgICAgICAgICAgIGNvbHVtbnMuYXBw ZW5kKHNlbGYucXRJZGVudChzZWxmLmNvbm4sIGNbJ2F0dG5hbWUnXSkpCisg ICAgICAgICAgICAgICAgdmFsdWVzLmFwcGVuZCgnPycpCisKKyAgICAgICAg aWYgbGVuKGNvbHVtbnMpID4gMDoKKyAgICAgICAgICAgIGNvbHVtbnMgPSAi LCAiLmpvaW4oY29sdW1ucykKKyAgICAgICAgICAgIHZhbHVlcyA9ICIsICIu am9pbih2YWx1ZXMpCisgICAgICAgICAgICBzcWwgPSAiSU5TRVJUIElOVE8g ezB9KFxuXHR7MX0pXG5cdFZBTFVFUyAoezJ9KTsiLmZvcm1hdCgKKyAgICAg ICAgICAgICAgICBzZWxmLnF0SWRlbnQoc2VsZi5jb25uLCBkYXRhWydzY2hl bWEnXSwgZGF0YVsnbmFtZSddKSwKKyAgICAgICAgICAgICAgICBjb2x1bW5z LCB2YWx1ZXMKKyAgICAgICAgICAgICkKKyAgICAgICAgZWxzZToKKyAgICAg ICAgICAgIHNxbCA9IGdldHRleHQoJy0tIFBsZWFzZSBjcmVhdGUgY29sdW1u KHMpIGZpcnN0Li4uJykKKworICAgICAgICByZXR1cm4gYWpheF9yZXNwb25z ZShyZXNwb25zZT1zcWwpCisKKyAgICBAY2hlY2tfcHJlY29uZGl0aW9uCisg ICAgZGVmIHVwZGF0ZV9zcWwoc2VsZiwgZ2lkLCBzaWQsIGRpZCwgc2NpZCwg dGlkKToKKyAgICAgICAgIiIiCisgICAgICAgIFVQREFURSBzY3JpcHQgc3Fs IGZvciB0aGUgb2JqZWN0CisKKyAgICAgICAgQXJnczoKKyAgICAgICAgICAg IGdpZDogU2VydmVyIEdyb3VwIElkCisgICAgICAgICAgICBzaWQ6IFNlcnZl ciBJZAorICAgICAgICAgICAgZGlkOiBEYXRhYmFzZSBJZAorICAgICAgICAg ICAgc2NpZDogU2NoZW1hIElkCisgICAgICAgICAgICB0aWQ6IFRhYmxlIElk CisKKyAgICAgICAgUmV0dXJuczoKKyAgICAgICAgICAgIFVQREFURSBTY3Jp cHQgc3FsIGZvciB0aGUgb2JqZWN0CisgICAgICAgICIiIgorICAgICAgICBT UUwgPSByZW5kZXJfdGVtcGxhdGUoIi8iLmpvaW4oW3NlbGYudGVtcGxhdGVf cGF0aCwKKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAncHJvcGVydGllcy5zcWwnXSksCisgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBzY2lkPXNjaWQsIHRpZD10aWQsCisgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBkYXRsYXN0c3lzb2lkPXNlbGYuZGF0bGFzdHN5c29p ZCkKKyAgICAgICAgc3RhdHVzLCByZXMgPSBzZWxmLmNvbm4uZXhlY3V0ZV9k aWN0KFNRTCkKKyAgICAgICAgaWYgbm90IHN0YXR1czoKKyAgICAgICAgICAg IHJldHVybiBpbnRlcm5hbF9zZXJ2ZXJfZXJyb3IoZXJyb3Jtc2c9cmVzKQor CisgICAgICAgIGRhdGEgPSByZXNbJ3Jvd3MnXVswXQorICAgICAgICBkYXRh ID0gc2VsZi5fZm9ybWF0dGVyKHNjaWQsIHRpZCwgZGF0YSkKKworICAgICAg ICBjb2x1bW5zID0gW10KKworICAgICAgICAjIE5vdyB3ZSBoYXZlIGFsbCBs aXN0IG9mIGNvbHVtbnMgd2hpY2ggd2UgbmVlZAorICAgICAgICBpZiAnY29s dW1ucycgaW4gZGF0YToKKyAgICAgICAgICAgIGZvciBjIGluIGRhdGFbJ2Nv bHVtbnMnXToKKyAgICAgICAgICAgICAgICBjb2x1bW5zLmFwcGVuZChzZWxm LnF0SWRlbnQoc2VsZi5jb25uLCBjWydhdHRuYW1lJ10pKQorCisgICAgICAg IGlmIGxlbihjb2x1bW5zKSA+IDA6CisgICAgICAgICAgICBpZiBsZW4oY29s dW1ucykgPT0gMToKKyAgICAgICAgICAgICAgICBjb2x1bW5zID0gY29sdW1u c1swXQorICAgICAgICAgICAgICAgIGNvbHVtbnMgKz0gIj0/IgorICAgICAg ICAgICAgZWxzZToKKyAgICAgICAgICAgICAgICBjb2x1bW5zID0gIj0/LCAi LmpvaW4oY29sdW1ucykKKworICAgICAgICAgICAgc3FsID0gIlVQREFURSB7 MH1cblx0U0VUIHsxfVxuXHRXSEVSRSA8Y29uZGl0aW9uPjsiLmZvcm1hdCgK KyAgICAgICAgICAgICAgICBzZWxmLnF0SWRlbnQoc2VsZi5jb25uLCBkYXRh WydzY2hlbWEnXSwgZGF0YVsnbmFtZSddKSwKKyAgICAgICAgICAgICAgICBj b2x1bW5zCisgICAgICAgICAgICApCisgICAgICAgIGVsc2U6CisgICAgICAg ICAgICBzcWwgPSBnZXR0ZXh0KCctLSBQbGVhc2UgY3JlYXRlIGNvbHVtbihz KSBmaXJzdC4uLicpCisKKyAgICAgICAgcmV0dXJuIGFqYXhfcmVzcG9uc2Uo cmVzcG9uc2U9c3FsKQorCisgICAgQGNoZWNrX3ByZWNvbmRpdGlvbgorICAg IGRlZiBkZWxldGVfc3FsKHNlbGYsIGdpZCwgc2lkLCBkaWQsIHNjaWQsIHRp ZCk6CisgICAgICAgICIiIgorICAgICAgICBERUxFVEUgc2NyaXB0IHNxbCBm b3IgdGhlIG9iamVjdAorCisgICAgICAgIEFyZ3M6CisgICAgICAgICAgICBn aWQ6IFNlcnZlciBHcm91cCBJZAorICAgICAgICAgICAgc2lkOiBTZXJ2ZXIg SWQKKyAgICAgICAgICAgIGRpZDogRGF0YWJhc2UgSWQKKyAgICAgICAgICAg IHNjaWQ6IFNjaGVtYSBJZAorICAgICAgICAgICAgdGlkOiBUYWJsZSBJZAor CisgICAgICAgIFJldHVybnM6CisgICAgICAgICAgICBERUxFVEUgU2NyaXB0 IHNxbCBmb3IgdGhlIG9iamVjdAorICAgICAgICAiIiIKKyAgICAgICAgU1FM ID0gcmVuZGVyX3RlbXBsYXRlKCIvIi5qb2luKFtzZWxmLnRlbXBsYXRlX3Bh dGgsCisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg J3Byb3BlcnRpZXMuc3FsJ10pLAorICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgc2NpZD1zY2lkLCB0aWQ9dGlkLAorICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgZGF0bGFzdHN5c29pZD1zZWxmLmRhdGxhc3RzeXNvaWQp CisgICAgICAgIHN0YXR1cywgcmVzID0gc2VsZi5jb25uLmV4ZWN1dGVfZGlj dChTUUwpCisgICAgICAgIGlmIG5vdCBzdGF0dXM6CisgICAgICAgICAgICBy ZXR1cm4gaW50ZXJuYWxfc2VydmVyX2Vycm9yKGVycm9ybXNnPXJlcykKKwor ICAgICAgICBkYXRhID0gcmVzWydyb3dzJ11bMF0KKworICAgICAgICBzcWwg PSAiREVMRVRFIEZST00gezB9XG5cdFdIRVJFIDxjb25kaXRpb24+OyIuZm9y bWF0KAorICAgICAgICAgICAgc2VsZi5xdElkZW50KHNlbGYuY29ubiwgZGF0 YVsnc2NoZW1hJ10sIGRhdGFbJ25hbWUnXSkKKyAgICAgICAgKQorCisgICAg ICAgIHJldHVybiBhamF4X3Jlc3BvbnNlKHJlc3BvbnNlPXNxbCkKKworCiBU YWJsZVZpZXcucmVnaXN0ZXJfbm9kZV92aWV3KGJsdWVwcmludCkKZGlmZiAt LWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2 ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvdGFibGUv anMvdGFibGUuanMgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91 cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVz L3RhYmxlL2pzL3RhYmxlLmpzCmluZGV4IDAyNThjYTcuLmZmZTMxMjQgMTAw NjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9z ZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvdGFi bGUvanMvdGFibGUuanMKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3Rl bXBsYXRlcy90YWJsZS9qcy90YWJsZS5qcwpAQCAtMjYsNiArMjYsNyBAQCBm dW5jdGlvbigkLCBfLCBTLCBwZ0FkbWluLCBwZ0Jyb3dzZXIsIGFsZXJ0aWZ5 KSB7CiAgICAgICBzcWxBbHRlckhlbHA6ICdzcWwtYWx0ZXJ0YWJsZS5odG1s JywKICAgICAgIHNxbENyZWF0ZUhlbHA6ICdzcWwtY3JlYXRldGFibGUuaHRt bCcsCiAgICAgICBwYXJlbnRfdHlwZTogWydzY2hlbWEnLCAnY2F0YWxvZydd LAorICAgICAgaGFzU2NyaXB0VHlwZXM6IFsnY3JlYXRlJywgJ3NlbGVjdCcs ICdpbnNlcnQnLCAndXBkYXRlJywgJ2RlbGV0ZSddLAogICAgICAgSW5pdDog ZnVuY3Rpb24oKSB7CiAgICAgICAgIC8qIEF2b2lkIG11bGl0cGxlIHJlZ2lz dHJhdGlvbiBvZiBtZW51cyAqLwogICAgICAgICBpZiAodGhpcy5pbml0aWFs aXplZCkK --001a11c11d84f0a64105330647cb 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 --001a11c11d84f0a64105330647cb--