Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cRvi5-0007zB-K9 for pgadmin-hackers@arkaria.postgresql.org; Fri, 13 Jan 2017 06:51:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cRvi4-00032S-UD for pgadmin-hackers@arkaria.postgresql.org; Fri, 13 Jan 2017 06:51:36 +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 1cRvhq-0002WS-Cw for pgadmin-hackers@postgresql.org; Fri, 13 Jan 2017 06:51:22 +0000 Received: from mail-wm0-x232.google.com ([2a00:1450:400c:c09::232]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cRvhm-0006p1-QL for pgadmin-hackers@postgresql.org; Fri, 13 Jan 2017 06:51:21 +0000 Received: by mail-wm0-x232.google.com with SMTP id c206so56971677wme.0 for ; Thu, 12 Jan 2017 22:51:18 -0800 (PST) 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=AsKOVqX8Ros+zooF8WDZNI4r+1mm5kc4fqpQbf8XOEg=; b=yagI9kFxxTarHmGF3w33/CYuO/CycXUjjkWqlz8Ey1bDF3MWWDf02zdIerPKZJotSc yFALRZFuPQ3HN7lVATBm+nQ394nMJ9wH6Wshq8e3xdfooQR+oSlIBe2UbFUhTiau/oIR w63wCTZhaTWGr9Sirl8lJUgEWSj2HGRmHnQQg6uS3j14cN3ZCTt72GPw5wfJOX6wdpw6 sDVwDZ1eKPFbBPjQIDLbXr7L+wACUiBARmYCcS4MoXUCI/iofOrX+NK7OmPFiGqXayjP YFh4BmoQPwmHjkm6RS01AsG75/2/jkGu4a6XjtG2jiUSmlswAwc9v33YxKA/EnUwnEAe NAwA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=AsKOVqX8Ros+zooF8WDZNI4r+1mm5kc4fqpQbf8XOEg=; b=ABsCdMY0hEHrW/pV9g4uI6FYIXImsaZUpjwzxfQfjErdDSnudjQGmnW4mhKoMixDzn xYeo9Cm+VI2hoKNtQAXKI2VL718WZhCVQRvlLTZrdG+Kc8X7tTe2kGpUavDTKDdis8pG l6imkawGHuIVJELta3vdqTe3Na9S4P8dP+p/Lg9fIYKjZ8zlp/r3Ahdunvp1WPUy6vJy xcx5nEw7xEg6PRI22/qbmcthkNglYbPuIg3oq0UkIeRXjRpYvwjy2rwFJHpOaoJjXyR+ GVCmaka21JCsb5YzcDM44qzeDCwO6YhVNrzdfHiV8JUzb+1aELyBWezn93lyXNEbsNY6 TFZw== X-Gm-Message-State: AIkVDXItNQatpV8k23zcJEWRfzwUZBlwQ0QJq4b3yRA+wNnolU/oVRqh72xWNAk3r5xmY5pbwVzUkE60FJxGG7aO X-Received: by 10.28.169.135 with SMTP id s129mr824246wme.24.1484290276827; Thu, 12 Jan 2017 22:51:16 -0800 (PST) MIME-Version: 1.0 Received: by 10.28.142.5 with HTTP; Thu, 12 Jan 2017 22:50:46 -0800 (PST) In-Reply-To: References: From: Surinder Kumar Date: Fri, 13 Jan 2017 12:20:46 +0530 Message-ID: Subject: Re: [pgAdmin4][Patch]: RM1840 - cannot create gist index due to enforced ASC, DESC options in generated SQL To: Dave Page Cc: pgadmin-hackers Content-Type: multipart/mixed; boundary=001a114b2f5eb27a100545f4423e 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 --001a114b2f5eb27a100545f4423e Content-Type: multipart/alternative; boundary=001a114b2f5eb27a0c0545f4423c --001a114b2f5eb27a0c0545f4423c Content-Type: text/plain; charset=UTF-8 Hi Please find updated patch following changes: 1) Keep field 'opclass' combo box enabled. 2) Keep ASC/DESC and NULLs FIRST/LAST options disable for access methods other than 'btree'. 3) Add validation for name field. On Fri, Nov 25, 2016 at 5:16 PM, Dave Page wrote: > On Thu, Nov 24, 2016 at 12:13 PM, Surinder Kumar > wrote: > > Hi > > > > Please find updated patch with change. > > > > On Fri, Oct 21, 2016 at 9:16 PM, Dave Page wrote: > >> > >> On Fri, Oct 21, 2016 at 4:42 PM, Surinder Kumar > >> wrote: > >> > On Fri, Oct 21, 2016 at 8:52 PM, Dave Page wrote: > >> >> > >> >> Hi > >> >> > >> >> On Fri, Oct 21, 2016 at 4:16 PM, Surinder Kumar > >> >> wrote: > >> >> > Hi > >> >> > > >> >> > This fix is for exclusion constraint. > >> >> > The options like "order" and "nulls" must be conditional. i.e. > >> >> > include > >> >> > only > >> >> > when access method type is other than "gist". > >> >> > >> >> When creating an index, the asc/desc options are disabled if gist/gin > >> >> used. I think they also should be here. > >> >> > >> >> Also, what about gin indexes in this case? > >> > > >> > As per documentation, > >> > The access method must support amgettuple (see Chapter 52); at present > >> > this > >> > means GIN cannot be used > >> > >> OK, but this patch (unlike the last one) only seems to check for gist. > > > > I have modified the code so It will check for 'gist' and 'spgist' > > Hi, > > This still doesn't seem right to me. For example, if I choose an > access method that doesn't have a default operator class for the > selected data type, Postgres asks me to explicitly choose one, which I > now can't because the combo box is disabled. Conversely, whilst the > opclass should probably not be disabled, the ASC/DESC and NULLs > FIRST/LAST options probably should be disabled (right now, they're > just ignored). > > Thoughts? > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > --001a114b2f5eb27a0c0545f4423c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi<= /div>

