Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lb2pG-0005fQ-Ty for pgadmin-hackers@arkaria.postgresql.org; Mon, 26 Apr 2021 15:07:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lb2pF-0004Wm-IT for pgadmin-hackers@arkaria.postgresql.org; Mon, 26 Apr 2021 15:07:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lb2pF-0004Wd-4n for pgadmin-hackers@lists.postgresql.org; Mon, 26 Apr 2021 15:07:05 +0000 Received: from mail-qk1-x734.google.com ([2607:f8b0:4864:20::734]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lb2pB-0001cJ-TE for pgadmin-hackers@postgresql.org; Mon, 26 Apr 2021 15:07:03 +0000 Received: by mail-qk1-x734.google.com with SMTP id z2so19780948qkb.9 for ; Mon, 26 Apr 2021 08:07:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=+2azfoa7mYIRAlqdl6EVf+WGGdNuKlIv7pZbOwCP31w=; b=Wk6VSHduH+PgPLqYIRvAAtymagkxlzI7Je+MR+5floyxkn+4263zGhTEz+VCBG1xUg fGJjxMWsol/DuTMEYvIwQNfrnchs/yFHm8N9B3D/+77UiKx6qPRP1J82QdiV/rmub4ic Zndasr10BKJV61dN83UyMZHh8F+a6F0wIZ0YhHGIYXwUhGNIsDXqiqK4+mW4eGKR84+h 7aTSl/V2tcTbTfoXLoR7+wNUwSj3MVXgWwVlvv10u/0UZEFyemEOMx+jxPz+W8Kz1BuH 7LbkPsZj+iOPPqBWls5w9GhipW5Wxh8csUSSCob+NeuSzm+/2vS0AnRWrna5Ie2Vq+lY w0RQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=+2azfoa7mYIRAlqdl6EVf+WGGdNuKlIv7pZbOwCP31w=; b=H2dtVDxaxo+GqD2U7rbQ4k5vbUty7f5WfSMf5SXIDaOQbLBDAf5s+dOXLXUfTySnBk DC3GJqRZNtqtRG5dmtm+LM9trMQ0BnMspESgJ9gyHgMz7xwlYsLdj11IcTJjn8/hphe8 jjxOkzgDaGYoARltb+D+Q0/BStrvnNxIT1vbJ1TmYIkX8xaNJncXITFgEBG/XFnfT701 DeHaBg56gqpbVL3n44RXf+zy3i/y4Iu9DW595Fr0CWwqGexeMXJdZzSZ2MC660ShfMnl Gh2pEWC0tfEQopLmlOMwLJjGKjcDhZGrJfmUN6c0B4BrHvbsf+ZNhePIS5Vw27dEVgz3 rYbA== X-Gm-Message-State: AOAM530JckYDO8Yql/x3StWs9OgbXSpPDD8bHMbjFEQs6+z7260pxFK5 TJBFjYg29pvbwqgTFmkgXoAxSZ+dcvogcwyinS89oHkXkpVttc25ltDzuPo/ibnA25gdBqYm8NH EGZdEimoTuS3XxutDck2TJkx07gb+dzQkZ1VDM/29rylCtXCZZ9H59Gyqp1VVrXiObsyCswW5Oh Leevol0shopb0pg3vmFqN4IjEVcI5OzGUF0bLD+4J2Ru6lYyNFnMj3lXOAeQ== X-Google-Smtp-Source: ABdhPJyfW6SNTAtXpptesN4CtMuIe416OidGzDxKoxPKbIwsdHV2tumXkQsYvWglt3wc7QOkWR3s7mzNhzQGvL1pWzc= X-Received: by 2002:a05:620a:13e2:: with SMTP id h2mr17140879qkl.235.1619449620498; Mon, 26 Apr 2021 08:07:00 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Rahul Shirsat Date: Mon, 26 Apr 2021 20:36:23 +0530 Message-ID: Subject: Re: [pgAdmin][patch] RM6329 [SQL] bad child table DDL To: Akshay Joshi Cc: pgadmin-hackers Content-Type: multipart/mixed; boundary="0000000000005cbc1e05c0e17f37" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005cbc1e05c0e17f37 Content-Type: multipart/alternative; boundary="0000000000005cbc1b05c0e17f35" --0000000000005cbc1b05c0e17f35 Content-Type: text/plain; charset="UTF-8" Hello Akshay, Please find the updated patch. On Mon, Apr 26, 2021 at 2:34 PM Akshay Joshi wrote: > Thanks, patch applied. > > On Fri, Apr 23, 2021 at 2:08 PM Rahul Shirsat < > rahul.shirsat@enterprisedb.com> wrote: > >> Hi Hackers, >> >> Please find below patch which resolves the issue of inherited key >> constraint getting in partition SQL. >> >> Simultaneously, added the partition table's RLS policy, Triggers, Rules, >> Compound Triggers in the main SQL tab as previously it was not included. >> >> -- >> *Rahul Shirsat* >> Senior Software Engineer | EnterpriseDB Corporation. >> > > > -- > *Thanks & Regards* > *Akshay Joshi* > *pgAdmin Hacker | Principal Software Architect* > *EDB Postgres * > > *Mobile: +91 976-788-8246* > -- *Rahul Shirsat* Senior Software Engineer | EnterpriseDB Corporation. --0000000000005cbc1b05c0e17f35 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello=C2=A0Akshay,

Please find the = updated patch.

On Mon, Apr 26, 2021 at 2:34 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Thanks, patch applied.

On Fri, Apr 23, 2021 at 2:08 PM Rahul S= hirsat <rahul.shirsat@enterprisedb.com> wrote:
Hi Hackers,

Please find below patch which resolves the issue of inherited key co= nstraint getting in partition SQL.

Simultaneously,= added the partition table's RLS policy, Triggers, Rules, Compound Trig= gers in the main SQL tab as previously it was not included.
=
--
Rahul Shirsat
Senior Software Engineer=C2=A0|=C2=A0EnterpriseDB=C2=A0Corpora= tion.


--
Thank= s & Regards
Akshay Joshi
pgAdmin Hacker | Principal Softw= are Architect
EDB Po= stgres
Mobile: +91 976-788-8246



--
Rahul Shirsat
Senior Software Engineer=C2=A0|=C2=A0EnterpriseDB=C2=A0Corporation.=
--0000000000005cbc1b05c0e17f35-- --0000000000005cbc1e05c0e17f37 Content-Type: application/octet-stream; name="RM6329_v2.patch" Content-Disposition: attachment; filename="RM6329_v2.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_knyqgmwe0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvaW5kZXhlcy9zcWwvZGVmYXVsdC9ub2Rl cy5zcWwgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL2luZGV4ZXMvc3FsL2RlZmF1bHQvbm9kZXMuc3Fs CmluZGV4IDI2ODI2ZWY3My4uYzFmOGNmZTVlIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93 c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxh dGVzL2luZGV4ZXMvc3FsL2RlZmF1bHQvbm9kZXMuc3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dz ZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0 ZXMvaW5kZXhlcy9zcWwvZGVmYXVsdC9ub2Rlcy5zcWwKQEAgLTEsNCArMSw1IEBACi1TRUxFQ1Qg RElTVElOQ1QgT04oY2xzLnJlbG5hbWUpIGNscy5vaWQsIGNscy5yZWxuYW1lIGFzIG5hbWUKK1NF TEVDVCBESVNUSU5DVCBPTihjbHMucmVsbmFtZSkgY2xzLm9pZCwgY2xzLnJlbG5hbWUgYXMgbmFt ZSwKKyhTRUxFQ1QgKENBU0UgV0hFTiBjb3VudChpLmluaHJlbGlkKSA+IDAgVEhFTiB0cnVlIEVM U0UgZmFsc2UgRU5EKSBGUk9NIHBnX2luaGVyaXRzIGkgV0hFUkUgaS5pbmhyZWxpZCA9IGNscy5v aWQpIGFzIGlzX2luaGVyaXRlZAogRlJPTSBwZ19jYXRhbG9nLnBnX2luZGV4IGlkeAogICAgIEpP SU4gcGdfY2F0YWxvZy5wZ19jbGFzcyBjbHMgT04gY2xzLm9pZD1pbmRleHJlbGlkCiAgICAgSk9J TiBwZ19jYXRhbG9nLnBnX2NsYXNzIHRhYiBPTiB0YWIub2lkPWluZHJlbGlkCmRpZmYgLS1naXQg YS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2No ZW1hcy90YWJsZXMvdGVtcGxhdGVzL2luZGV4ZXMvc3FsL2RlZmF1bHQvcHJvcGVydGllcy5zcWwg Yi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2No ZW1hcy90YWJsZXMvdGVtcGxhdGVzL2luZGV4ZXMvc3FsL2RlZmF1bHQvcHJvcGVydGllcy5zcWwK aW5kZXggOTc1MDk5YzZiLi4zN2RhY2U5NjcgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dz ZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0 ZXMvaW5kZXhlcy9zcWwvZGVmYXVsdC9wcm9wZXJ0aWVzLnNxbAorKysgYi93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVt cGxhdGVzL2luZGV4ZXMvc3FsL2RlZmF1bHQvcHJvcGVydGllcy5zcWwKQEAgLTEsNiArMSw2IEBA CiBTRUxFQ1QgRElTVElOQ1QgT04oY2xzLnJlbG5hbWUpIGNscy5vaWQsIGNscy5yZWxuYW1lIGFz IG5hbWUsIGluZHJlbGlkLCBpbmRrZXksIGluZGlzY2x1c3RlcmVkLAogICAgIGluZGlzdmFsaWQs IGluZGlzdW5pcXVlLCBpbmRpc3ByaW1hcnksIG4ubnNwbmFtZSxpbmRuYXR0cyxjbHMucmVsdGFi bGVzcGFjZSBBUyBzcGNvaWQsCi0gICAgQ0FTRSBXSEVOIGxlbmd0aChzcGNuYW1lOjp0ZXh0KSA+ IDAgVEhFTiBzcGNuYW1lIEVMU0UKKyAgICBDQVNFIFdIRU4gKGxlbmd0aChzcGNuYW1lOjp0ZXh0 KSA+IDAgT1IgY2xzLnJlbGtpbmQgPSAnSScpIFRIRU4gc3BjbmFtZSBFTFNFCiAgICAgICAgIChT RUxFQ1Qgc3Auc3BjbmFtZSBGUk9NIHBnX2NhdGFsb2cucGdfZGF0YWJhc2UgZHRiCiAgICAgICAg IEpPSU4gcGdfY2F0YWxvZy5wZ190YWJsZXNwYWNlIHNwIE9OIGR0Yi5kYXR0YWJsZXNwYWNlPXNw Lm9pZAogICAgICAgICBXSEVSRSBkdGIub2lkID0ge3sgZGlkIH19OjpvaWQpCkBAIC05LDYgKzks NyBAQCBTRUxFQ1QgRElTVElOQ1QgT04oY2xzLnJlbG5hbWUpIGNscy5vaWQsIGNscy5yZWxuYW1l IGFzIG5hbWUsIGluZHJlbGlkLCBpbmRrZXksCiAgICAgQ0FTRSBXSEVOIGNvbnR5cGUgSU4gKCdw JywgJ3UnLCAneCcpIFRIRU4gZGVzcC5kZXNjcmlwdGlvbgogICAgICAgICAgRUxTRSBkZXMuZGVz Y3JpcHRpb24gRU5EIEFTIGRlc2NyaXB0aW9uLAogICAgIHBnX2NhdGFsb2cucGdfZ2V0X2V4cHIo aW5kcHJlZCwgaW5kcmVsaWQsIHRydWUpIGFzIGluZGNvbnN0cmFpbnQsIGNvbnR5cGUsIGNvbmRl ZmVycmFibGUsIGNvbmRlZmVycmVkLCBhbW5hbWUsCisgICAgKFNFTEVDVCAoQ0FTRSBXSEVOIGNv dW50KGkuaW5ocmVsaWQpID4gMCBUSEVOIHRydWUgRUxTRSBmYWxzZSBFTkQpIEZST00gcGdfaW5o ZXJpdHMgaSBXSEVSRSBpLmluaHJlbGlkID0gY2xzLm9pZCkgYXMgaXNfaW5oZXJpdGVkLAogICAg IHN1YnN0cmluZyhwZ19jYXRhbG9nLmFycmF5X3RvX3N0cmluZyhjbHMucmVsb3B0aW9ucywgJywn KSBmcm9tICdmaWxsZmFjdG9yPShbMC05XSopJykgQVMgZmlsbGZhY3RvcgogICAgIHslIGlmIGRh dGxhc3RzeXNvaWQgJX0sIChDQVNFIFdIRU4gY2xzLm9pZCA8PSB7eyBkYXRsYXN0c3lzb2lkfX06 Om9pZCBUSEVOIHRydWUgRWxTRSBmYWxzZSBFTkQpIEFTIGlzX3N5c19pZHggeyUgZW5kaWYgJX0K IEZST00gcGdfY2F0YWxvZy5wZ19pbmRleCBpZHgKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jy b3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy91dGls cy5weSBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNl cy9zY2hlbWFzL3RhYmxlcy91dGlscy5weQppbmRleCA5M2E2NjE2YjQuLmExOTYyNDMxMSAxMDA2 NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJh c2VzL3NjaGVtYXMvdGFibGVzL3V0aWxzLnB5CisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2Vy dmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy91dGlscy5weQpAQCAt NzAzLDYgKzcwMywxMiBAQCBjbGFzcyBCYXNlVGFibGVWaWV3KFBHQ2hpbGROb2RlVmlldywgQmFz ZVBhcnRpdGlvblRhYmxlLCBWYWN1dW1TZXR0aW5ncyk6CiAgICAgICAgIGZyb20gcGdhZG1pbi5i cm93c2VyLnNlcnZlcl9ncm91cHMuc2VydmVycy5kYXRhYmFzZXMuc2NoZW1hcy4gXAogICAgICAg ICAgICAgdGFibGVzLmluZGV4ZXMgaW1wb3J0IHV0aWxzIGFzIGluZGV4X3V0aWxzCiAgICAgICAg IGZvciByb3cgaW4gcnNldFsncm93cyddOgorICAgICAgICAgICAgIyBEbyBub3QgaW5jbHVkZSBp bmhlcml0ZWQgaW5kZXhlcyBhcyB0aG9zZSBhcmUgYXV0b21hdGljYWxseQorICAgICAgICAgICAg IyBjcmVhdGVkIGJ5IHBvc3RncmVzLiBJZiBpbmRleCBpcyBpbmhlcml0ZWQsIGV4Y2x1ZGUgaXQK KyAgICAgICAgICAgICMgZnJvbSBtYWluIHNxbAorICAgICAgICAgICAgaWYgJ2lzX2luaGVyaXRl ZCcgaW4gcm93IGFuZCByb3dbJ2lzX2luaGVyaXRlZCddIGlzIFRydWU6CisgICAgICAgICAgICAg ICAgY29udGludWUKKwogICAgICAgICAgICAgaW5kZXhfc3FsID0gaW5kZXhfdXRpbHMuZ2V0X3Jl dmVyc2VfZW5naW5lZXJlZF9zcWwoCiAgICAgICAgICAgICAgICAgc2VsZi5jb25uLCBzY2hlbWE9 c2NoZW1hLCB0YWJsZT10YWJsZSwgZGlkPWRpZCwgdGlkPXRpZCwKICAgICAgICAgICAgICAgICBp ZHg9cm93WydvaWQnXSwgZGF0bGFzdHN5c29pZD1zZWxmLmRhdGxhc3RzeXNvaWQsCkBAIC05NDMs NiArOTQ5LDEwIEBAIGNsYXNzIEJhc2VUYWJsZVZpZXcoUEdDaGlsZE5vZGVWaWV3LCBCYXNlUGFy dGl0aW9uVGFibGUsIFZhY3V1bVNldHRpbmdzKToKICAgICAgICAgICAgICAgICAjIEFkZCBpbnRv IHBhcnRpdGlvbiBzcWwgdG8gcGFydGl0aW9uIGFycmF5CiAgICAgICAgICAgICAgICAgcGFydGl0 aW9uX3NxbF9hcnIuYXBwZW5kKHBhcnRpdGlvbl9tYWluX3NxbCkKIAorICAgICAgICAgICAgICAg ICMgR2V0IFJldmVyc2UgZW5naW5lZXJlZCBzcWwgZm9yIGluZGV4CisgICAgICAgICAgICAgICAg c2VsZi5fZ2V0X3Jlc3FsX2Zvcl9pbmRleChkaWQsIHJvd1snb2lkJ10sIHBhcnRpdGlvbl9zcWxf YXJyLAorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAganNvbl9yZXNw LCBzY2hlbWEsIHRhYmxlKQorCiAgICAgICAgICAgICAgICAgIyBHZXQgUmV2ZXJzZSBlbmdpbmVl cmVkIHNxbCBmb3IgUk9XIFNFQ1VSSVRZIFBPTElDWQogICAgICAgICAgICAgICAgIHNlbGYuX2dl dF9yZXNxbF9mb3Jfcm93X3NlY3VyaXR5X3BvbGljeShzY2lkLCByb3dbJ29pZCddLAogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBqc29uX3Jl c3AsCg== --0000000000005cbc1e05c0e17f37--