Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cuHTl-0007RU-2O for pgadmin-hackers@arkaria.postgresql.org; Sat, 01 Apr 2017 11:46:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cuHTj-000328-Sd for pgadmin-hackers@arkaria.postgresql.org; Sat, 01 Apr 2017 11:45:59 +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 1cuHTh-00031u-SZ for pgadmin-hackers@postgresql.org; Sat, 01 Apr 2017 11:45:58 +0000 Received: from mail-wr0-x231.google.com ([2a00:1450:400c:c0c::231]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cuHTa-0000Mi-6x for pgadmin-hackers@postgresql.org; Sat, 01 Apr 2017 11:45:56 +0000 Received: by mail-wr0-x231.google.com with SMTP id k6so116333954wre.2 for ; Sat, 01 Apr 2017 04:45:49 -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=53Q3A2PPuSwLSJ0DkyEXfqKh0+TfA1A4MLKzCEkgJNc=; b=jLA5ERlT4SHZ2yW9NL86+H8Q+QqgoS3wDp8714oxYG7BP0k4JBRwLXh4mA7i4Yjaqb ILFKO2nHqzds3ReIli+9bBV9whwv1R7fIvNsYS+8eectlrpXQn+zHNCfjwv+67DVAFJ3 9gJAhLZ5gtPozwbOb/uMjyokottZ0b6KPzK4RRNPJdi/4BtLlwDRR/9bzO671Q7LwWTK 1vT/1XhUUAaLACtAHzdZrSt59R6NLdPhY27Qv/O6TL02/29XY5k4vaFwZhllANcsofGP hDi3vQ76gVPBKHw7fBiWNIzPut6TNrkAYlKRGK92UwlTqx72OO63/SD0mzKR3OKCLz1g XmjQ== 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=53Q3A2PPuSwLSJ0DkyEXfqKh0+TfA1A4MLKzCEkgJNc=; b=cB2RHHKOQXniIowI+2lOyuY6lzYRMPCXAA3j1o8FAMGTjsLRPhB2hdbiVZKGBj77wq /L6mhI0DGWE5CnXggAf9eXeyV/x+E80awYrIN23FM8SrmyZqMIWtdCP504SmIndtWqY9 MYR4NdxiAMF8i8emVVM20qGuJjQJwGjUlGgJvR4UU9meZYSs2Fv5dQpX7hpNIYPaePw6 5QhSZj+erU9FwaPlTX8QZHe4tHjwr4DvOZh/1c3T6IAdmN8Rpma06bJD2H5NL4ETNONp qXOIUCCuL7kn2HBEVVAVn2wz48pwN764SgZzF1WZBHe3nLtJLP5EJG5O4uO6cXZl6zBq Lqtw== X-Gm-Message-State: AFeK/H08G+Wsy3xoaiZis7LWBbwSfOAUG8WgnxPrnHek9414P2TOcSsw1cNdUdpqBbz2olbbJbkGCj/ZlM8vW1Fy X-Received: by 10.223.149.35 with SMTP id 32mr7359703wrs.107.1491047147319; Sat, 01 Apr 2017 04:45:47 -0700 (PDT) MIME-Version: 1.0 Received: by 10.28.189.196 with HTTP; Sat, 1 Apr 2017 04:45:16 -0700 (PDT) From: Surinder Kumar Date: Sat, 1 Apr 2017 17:15:16 +0530 Message-ID: Subject: [pgAdmin4][Patch][RM2257]: Query tool - Insert row doesn't use default values To: pgadmin-hackers Content-Type: multipart/mixed; boundary=94eb2c0d202e8fb478054c1977b6 X-Pg-Spam-Score: -1.9 (-) 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 --94eb2c0d202e8fb478054c1977b6 Content-Type: multipart/alternative; boundary=94eb2c0d202e8fb474054c1977b4 --94eb2c0d202e8fb474054c1977b4 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Issues fixed: 1. If a column is defined with a default modifier, there is now way to insert the row with those defaults. The column will be left blank and it will take default value automatically. 2. If a column has a not-null constraint then an error is returned and the row is not inserted. The column will be left blank =E2=80=8B =E2=80=8B =E2=80=8BThe default values for new added rows will be displayed on refresh= /execute. Please find attached patch and review. Thanks Surinder --94eb2c0d202e8fb474054c1977b4 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi<= /div>

Issues fixed:

1. If a column is defined with a default modifier, there is now way to= insert the row with those defaults.
The column will be left bl= ank and it will take default value automatically.

<= /span>
2.=C2=A0If a column has a not-null constraint then an error is return= ed and the row is not inserted.
The column will be left blank=E2=80= =8B =E2=80=8B

=E2=80=8BThe default values for new added rows will be= displayed on refresh/execute.

Please find attached patch and review.


Thanks
Surinder
--94eb2c0d202e8fb474054c1977b4-- --94eb2c0d202e8fb478054c1977b6 Content-Type: application/octet-stream; name="RM_2257.patch" Content-Disposition: attachment; filename="RM_2257.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_j0z6uwf60 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMv Y29sdW1uL3NxbC85LjJfcGx1cy9ub2Rlcy5zcWwgYi93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1h cy90YWJsZXMvdGVtcGxhdGVzL2NvbHVtbi9zcWwvOS4yX3BsdXMvbm9kZXMu c3FsCmluZGV4IDc1OWU2NTcuLmYzMzUzZDYgMTAwNjQ0Ci0tLSBhL3dlYi9w Z2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNl cy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvY29sdW1uL3NxbC85LjJfcGx1 cy9ub2Rlcy5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJf Z3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBs YXRlcy9jb2x1bW4vc3FsLzkuMl9wbHVzL25vZGVzLnNxbApAQCAtMSw0ICsx LDUgQEAKLVNFTEVDVCBhdHQuYXR0bmFtZSBhcyBuYW1lLCBhdHQuYXR0bnVt IGFzIE9JRCwgZm9ybWF0X3R5cGUodHkub2lkLE5VTEwpIEFTIGRhdGF0eXBl CitTRUxFQ1QgYXR0LmF0dG5hbWUgYXMgbmFtZSwgYXR0LmF0dG51bSBhcyBP SUQsIGZvcm1hdF90eXBlKHR5Lm9pZCxOVUxMKSBBUyBkYXRhdHlwZSwKK2F0 dC5hdHRub3RudWxsIGFzIG5vdF9udWxsLCBhdHQuYXR0aGFzZGVmIGFzIGhh c19kZWZhdWx0X3ZhbAogRlJPTSBwZ19hdHRyaWJ1dGUgYXR0CiAgIEpPSU4g cGdfdHlwZSB0eSBPTiB0eS5vaWQ9YXR0dHlwaWQKICAgSk9JTiBwZ19uYW1l c3BhY2UgdG4gT04gdG4ub2lkPXR5LnR5cG5hbWVzcGFjZQpkaWZmIC0tZ2l0 IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy9jb2x1bW4vc3Fs L2RlZmF1bHQvbm9kZXMuc3FsIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3Rl bXBsYXRlcy9jb2x1bW4vc3FsL2RlZmF1bHQvbm9kZXMuc3FsCmluZGV4IDc1 MzZhOWMuLjRmMWRlMmEgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dz ZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3Rh Ymxlcy90ZW1wbGF0ZXMvY29sdW1uL3NxbC9kZWZhdWx0L25vZGVzLnNxbAor KysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVy cy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL2NvbHVtbi9z cWwvZGVmYXVsdC9ub2Rlcy5zcWwKQEAgLTEsNCArMSw1IEBACi1TRUxFQ1Qg YXR0LmF0dG5hbWUgYXMgbmFtZSwgYXR0LmF0dG51bSBhcyBPSUQsIGZvcm1h dF90eXBlKHR5Lm9pZCxOVUxMKSBBUyBkYXRhdHlwZQorU0VMRUNUIGF0dC5h dHRuYW1lIGFzIG5hbWUsIGF0dC5hdHRudW0gYXMgT0lELCBmb3JtYXRfdHlw ZSh0eS5vaWQsTlVMTCkgQVMgZGF0YXR5cGUsCithdHQuYXR0bm90bnVsbCBh cyBub3RfbnVsbCwgYXR0LmF0dGhhc2RlZiBhcyBoYXNfZGVmYXVsdF92YWwK IEZST00gcGdfYXR0cmlidXRlIGF0dAogICAgIEpPSU4gcGdfdHlwZSB0eSBP TiB0eS5vaWQ9YXR0dHlwaWQKICAgICBKT0lOIHBnX25hbWVzcGFjZSB0biBP TiB0bi5vaWQ9dHkudHlwbmFtZXNwYWNlCmRpZmYgLS1naXQgYS93ZWIvcGdh ZG1pbi9zdGF0aWMvanMvc2xpY2tncmlkL3NsaWNrLnBnYWRtaW4uZWRpdG9y cy5qcyBiL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy9zbGlja2dyaWQvc2xpY2su cGdhZG1pbi5lZGl0b3JzLmpzCmluZGV4IGIwZGRmYzUuLmZlZTZiNGEgMTAw NjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy9zbGlja2dyaWQvc2xp Y2sucGdhZG1pbi5lZGl0b3JzLmpzCisrKyBiL3dlYi9wZ2FkbWluL3N0YXRp Yy9qcy9zbGlja2dyaWQvc2xpY2sucGdhZG1pbi5lZGl0b3JzLmpzCkBAIC0x MTAsNyArMTEwLDEyIEBACiAKICAgICAvLyBXaGVuIHRleHQgZWRpdG9yIG9w ZW5zCiAgICAgdGhpcy5sb2FkVmFsdWUgPSBmdW5jdGlvbiAoaXRlbSkgewot ICAgICAgaWYgKGl0ZW1bYXJncy5jb2x1bW4ucG9zXSA9PT0gIiIpIHsKKyAg ICAgIHZhciBjb2wgPSBhcmdzLmNvbHVtbjsKKworICAgICAgaWYgKF8uaXNV bmRlZmluZWQoaXRlbVthcmdzLmNvbHVtbi5wb3NdKSAmJiBjb2wuaGFzX2Rl ZmF1bHRfdmFsKSB7CisgICAgICAgICRpbnB1dC52YWwoIiIpOworICAgICAg fQorICAgICAgZWxzZSBpZiAoaXRlbVthcmdzLmNvbHVtbi5wb3NdID09PSAi IikgewogICAgICAgICAkaW5wdXQudmFsKCInJyIpOwogICAgICAgfQogICAg ICAgZWxzZSB7CkBAIC0xMjAsMTEgKzEyNSwxNSBAQAogICAgIH07CiAKICAg ICB0aGlzLnNlcmlhbGl6ZVZhbHVlID0gZnVuY3Rpb24gKCkgewotICAgICAg dmFyIHZhbHVlID0gJGlucHV0LnZhbCgpOworICAgICAgdmFyIHZhbHVlID0g JGlucHV0LnZhbCgpLAorICAgICAgICAgIGNvbCA9IGFyZ3MuY29sdW1uOwog ICAgICAgLy8gSWYgZW1wdHkgcmV0dXJuIG51bGwKLSAgICAgIGlmICh2YWx1 ZSA9PT0gIiIpIHsKKyAgICAgIGlmICh2YWx1ZSA9PT0gIiIgJiYgIWNvbC5o YXNfZGVmYXVsdF92YWwpIHsKICAgICAgICAgcmV0dXJuIG51bGw7CiAgICAg ICB9CisgICAgICBlbHNlIGlmICh2YWx1ZSA9PT0gIiIgJiYgY29sLmhhc19k ZWZhdWx0X3ZhbCkgeworICAgICAgICByZXR1cm4gJyc7CisgICAgICB9CiAg ICAgICAvLyBzaW5nbGUvZG91YmxlIHF1b3RlcyByZXByZXNlbnQgYW4gZW1w dHkgc3RyaW5nCiAgICAgICAvLyBJZiBmb3VuZCByZXR1cm4gJycKICAgICAg IGVsc2UgaWYgKHZhbHVlID09PSAiJyciIHx8IHZhbHVlID09PSAnIiInKSB7 CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9zdGF0aWMvanMvc2xpY2tncmlk L3NsaWNrLnBnYWRtaW4uZm9ybWF0dGVycy5qcyBiL3dlYi9wZ2FkbWluL3N0 YXRpYy9qcy9zbGlja2dyaWQvc2xpY2sucGdhZG1pbi5mb3JtYXR0ZXJzLmpz CmluZGV4IGIwNjYwOTUuLmM1ZDIwNTcgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2Fk bWluL3N0YXRpYy9qcy9zbGlja2dyaWQvc2xpY2sucGdhZG1pbi5mb3JtYXR0 ZXJzLmpzCisrKyBiL3dlYi9wZ2FkbWluL3N0YXRpYy9qcy9zbGlja2dyaWQv c2xpY2sucGdhZG1pbi5mb3JtYXR0ZXJzLmpzCkBAIC0xOSw3ICsxOSw3IEBA CiAgIH0pOwogCiAgIGZ1bmN0aW9uIEpzb25Gb3JtYXR0ZXIocm93LCBjZWxs LCB2YWx1ZSwgY29sdW1uRGVmLCBkYXRhQ29udGV4dCkgewotICAgIGlmICh2 YWx1ZSA9PSBudWxsIHx8IHZhbHVlID09PSAiIikgeworICAgIGlmIChfLmlz VW5kZWZpbmVkKHZhbHVlKSB8fCB2YWx1ZSA9PSBudWxsIHx8IHZhbHVlID09 PSAiIikgewogICAgICAgcmV0dXJuICIiOwogICAgIH0gZWxzZSB7CiAgICAg ICAvLyBTdHJpbmdpZnkgb25seSBpZiBpdCdzIGpzb24gb2JqZWN0CkBAIC00 MiwxMSArNDIsMTcgQEAKICAgfQogCiAgIGZ1bmN0aW9uIE51bWJlcnNGb3Jt YXR0ZXIocm93LCBjZWxsLCB2YWx1ZSwgY29sdW1uRGVmLCBkYXRhQ29udGV4 dCkgewotICAgIGlmIChfLmlzVW5kZWZpbmVkKHZhbHVlKSB8fCB2YWx1ZSA9 PT0gbnVsbCkgewotICAgICAgcmV0dXJuICI8c3BhbiBjbGFzcz0ncHVsbC1y aWdodCc+W251bGxdPC9zcGFuPiI7CisgICAgLy8gRG9uJ3QgZGlzcGxheSBu dWxsIGlmIGNvbHVtbjoKKyAgICAvLyAxLiB2YWx1ZSBpcyB1bmRlZmluZWQg KE5vIHZhbHVlIGVudGVyZWQgYnkgdXNlcikKKyAgICAvLyAyLiBJZiBlaXRo ZXIgY29sdW1uIGlzIG5vdCBudWxsIG9yIGhhcyBkZWZhdWx0IHZhbHVlLgor ICAgIGlmICgKKyAgICAgICgoXy5pc1VuZGVmaW5lZCh2YWx1ZSkgfHwgXy5p c051bGwodmFsdWUpKSAmJgorICAgICAgKGNvbHVtbkRlZi5oYXNfZGVmYXVs dF92YWwgfHwgY29sdW1uRGVmLm5vdF9udWxsKSkKKyAgICApIHsKKyAgICAg ICAgcmV0dXJuICIiOwogICAgIH0KLSAgICBlbHNlIGlmICh2YWx1ZSA9PT0g IiIpIHsKLSAgICAgIHJldHVybiAnJzsKKyAgICBlbHNlIGlmIChfLmlzVW5k ZWZpbmVkKHZhbHVlKSB8fCB2YWx1ZSA9PT0gbnVsbCkgeworICAgICAgcmV0 dXJuICI8c3BhbiBjbGFzcz0ncHVsbC1yaWdodCc+W251bGxdPC9zcGFuPiI7 CiAgICAgfQogICAgIGVsc2UgewogICAgICAgcmV0dXJuICI8c3BhbiBzdHls ZT0nZmxvYXQ6cmlnaHQnPiIgKyB2YWx1ZSArICI8L3NwYW4+IjsKQEAgLTY2 LDcgKzcyLDE2IEBACiAgIH0KIAogICBmdW5jdGlvbiBUZXh0Rm9ybWF0dGVy KHJvdywgY2VsbCwgdmFsdWUsIGNvbHVtbkRlZiwgZGF0YUNvbnRleHQpIHsK LSAgICBpZiAoXy5pc1VuZGVmaW5lZCh2YWx1ZSkgfHwgdmFsdWUgPT09IG51 bGwpIHsKKyAgICAvLyBEb24ndCBkaXNwbGF5IG51bGwgaWYgY29sdW1uOgor ICAgIC8vIDEuIHZhbHVlIGlzIHVuZGVmaW5lZCAoTm8gdmFsdWUgZW50ZXJl ZCBieSB1c2VyKQorICAgIC8vIDIuIElmIGVpdGhlciBjb2x1bW4gaXMgbm90 IG51bGwgb3IgaGFzIGRlZmF1bHQgdmFsdWUuCisgICAgaWYgKAorICAgICAg KChfLmlzVW5kZWZpbmVkKHZhbHVlKSB8fCBfLmlzTnVsbCh2YWx1ZSkpICYm CisgICAgICAoY29sdW1uRGVmLmhhc19kZWZhdWx0X3ZhbCB8fCBjb2x1bW5E ZWYubm90X251bGwpKQorICAgICkgeworICAgICAgICByZXR1cm4gIiI7Cisg ICAgfQorICAgIGVsc2UgaWYgKF8uaXNVbmRlZmluZWQodmFsdWUpIHx8IHZh bHVlID09PSBudWxsKSB7CiAgICAgICByZXR1cm4gIjxzcGFuIGNsYXNzPSdw dWxsLWxlZnQnPltudWxsXTwvc3Bhbj4iOwogICAgIH0KICAgICBlbHNlIHsK ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3Rvb2xzL3NxbGVkaXRvci9fX2lu aXRfXy5weSBiL3dlYi9wZ2FkbWluL3Rvb2xzL3NxbGVkaXRvci9fX2luaXRf Xy5weQppbmRleCBmMDhiMDJlLi44ODMwODBmIDEwMDY0NAotLS0gYS93ZWIv cGdhZG1pbi90b29scy9zcWxlZGl0b3IvX19pbml0X18ucHkKKysrIGIvd2Vi L3BnYWRtaW4vdG9vbHMvc3FsZWRpdG9yL19faW5pdF9fLnB5CkBAIC00NDIs NiArNDQyLDE5IEBAIGRlZiBnZXRfY29sdW1ucyh0cmFuc19pZCk6CiAgICAg cHJpbWFyeV9rZXlzID0gTm9uZQogICAgIHN0YXR1cywgZXJyb3JfbXNnLCBj b25uLCB0cmFuc19vYmosIHNlc3Npb25fb2JqID0gY2hlY2tfdHJhbnNhY3Rp b25fc3RhdHVzKHRyYW5zX2lkKQogICAgIGlmIHN0YXR1cyBhbmQgY29ubiBp cyBub3QgTm9uZSBhbmQgc2Vzc2lvbl9vYmogaXMgbm90IE5vbmU6CisKKyAg ICAgICAgdmVyID0gY29ubi5tYW5hZ2VyLnZlcnNpb24KKyAgICAgICAgIyBH ZXQgdGhlIHRlbXBsYXRlIHBhdGggZm9yIHRoZSBjb2x1bW4KKyAgICAgICAg dGVtcGxhdGVfcGF0aCA9ICdjb2x1bW4vc3FsLyN7MH0jJy5mb3JtYXQodmVy KQorICAgICAgICBjb21tYW5kX29iaiA9IHBpY2tsZS5sb2FkcyhzZXNzaW9u X29ialsnY29tbWFuZF9vYmonXSkKKyAgICAgICAgU1FMID0gcmVuZGVyX3Rl bXBsYXRlKCIvIi5qb2luKFt0ZW1wbGF0ZV9wYXRoLAorICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICdub2Rlcy5zcWwnXSksCisg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICB0aWQ9Y29tbWFuZF9vYmou b2JqX2lkKQorICAgICAgICAjIHJvd3Mgd2l0aCBhdHRyaWJ1dGUgbm90X251 bGwKKyAgICAgICAgc3RhdHVzLCByc2V0ID0gY29ubi5leGVjdXRlXzJkYXJy YXkoU1FMKQorICAgICAgICBpZiBub3Qgc3RhdHVzOgorICAgICAgICAgICAg cmV0dXJuIGludGVybmFsX3NlcnZlcl9lcnJvcihlcnJvcm1zZz1yc2V0KQor CiAgICAgICAgICMgQ2hlY2sgUEsgY29sdW1uIGluZm8gaXMgYXZhaWxhYmxl IG9yIG5vdAogICAgICAgICBpZiAncHJpbWFyeV9rZXlzJyBpbiBzZXNzaW9u X29iajoKICAgICAgICAgICAgIHByaW1hcnlfa2V5cyA9IHNlc3Npb25fb2Jq WydwcmltYXJ5X2tleXMnXQpAQCAtNDQ5LDEwICs0NjIsMTYgQEAgZGVmIGdl dF9jb2x1bW5zKHRyYW5zX2lkKToKICAgICAgICAgIyBGZXRjaCBjb2x1bW4g aW5mb3JtYXRpb24KICAgICAgICAgY29sdW1uc19pbmZvID0gY29ubi5nZXRf Y29sdW1uX2luZm8oKQogICAgICAgICBpZiBjb2x1bW5zX2luZm8gaXMgbm90 IE5vbmU6Ci0gICAgICAgICAgICBmb3IgY29sIGluIGNvbHVtbnNfaW5mbzoK KyAgICAgICAgICAgIGZvciBrZXksIGNvbCBpbiBlbnVtZXJhdGUoY29sdW1u c19pbmZvKToKICAgICAgICAgICAgICAgICBjb2xfdHlwZSA9IGRpY3QoKQog ICAgICAgICAgICAgICAgIGNvbF90eXBlWyd0eXBlX2NvZGUnXSA9IGNvbFsn dHlwZV9jb2RlJ10KICAgICAgICAgICAgICAgICBjb2xfdHlwZVsndHlwZV9u YW1lJ10gPSBOb25lCisgICAgICAgICAgICAgICAgY29sX3R5cGVbJ25vdF9u dWxsJ10gPSBjb2xbJ25vdF9udWxsJ10gPSBcCisgICAgICAgICAgICAgICAg ICAgIHJzZXRbJ3Jvd3MnXVtrZXldWydub3RfbnVsbCddCisKKyAgICAgICAg ICAgICAgICBjb2xfdHlwZVsnaGFzX2RlZmF1bHRfdmFsJ10gPSBjb2xbJ2hh c19kZWZhdWx0X3ZhbCddID0gXAorICAgICAgICAgICAgICAgICAgICByc2V0 Wydyb3dzJ11ba2V5XVsnaGFzX2RlZmF1bHRfdmFsJ10KKwogICAgICAgICAg ICAgICAgIGNvbHVtbnNbY29sWyduYW1lJ11dID0gY29sX3R5cGUKIAogICAg ICAgICAjIEFzIHdlIGNoYW5nZWQgdGhlIHRyYW5zYWN0aW9uIG9iamVjdCB3 ZSBuZWVkIHRvCmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi90b29scy9zcWxl ZGl0b3IvdGVtcGxhdGVzL3NxbGVkaXRvci9qcy9zcWxlZGl0b3IuanMgYi93 ZWIvcGdhZG1pbi90b29scy9zcWxlZGl0b3IvdGVtcGxhdGVzL3NxbGVkaXRv ci9qcy9zcWxlZGl0b3IuanMKaW5kZXggZWVkMGUwOS4uMGJjM2ExYyAxMDA2 NDQKLS0tIGEvd2ViL3BnYWRtaW4vdG9vbHMvc3FsZWRpdG9yL3RlbXBsYXRl cy9zcWxlZGl0b3IvanMvc3FsZWRpdG9yLmpzCisrKyBiL3dlYi9wZ2FkbWlu L3Rvb2xzL3NxbGVkaXRvci90ZW1wbGF0ZXMvc3FsZWRpdG9yL2pzL3NxbGVk aXRvci5qcwpAQCAtNTY0LDcgKzU2NCw5IEBAIGRlZmluZSgKICAgICAgICAg ICAgICAgaWQ6IGMubmFtZSwKICAgICAgICAgICAgICAgcG9zOiBjLnBvcywK ICAgICAgICAgICAgICAgZmllbGQ6IGMubmFtZSwKLSAgICAgICAgICAgICAg bmFtZTogYy5sYWJlbAorICAgICAgICAgICAgICBuYW1lOiBjLmxhYmVsLAor ICAgICAgICAgICAgICBub3RfbnVsbDogYy5ub3RfbnVsbCwKKyAgICAgICAg ICAgICAgaGFzX2RlZmF1bHRfdmFsOiBjLmhhc19kZWZhdWx0X3ZhbAogICAg ICAgICAgICAgfTsKIAogICAgICAgICAgICAgLy8gR2V0IHRoZSBjb2x1bW5z IHdpZHRoIGJhc2VkIG9uIGRhdGEgdHlwZQpAQCAtMjA3OSw3ICsyMDgxLDkg QEAgZGVmaW5lKAogICAgICAgICAgICAgICAgICAgICAnbGFiZWwnOiBjb2x1 bW5fbGFiZWwsCiAgICAgICAgICAgICAgICAgICAgICdjZWxsJzogY29sX2Nl bGwsCiAgICAgICAgICAgICAgICAgICAgICdjYW5fZWRpdCc6IHNlbGYuY2Fu X2VkaXQsCi0gICAgICAgICAgICAgICAgICAgICd0eXBlJzogdHlwZQorICAg ICAgICAgICAgICAgICAgICAndHlwZSc6IHR5cGUsCisgICAgICAgICAgICAg ICAgICAgICdub3RfbnVsbCc6IGMubm90X251bGwsCisgICAgICAgICAgICAg ICAgICAgICdoYXNfZGVmYXVsdF92YWwnOiBjLmhhc19kZWZhdWx0X3ZhbAog ICAgICAgICAgICAgICAgICAgfTsKICAgICAgICAgICAgICAgICAgIGNvbHVt bnMucHVzaChjb2wpOwogICAgICAgICAgICAgICAgIH0pOwo= --94eb2c0d202e8fb478054c1977b6 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 --94eb2c0d202e8fb478054c1977b6--