Please find updated patch= following changes:
1) Keep field 'opclass' combo box enabled.
2) Keep ASC/DESC and NULLs=C2=A0FIRST/LAST options disable f= or access methods other than 'btree'.
3) Add validation for name field.

On = Fri, Nov 25, 2016 at 5:16 PM, Dave Page <dpage@pgadmin.org> = wrote:
On Thu, Nov 24, 2016 at 12:13 PM, = Surinder Kumar
<surinder.kumar@enterprisedb.com> wrote:
> Hi
>
> Please find updated patch with change.
>
> On Fri, Oct 21, 2016 at 9:16 PM, Dave Page <dpage@pgadmin.org> wrote:
>>
>> On Fri, Oct 21, 2016 at 4:42 PM, Surinder Kumar
>> <surinder.ku= mar@enterprisedb.com> wrote:
>> > On Fri, Oct 21, 2016 at 8:52 PM, Dave Page <dpage@pgadmin.org> wrote:
>> >>
>> >> Hi
>> >>
>> >> On Fri, Oct 21, 2016 at 4:16 PM, Surinder Kumar
>> >> <su= rinder.kumar@enterprisedb.com> wrote:
>> >> > Hi
>> >> >
>> >> > This fix is for exclusion constraint.
>> >> > The options like "order" and "nulls&q= uot; must be conditional. i.e.
>> >> > include
>> >> > only
>> >> > when access method type is other than "gist&quo= t;.
>> >>
>> >> When creating an index, the asc/desc options are disabled= if gist/gin
>> >> used. I think they also should be here.
>> >>
>> >> Also, what about gin indexes in this case?
>> >
>> > As per documentation,
>> > The access method must support amgettuple (see Chapter 52); a= t present
>> > this
>> > means GIN cannot be used
>>
>> OK, but this patch (unlike the last one) only seems to check for g= ist.
>
> I have modified the code so It will check for 'gist' and '= spgist'

Hi,

This still doesn't seem right to me. For example, if I choose an
access method that doesn't have a default operator class for the
selected data type, Postgres asks me to explicitly choose one, which I
now can't because the combo box is disabled. Conversely, whilst the
opclass should probably not be disabled, the ASC/DESC and NULLs
FIRST/LAST options probably should be disabled (right now, they're
just ignored).

Thoughts?

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

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

--001a114b2f5eb27a0c0545f4423c-- --001a114b2f5eb27a100545f4423e Content-Type: application/octet-stream; name="RM1840_V1.patch" Content-Disposition: attachment; filename="RM1840_V1.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_ixvg1d1g0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50 cy9leGNsdXNpb25fY29uc3RyYWludC9fX2luaXRfXy5weSBiL3dlYi9wZ2Fk bWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9z Y2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9leGNsdXNpb25fY29uc3RyYWlu dC9fX2luaXRfXy5weQppbmRleCBkMDk5NTAyLi4zMzE5YjdmIDEwMDY0NAot LS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVy cy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29uc3RyYWludHMvZXhjbHVz aW9uX2NvbnN0cmFpbnQvX19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4v YnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVt YXMvdGFibGVzL2NvbnN0cmFpbnRzL2V4Y2x1c2lvbl9jb25zdHJhaW50L19f aW5pdF9fLnB5CkBAIC04MTYsNyArODE2LDcgQEAgY2xhc3MgRXhjbHVzaW9u Q29uc3RyYWludFZpZXcoUEdDaGlsZE5vZGVWaWV3KToKICAgICAgICAgICAg IHNxbCA9IHJlbmRlcl90ZW1wbGF0ZSgiLyIuam9pbihbc2VsZi50ZW1wbGF0 ZV9wYXRoLCAnY3JlYXRlLnNxbCddKSwKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBkYXRhPWRhdGEsIGNvbm49c2VsZi5jb25uKQogCi0g ICAgICAgIHJldHVybiBzcWwsIGRhdGFbJ25hbWUnXSBpZiAnbmFtZScgaW4g ZGF0YSBlbHNlIG9sZF9kYXRhWyduYW1lJ10KKyAgICAgICAgcmV0dXJuIHNx bCwgZGF0YVsnbmFtZSddCiAKICAgICBAY2hlY2tfcHJlY29uZGl0aW9uCiAg ICAgZGVmIHNxbChzZWxmLCBnaWQsIHNpZCwgZGlkLCBzY2lkLCB0aWQsIGV4 aWQ9Tm9uZSk6CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3Nl cnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMv Y29uc3RyYWludHMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvdGVtcGxhdGVzL2V4 Y2x1c2lvbl9jb25zdHJhaW50L2pzL2V4Y2x1c2lvbl9jb25zdHJhaW50Lmpz IGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL2NvbnN0cmFpbnRzL2V4Y2x1c2lv bl9jb25zdHJhaW50L3RlbXBsYXRlcy9leGNsdXNpb25fY29uc3RyYWludC9q cy9leGNsdXNpb25fY29uc3RyYWludC5qcwppbmRleCA5MjUwZDlmLi40MmI0 MzM2IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9n cm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29uc3Ry YWludHMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvdGVtcGxhdGVzL2V4Y2x1c2lv bl9jb25zdHJhaW50L2pzL2V4Y2x1c2lvbl9jb25zdHJhaW50LmpzCisrKyBi L3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9leGNsdXNpb25f Y29uc3RyYWludC90ZW1wbGF0ZXMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvanMv ZXhjbHVzaW9uX2NvbnN0cmFpbnQuanMKQEAgLTIzLDI2ICsyMyw5IEBAIGZ1 bmN0aW9uKCQsIF8sIFMsIHBnQWRtaW4sIHBnQnJvd3NlciwgQWxlcnRpZnkp IHsKICAgICAgIH0sewogICAgICAgICBpZDogJ29wZXJfY2xhc3MnLCBsYWJl bDone3sgXygnT3BlcmF0b3IgY2xhc3MnKSB9fScsIHR5cGU6J3RleHQnLAog ICAgICAgICBub2RlOiAndGFibGUnLCB1cmw6ICdnZXRfb3Blcl9jbGFzcycs IGZpcnN0X2VtcHR5OiB0cnVlLAotICAgICAgICBlZGl0YWJsZTogZnVuY3Rp b24obSkgewotICAgICAgICAgIGlmIChtIGluc3RhbmNlb2YgQmFja2JvbmUu Q29sbGVjdGlvbikgewotICAgICAgICAgICAgcmV0dXJuIHRydWU7Ci0gICAg ICAgICAgfQotICAgICAgICAgIGlmICgoXy5oYXMobS5jb2xsZWN0aW9uLCAn aGFuZGxlcicpICYmCi0gICAgICAgICAgICAgICAgIV8uaXNVbmRlZmluZWQo bS5jb2xsZWN0aW9uLmhhbmRsZXIpICYmCi0gICAgICAgICAgICAgICAgIV8u aXNVbmRlZmluZWQobS5jb2xsZWN0aW9uLmhhbmRsZXIuZ2V0KCdvaWQnKSkp KSB7Ci0gICAgICAgICAgICByZXR1cm4gZmFsc2U7Ci0gICAgICAgICAgfQot Ci0gICAgICAgICAgaWYgKG0uY29sbGVjdGlvbikgewotICAgICAgICAgICAg dmFyIGluZGV4VHlwZSA9IG0uY29sbGVjdGlvbi5oYW5kbGVyLmdldCgnYW1u YW1lJykKLSAgICAgICAgICAgIHJldHVybiAoaW5kZXhUeXBlID09ICdidHJl ZScgfHwgXy5pc1VuZGVmaW5lZChpbmRleFR5cGUpIHx8Ci0gICAgICAgICAg ICAgIF8uaXNOdWxsKGluZGV4VHlwZSkgfHwgaW5kZXhUeXBlID09ICcnKTsK LSAgICAgICAgICB9IGVsc2UgewotICAgICAgICAgICAgcmV0dXJuIHRydWU7 Ci0gICAgICAgICAgfQotICAgICAgICB9LAorICAgICAgICBlZGl0YWJsZTog dHJ1ZSwKICAgICAgICAgc2VsZWN0MjogewotICAgICAgICAgIGFsbG93Q2xl YXI6IHRydWUsIHdpZHRoOiAnc3R5bGUnLAorICAgICAgICAgIGFsbG93Q2xl YXI6IHRydWUsIHdpZHRoOiAnc3R5bGUnLCB0YWdzOiB0cnVlLAogICAgICAg ICAgIHBsYWNlaG9sZGVyOiAne3sgXygiU2VsZWN0IHRoZSBvcGVyYXRvciBj bGFzcyIpIH19JwogICAgICAgICB9LCBjZWxsOiBCYWNrZ3JpZC5FeHRlbnNp b24uU2VsZWN0MkNlbGwuZXh0ZW5kKHsKICAgICAgICAgICBpbml0aWFsaXpl OiBmdW5jdGlvbiAoKSB7CkBAIC0xMDUsNyArODgsMTAgQEAgZnVuY3Rpb24o JCwgXywgUywgcGdBZG1pbiwgcGdCcm93c2VyLCBBbGVydGlmeSkgewogICAg ICAgICAgIG9uVGV4dDogJ0FTQycsCiAgICAgICAgICAgb2ZmVGV4dDogJ0RF U0MnLAogICAgICAgICB9LGVkaXRhYmxlOiBmdW5jdGlvbihtKSB7Ci0gICAg ICAgICAgaWYgKG0gaW5zdGFuY2VvZiBCYWNrYm9uZS5Db2xsZWN0aW9uKSB7 CisgICAgICAgICAgaWYgKF8uY29udGFpbnMoWydnaXN0JywgJ3NwZ2lzdCcs ICdoYXNoJ10sIG0udG9wLmdldCgnYW1uYW1lJykpKSB7CisgICAgICAgICAg ICByZXR1cm4gZmFsc2U7CisgICAgICAgICAgfQorICAgICAgICAgIGVsc2Ug aWYgKG0gaW5zdGFuY2VvZiBCYWNrYm9uZS5Db2xsZWN0aW9uKSB7CiAgICAg ICAgICAgICByZXR1cm4gdHJ1ZTsKICAgICAgICAgICB9CiAgICAgICAgICAg aWYgKChfLmhhcyhtLmNvbGxlY3Rpb24sICdoYW5kbGVyJykgJiYKQEAgLTEy MSw3ICsxMDcsMTAgQEAgZnVuY3Rpb24oJCwgXywgUywgcGdBZG1pbiwgcGdC cm93c2VyLCBBbGVydGlmeSkgewogICAgICAgICAgIG9uVGV4dDogJ0ZJUlNU JywKICAgICAgICAgICBvZmZUZXh0OiAnTEFTVCcsCiAgICAgICAgIH0sZWRp dGFibGU6IGZ1bmN0aW9uKG0pIHsKLSAgICAgICAgICBpZiAobSBpbnN0YW5j ZW9mIEJhY2tib25lLkNvbGxlY3Rpb24pIHsKKyAgICAgICAgICBpZiAoXy5j b250YWlucyhbJ2dpc3QnLCAnc3BnaXN0JywgJ2hhc2gnXSwgbS50b3AuZ2V0 KCdhbW5hbWUnKSkpIHsKKyAgICAgICAgICAgIHJldHVybiBmYWxzZTsKKyAg ICAgICAgICB9CisgICAgICAgICAgZWxzZSBpZiAobSBpbnN0YW5jZW9mIEJh Y2tib25lLkNvbGxlY3Rpb24pIHsKICAgICAgICAgICAgIHJldHVybiB0cnVl OwogICAgICAgICAgIH0KICAgICAgICAgICBpZiAoKF8uaGFzKG0uY29sbGVj dGlvbiwgJ2hhbmRsZXInKSAmJgpAQCAtODk0LDggKzg4MywxNSBAQCBmdW5j dGlvbigkLCBfLCBTLCBwZ0FkbWluLCBwZ0Jyb3dzZXIsIEFsZXJ0aWZ5KSB7 CiAgICAgICAgIH1dLAogICAgICAgICB2YWxpZGF0ZTogZnVuY3Rpb24oKSB7 CiAgICAgICAgICAgdGhpcy5lcnJvck1vZGVsLmNsZWFyKCk7Ci0gICAgICAg ICAgdmFyIGNvbHVtbnMgPSB0aGlzLmdldCgnY29sdW1ucycpOwotICAgICAg ICAgIGlmICgoXy5pc1VuZGVmaW5lZChjb2x1bW5zKSB8fCBfLmlzTnVsbChj b2x1bW5zKSB8fCBjb2x1bW5zLmxlbmd0aCA8IDEpKSB7CisgICAgICAgICAg dmFyIGNvbHVtbnMgPSB0aGlzLmdldCgnY29sdW1ucycpLAorICAgICAgICAg ICAgICBuYW1lID0gdGhpcy5nZXQoJ25hbWUnKTsKKworICAgICAgICAgIGlm ICgoXy5pc1VuZGVmaW5lZChuYW1lKSB8fCBfLmlzTnVsbChuYW1lKSB8fCBu YW1lLmxlbmd0aCA8IDEpKSB7CisgICAgICAgICAgICB2YXIgbXNnID0gJ3t7 IF8oJ1BsZWFzZSBzcGVjaWZ5IG5hbWUgZm9yIGV4Y2x1c2lvbiBjb25zdHJh aW50LicpIH19JzsKKyAgICAgICAgICAgIHRoaXMuZXJyb3JNb2RlbC5zZXQo J25hbWUnLCBtc2cpOworICAgICAgICAgICAgcmV0dXJuIG1zZzsKKyAgICAg ICAgICB9CisgICAgICAgICAgZWxzZSAgaWYgKChfLmlzVW5kZWZpbmVkKGNv bHVtbnMpIHx8IF8uaXNOdWxsKGNvbHVtbnMpIHx8IGNvbHVtbnMubGVuZ3Ro IDwgMSkpIHsKICAgICAgICAgICAgIHZhciBtc2cgPSAne3sgXygnUGxlYXNl IHNwZWNpZnkgY29sdW1ucyBmb3IgZXhjbHVzaW9uIGNvbnN0cmFpbnQuJykg fX0nOwogICAgICAgICAgICAgdGhpcy5lcnJvck1vZGVsLnNldCgnY29sdW1u cycsIG1zZyk7CiAgICAgICAgICAgICByZXR1cm4gbXNnOwpkaWZmIC0tZ2l0 IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy9leGNsdXNpb25f Y29uc3RyYWludC9zcWwvOS4xX3BsdXMvY3JlYXRlLnNxbCBiL3dlYi9wZ2Fk bWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9z Y2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvZXhjbHVzaW9uX2NvbnN0cmFpbnQv c3FsLzkuMV9wbHVzL2NyZWF0ZS5zcWwKaW5kZXggZGIyOTA0OC4uODBjNDI3 YSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3Jv dXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRl cy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS4xX3BsdXMvY3JlYXRlLnNx bAorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2Vy dmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL2V4Y2x1 c2lvbl9jb25zdHJhaW50L3NxbC85LjFfcGx1cy9jcmVhdGUuc3FsCkBAIC0x LDcgKzEsNyBAQAogQUxURVIgVEFCTEUge3sgY29ubnxxdElkZW50KGRhdGEu c2NoZW1hLCBkYXRhLnRhYmxlKSB9fQogICAgIEFERHslIGlmIGRhdGEubmFt ZSAlfSBDT05TVFJBSU5UIHt7IGNvbm58cXRJZGVudChkYXRhLm5hbWUpIH19 eyUgZW5kaWYlfSBFWENMVURFIHslIGlmIGRhdGEuYW1uYW1lIGFuZCBkYXRh LmFtbmFtZSAhPSAnJyAlfVVTSU5HIHt7ZGF0YS5hbW5hbWV9fXslIGVuZGlm ICV9ICgKICAgICB7JSBmb3IgY29sIGluIGRhdGEuY29sdW1ucyAlfXslIGlm IGxvb3AuaW5kZXggIT0gMSAlfSwKLSAgICB7JSBlbmRpZiAlfXt7IGNvbm58 cXRJZGVudChjb2wuY29sdW1uKX19IHslIGlmIGNvbC5vcGVyX2NsYXNzIGFu ZCBjb2wub3Blcl9jbGFzcyAhPSAnJyAlfXt7Y29sLm9wZXJfY2xhc3N9fSB7 JSBlbmRpZiV9eyUgaWYgY29sLm9yZGVyICV9QVNDeyUgZWxzZSAlfURFU0N7 JSBlbmRpZiAlfSBOVUxMUyB7JSBpZiBjb2wubnVsbHNfb3JkZXIgJX1GSVJT VHslIGVsc2UgJX1MQVNUeyUgZW5kaWYgJX0gV0lUSCB7e2NvbC5vcGVyYXRv cn19eyUgZW5kZm9yICV9KXslIGlmIGRhdGEuZmlsbGZhY3RvciAlfQorICAg IHslIGVuZGlmICV9e3sgY29ubnxxdElkZW50KGNvbC5jb2x1bW4pfX17JSBp ZiBjb2wub3Blcl9jbGFzcyBhbmQgY29sLm9wZXJfY2xhc3MgIT0gJycgJX0g e3tjb2wub3Blcl9jbGFzc319eyUgZW5kaWYlfXslIGlmIGNvbC5vcmRlciBp cyBkZWZpbmVkICV9eyUgaWYgY29sLm9yZGVyICV9IEFTQ3slIGVsc2UgJX0g REVTQ3slIGVuZGlmICV9IE5VTExTeyUgZW5kaWYgJX0geyUgaWYgY29sLm51 bGxzX29yZGVyIGlzIGRlZmluZWQgJX17JSBpZiBjb2wubnVsbHNfb3JkZXIg JX1GSVJTVCB7JSBlbHNlICV9TEFTVCB7JSBlbmRpZiAlfXslIGVuZGlmICV9 V0lUSCB7e2NvbC5vcGVyYXRvcn19eyUgZW5kZm9yICV9KXslIGlmIGRhdGEu ZmlsbGZhY3RvciAlfQogICAgIFdJVEggKEZJTExGQUNUT1I9e3tkYXRhLmZp bGxmYWN0b3J9fSl7JSBlbmRpZiAlfXslIGlmIGRhdGEuc3BjbmFtZSBhbmQg ZGF0YS5zcGNuYW1lICE9ICJwZ19kZWZhdWx0IiAlfQogCiAgICAgVVNJTkcg SU5ERVggVEFCTEVTUEFDRSB7eyBjb25ufHF0SWRlbnQoZGF0YS5zcGNuYW1l KSB9fXslIGVuZGlmICV9CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93 c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90 YWJsZXMvdGVtcGxhdGVzL2V4Y2x1c2lvbl9jb25zdHJhaW50L3NxbC85LjJf cGx1cy9jcmVhdGUuc3FsIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJf Z3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBs YXRlcy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS4yX3BsdXMvY3JlYXRl LnNxbAppbmRleCBkYjI5MDQ4Li44MGM0MjdhIDEwMDY0NAotLS0gYS93ZWIv cGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL2V4Y2x1c2lvbl9jb25zdHJh aW50L3NxbC85LjJfcGx1cy9jcmVhdGUuc3FsCisrKyBiL3dlYi9wZ2FkbWlu L2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hl bWFzL3RhYmxlcy90ZW1wbGF0ZXMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvc3Fs LzkuMl9wbHVzL2NyZWF0ZS5zcWwKQEAgLTEsNyArMSw3IEBACiBBTFRFUiBU QUJMRSB7eyBjb25ufHF0SWRlbnQoZGF0YS5zY2hlbWEsIGRhdGEudGFibGUp IH19CiAgICAgQUREeyUgaWYgZGF0YS5uYW1lICV9IENPTlNUUkFJTlQge3sg Y29ubnxxdElkZW50KGRhdGEubmFtZSkgfX17JSBlbmRpZiV9IEVYQ0xVREUg eyUgaWYgZGF0YS5hbW5hbWUgYW5kIGRhdGEuYW1uYW1lICE9ICcnICV9VVNJ Tkcge3tkYXRhLmFtbmFtZX19eyUgZW5kaWYgJX0gKAogICAgIHslIGZvciBj b2wgaW4gZGF0YS5jb2x1bW5zICV9eyUgaWYgbG9vcC5pbmRleCAhPSAxICV9 LAotICAgIHslIGVuZGlmICV9e3sgY29ubnxxdElkZW50KGNvbC5jb2x1bW4p fX0geyUgaWYgY29sLm9wZXJfY2xhc3MgYW5kIGNvbC5vcGVyX2NsYXNzICE9 ICcnICV9e3tjb2wub3Blcl9jbGFzc319IHslIGVuZGlmJX17JSBpZiBjb2wu b3JkZXIgJX1BU0N7JSBlbHNlICV9REVTQ3slIGVuZGlmICV9IE5VTExTIHsl IGlmIGNvbC5udWxsc19vcmRlciAlfUZJUlNUeyUgZWxzZSAlfUxBU1R7JSBl bmRpZiAlfSBXSVRIIHt7Y29sLm9wZXJhdG9yfX17JSBlbmRmb3IgJX0peyUg aWYgZGF0YS5maWxsZmFjdG9yICV9CisgICAgeyUgZW5kaWYgJX17eyBjb25u fHF0SWRlbnQoY29sLmNvbHVtbil9fXslIGlmIGNvbC5vcGVyX2NsYXNzIGFu ZCBjb2wub3Blcl9jbGFzcyAhPSAnJyAlfSB7e2NvbC5vcGVyX2NsYXNzfX17 JSBlbmRpZiV9eyUgaWYgY29sLm9yZGVyIGlzIGRlZmluZWQgJX17JSBpZiBj b2wub3JkZXIgJX0gQVNDeyUgZWxzZSAlfSBERVNDeyUgZW5kaWYgJX0gTlVM TFN7JSBlbmRpZiAlfSB7JSBpZiBjb2wubnVsbHNfb3JkZXIgaXMgZGVmaW5l ZCAlfXslIGlmIGNvbC5udWxsc19vcmRlciAlfUZJUlNUIHslIGVsc2UgJX1M QVNUIHslIGVuZGlmICV9eyUgZW5kaWYgJX1XSVRIIHt7Y29sLm9wZXJhdG9y fX17JSBlbmRmb3IgJX0peyUgaWYgZGF0YS5maWxsZmFjdG9yICV9CiAgICAg V0lUSCAoRklMTEZBQ1RPUj17e2RhdGEuZmlsbGZhY3Rvcn19KXslIGVuZGlm ICV9eyUgaWYgZGF0YS5zcGNuYW1lIGFuZCBkYXRhLnNwY25hbWUgIT0gInBn X2RlZmF1bHQiICV9CiAKICAgICBVU0lORyBJTkRFWCBUQUJMRVNQQUNFIHt7 IGNvbm58cXRJZGVudChkYXRhLnNwY25hbWUpIH19eyUgZW5kaWYgJX0KZGlm ZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9z ZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvZXhj bHVzaW9uX2NvbnN0cmFpbnQvc3FsLzkuNl9wbHVzL2NyZWF0ZS5zcWwgYi93 ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRh YmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL2V4Y2x1c2lvbl9jb25z dHJhaW50L3NxbC85LjZfcGx1cy9jcmVhdGUuc3FsCmluZGV4IGRiMjkwNDgu LjgwYzQyN2EgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2Vy dmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90 ZW1wbGF0ZXMvZXhjbHVzaW9uX2NvbnN0cmFpbnQvc3FsLzkuNl9wbHVzL2Ny ZWF0ZS5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3Jv dXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRl cy9leGNsdXNpb25fY29uc3RyYWludC9zcWwvOS42X3BsdXMvY3JlYXRlLnNx bApAQCAtMSw3ICsxLDcgQEAKIEFMVEVSIFRBQkxFIHt7IGNvbm58cXRJZGVu dChkYXRhLnNjaGVtYSwgZGF0YS50YWJsZSkgfX0KICAgICBBRER7JSBpZiBk YXRhLm5hbWUgJX0gQ09OU1RSQUlOVCB7eyBjb25ufHF0SWRlbnQoZGF0YS5u YW1lKSB9fXslIGVuZGlmJX0gRVhDTFVERSB7JSBpZiBkYXRhLmFtbmFtZSBh bmQgZGF0YS5hbW5hbWUgIT0gJycgJX1VU0lORyB7e2RhdGEuYW1uYW1lfX17 JSBlbmRpZiAlfSAoCiAgICAgeyUgZm9yIGNvbCBpbiBkYXRhLmNvbHVtbnMg JX17JSBpZiBsb29wLmluZGV4ICE9IDEgJX0sCi0gICAgeyUgZW5kaWYgJX17 eyBjb25ufHF0SWRlbnQoY29sLmNvbHVtbil9fSB7JSBpZiBjb2wub3Blcl9j bGFzcyBhbmQgY29sLm9wZXJfY2xhc3MgIT0gJycgJX17e2NvbC5vcGVyX2Ns YXNzfX0geyUgZW5kaWYlfXslIGlmIGNvbC5vcmRlciAlfUFTQ3slIGVsc2Ug JX1ERVNDeyUgZW5kaWYgJX0gTlVMTFMgeyUgaWYgY29sLm51bGxzX29yZGVy ICV9RklSU1R7JSBlbHNlICV9TEFTVHslIGVuZGlmICV9IFdJVEgge3tjb2wu b3BlcmF0b3J9fXslIGVuZGZvciAlfSl7JSBpZiBkYXRhLmZpbGxmYWN0b3Ig JX0KKyAgICB7JSBlbmRpZiAlfXt7IGNvbm58cXRJZGVudChjb2wuY29sdW1u KX19eyUgaWYgY29sLm9wZXJfY2xhc3MgYW5kIGNvbC5vcGVyX2NsYXNzICE9 ICcnICV9IHt7Y29sLm9wZXJfY2xhc3N9fXslIGVuZGlmJX17JSBpZiBjb2wu b3JkZXIgaXMgZGVmaW5lZCAlfXslIGlmIGNvbC5vcmRlciAlfSBBU0N7JSBl bHNlICV9IERFU0N7JSBlbmRpZiAlfSBOVUxMU3slIGVuZGlmICV9IHslIGlm IGNvbC5udWxsc19vcmRlciBpcyBkZWZpbmVkICV9eyUgaWYgY29sLm51bGxz X29yZGVyICV9RklSU1QgeyUgZWxzZSAlfUxBU1QgeyUgZW5kaWYgJX17JSBl bmRpZiAlfVdJVEgge3tjb2wub3BlcmF0b3J9fXslIGVuZGZvciAlfSl7JSBp ZiBkYXRhLmZpbGxmYWN0b3IgJX0KICAgICBXSVRIIChGSUxMRkFDVE9SPXt7 ZGF0YS5maWxsZmFjdG9yfX0peyUgZW5kaWYgJX17JSBpZiBkYXRhLnNwY25h bWUgYW5kIGRhdGEuc3BjbmFtZSAhPSAicGdfZGVmYXVsdCIgJX0KIAogICAg IFVTSU5HIElOREVYIFRBQkxFU1BBQ0Uge3sgY29ubnxxdElkZW50KGRhdGEu c3BjbmFtZSkgfX17JSBlbmRpZiAlfQo= --001a114b2f5eb27a100545f4423e 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 --001a114b2f5eb27a100545f4423e--