MIME-Version: 1.0
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Date: Wed, 6 Oct 2021 12:24:52 +0530
Message-ID: 
 <CAM9w-_nijDb7aVsamVnroUH9edmXaXi0En2Qtf8LOJD8=F-GUQ@mail.gmail.com>
Subject: [pgAdmin][patch] Partition node related fixes
To: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000a83f7505cda9a1e2"
Archived-At: 
 <https://www.postgresql.org/message-id/CAM9w-_nijDb7aVsamVnroUH9edmXaXi0En2Qtf8LOJD8%3DF-GUQ%40mail.gmail.com>
Precedence: bulk

--000000000000a83f7505cda9a1e2
Content-Type: multipart/alternative; boundary="000000000000a83f7105cda9a1e0"

--000000000000a83f7105cda9a1e0
Content-Type: text/plain; charset="UTF-8"

Hi Hackers,

Please review the attached patch which fixes:
1. Unable to create trigger for partition table. Fixes #6867.
2. Unable to create index, RLS policy, rules, triggers for partition. Fixes
#6868.

-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"

--000000000000a83f7105cda9a1e0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,=
sans-serif">Hi Hackers,</div><div class=3D"gmail_default" style=3D"font-fam=
ily:verdana,sans-serif"><br></div><div class=3D"gmail_default" style=3D""><=
font face=3D"verdana, sans-serif">Please review the attached patch which fi=
xes:<br>1. Unable to create trigger for partition table. Fixes #6867.<br>2.=
 Unable to create index, RLS policy, rules, triggers for partition. Fixes #=
6868.</font><span style=3D"font-family:&quot;Trebuchet MS&quot;,Verdana,san=
s-serif;background-color:rgb(255,255,221);color:rgb(85,85,85);font-size:16p=
x"></span><br></div><div><div class=3D"gmail_default" style=3D"font-family:=
verdana,sans-serif"></div><br></div>-- <br><div dir=3D"ltr" class=3D"gmail_=
signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div dir=3D"=
ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div><font size=3D"=
2" color=3D"#000000" face=3D"arial, sans-serif">Thanks,</font><div><span st=
yle=3D"color:rgb(34,34,34)"><span style=3D"color:rgb(18,22,70)"><font face=
=3D"arial, sans-serif">Aditya Toshniwal</font></span></span><font size=3D"2=
" color=3D"#000000" face=3D"verdana, sans-serif"><br></font></div><div><spa=
n style=3D"color:rgb(18,22,70);font-family:Arial,sans-serif">pgAdmin Hacker=
</span><font size=3D"2" color=3D"#000000" style=3D"font-family:verdana,sans=
-serif">=C2=A0| </font><font size=3D"2" color=3D"#000000" face=3D"arial, sa=
ns-serif">Software Architect</font><font size=3D"2" color=3D"#000000"><font=
 face=3D"verdana, sans-serif">=C2=A0| </font><a href=3D"http://edbpostgres.=
com" target=3D"_blank"><font face=3D"arial, sans-serif" color=3D"#000000"><=
b>edbpostgres.com</b></font></a></font></div><div><font color=3D"#38761d" s=
ize=3D"1"><font face=3D"arial, sans-serif">&quot;Don&#39;t Complain about H=
eat, Plant a TREE&quot;</font></font></div></div></div></div></div></div></=
div></div></div>

--000000000000a83f7105cda9a1e0--

--000000000000a83f7505cda9a1e2
Content-Type: application/octet-stream; name="RM6867_6868.patch"
Content-Disposition: attachment; filename="RM6867_6868.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_kuf5okr40>
X-Attachment-Id: f_kuf5okr40

ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh
dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9pbmRleGVzL3N0YXRpYy9qcy9pbmRleC51aS5qcyBiL3dl
Yi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFz
L3RhYmxlcy9pbmRleGVzL3N0YXRpYy9qcy9pbmRleC51aS5qcwppbmRleCA5YzFiMjBhZDkuLjcz
ZjhlZGEyMiAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3Nl
cnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL2luZGV4ZXMvc3RhdGljL2pzL2luZGV4LnVp
LmpzCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFi
YXNlcy9zY2hlbWFzL3RhYmxlcy9pbmRleGVzL3N0YXRpYy9qcy9pbmRleC51aS5qcwpAQCAtMTgs
OCArMTgsOCBAQCBleHBvcnQgZnVuY3Rpb24gZ2V0Q29sdW1uU2NoZW1hKG5vZGVPYmosIHRyZWVO
b2RlSW5mbywgaXRlbU5vZGVEYXRhKSB7CiAgIHJldHVybiBuZXcgQ29sdW1uU2NoZW1hKAogICAg
IHsKICAgICAgIGNvbHVtbkxpc3Q6ICgpPT5nZXROb2RlTGlzdEJ5TmFtZSgnY29sdW1uJywgdHJl
ZU5vZGVJbmZvLCBpdGVtTm9kZURhdGEsIHt9KSwKLSAgICAgIGNvbGxhdGlvbkxpc3Q6ICgpPT5n
ZXROb2RlQWpheE9wdGlvbnMoJ2dldF9jb2xsYXRpb25zJywgbm9kZU9iaiwgdHJlZU5vZGVJbmZv
LCBpdGVtTm9kZURhdGEpLAotICAgICAgb3BDbGFzc0xpc3Q6ICgpPT5nZXROb2RlQWpheE9wdGlv
bnMoJ2dldF9vcF9jbGFzcycsIG5vZGVPYmosIHRyZWVOb2RlSW5mbywgaXRlbU5vZGVEYXRhKQor
ICAgICAgY29sbGF0aW9uTGlzdDogKCk9PmdldE5vZGVBamF4T3B0aW9ucygnZ2V0X2NvbGxhdGlv
bnMnLCBub2RlT2JqLCB0cmVlTm9kZUluZm8sIGl0ZW1Ob2RlRGF0YSwge2p1bXBBZnRlck5vZGU6
ICdzY2hlbWEnfSksCisgICAgICBvcENsYXNzTGlzdDogKCk9PmdldE5vZGVBamF4T3B0aW9ucygn
Z2V0X29wX2NsYXNzJywgbm9kZU9iaiwgdHJlZU5vZGVJbmZvLCBpdGVtTm9kZURhdGEsIHtqdW1w
QWZ0ZXJOb2RlOiAnc2NoZW1hJ30pCiAgICAgfSwgewogICAgICAgbm9kZV9pbmZvOiB0cmVlTm9k
ZUluZm8KICAgICB9CkBAIC00ODEsNCArNDgxLDQgQEAgZXhwb3J0IGRlZmF1bHQgY2xhc3MgSW5k
ZXhTY2hlbWEgZXh0ZW5kcyBCYXNlVUlTY2hlbWEgewogICAgIH0KICAgICByZXR1cm4gbnVsbDsK
ICAgfQotfQpcIE5vIG5ld2xpbmUgYXQgZW5kIG9mIGZpbGUKK30KZGlmZiAtLWdpdCBhL3dlYi9w
Z2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3Rh
Ymxlcy90cmlnZ2Vycy9zdGF0aWMvanMvdHJpZ2dlci5qcyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIv
c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90cmlnZ2Vycy9z
dGF0aWMvanMvdHJpZ2dlci5qcwppbmRleCAyMDY3Y2UyNjcuLjZkMGE4ZGI4YyAxMDA2NDQKLS0t
IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3Nj
aGVtYXMvdGFibGVzL3RyaWdnZXJzL3N0YXRpYy9qcy90cmlnZ2VyLmpzCisrKyBiL3dlYi9wZ2Fk
bWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxl
cy90cmlnZ2Vycy9zdGF0aWMvanMvdHJpZ2dlci5qcwpAQCAtMTc4LDcgKzE3OCw3IEBAIGRlZmlu
ZSgncGdhZG1pbi5ub2RlLnRyaWdnZXInLCBbCiAgICAgICBnZXRTY2hlbWE6IGZ1bmN0aW9uKHRy
ZWVOb2RlSW5mbywgaXRlbU5vZGVEYXRhKSB7CiAgICAgICAgIHJldHVybiBuZXcgVHJpZ2dlclNj
aGVtYSgKICAgICAgICAgICB7Ci0gICAgICAgICAgICB0cmlnZ2VyRnVuY3Rpb246ICgpPT5nZXRO
b2RlQWpheE9wdGlvbnMoJ2dldF90cmlnZ2VyZnVuY3Rpb25zJywgdGhpcywgdHJlZU5vZGVJbmZv
LCBpdGVtTm9kZURhdGEsIHtjYWNoZUxldmVsOiAndHJpZ2dlcl9mdW5jdGlvbid9LCAoZGF0YSkg
PT4geworICAgICAgICAgICAgdHJpZ2dlckZ1bmN0aW9uOiAoKT0+Z2V0Tm9kZUFqYXhPcHRpb25z
KCdnZXRfdHJpZ2dlcmZ1bmN0aW9ucycsIHRoaXMsIHRyZWVOb2RlSW5mbywgaXRlbU5vZGVEYXRh
LCB7Y2FjaGVMZXZlbDogJ3RyaWdnZXJfZnVuY3Rpb24nLCBqdW1wQWZ0ZXJOb2RlOiAnc2NoZW1h
J30sIChkYXRhKSA9PiB7CiAgICAgICAgICAgICAgIHJldHVybiBfLnJlamVjdChkYXRhLCBmdW5j
dGlvbihvcHRpb24pIHsKICAgICAgICAgICAgICAgICByZXR1cm4gb3B0aW9uLmxhYmVsID09ICcn
OwogICAgICAgICAgICAgICB9KTsKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc3Rh
dGljL2pzL25vZGVfdmlldy5qc3ggYi93ZWIvcGdhZG1pbi9icm93c2VyL3N0YXRpYy9qcy9ub2Rl
X3ZpZXcuanN4CmluZGV4IGM5NDkyODY4OS4uZGYxZDhhMjQwIDEwMDY0NAotLS0gYS93ZWIvcGdh
ZG1pbi9icm93c2VyL3N0YXRpYy9qcy9ub2RlX3ZpZXcuanN4CisrKyBiL3dlYi9wZ2FkbWluL2Jy
b3dzZXIvc3RhdGljL2pzL25vZGVfdmlldy5qc3gKQEAgLTcwLDcgKzcwLDcgQEAgZXhwb3J0IGZ1
bmN0aW9uIGdldE5vZGVWaWV3KG5vZGVUeXBlLCB0cmVlTm9kZUluZm8sIGFjdGlvblR5cGUsIGl0
ZW1Ob2RlRGF0YSwgZm8KIAogICAvKiBDYWxsZWQgd2hlbiBzd2l0Y2hlZCB0byBTUUwgdGFiLCBw
cm9taXNlIHJlcXVpcmVkICovCiAgIGNvbnN0IGdldFNRTFZhbHVlID0gKGlzTmV3LCBjaGFuZ2Vk
RGF0YSk9PnsKLSAgICBjb25zdCBtc3FsVXJsID0gZ2VuZXJhdGVOb2RlVXJsLmNhbGwobm9kZU9i
aiwgdHJlZU5vZGVJbmZvLCAnbXNxbCcsIGl0ZW1Ob2RlRGF0YSwgIWlzTmV3LCBudWxsKTsKKyAg
ICBjb25zdCBtc3FsVXJsID0gZ2VuZXJhdGVOb2RlVXJsLmNhbGwobm9kZU9iaiwgdHJlZU5vZGVJ
bmZvLCAnbXNxbCcsIGl0ZW1Ob2RlRGF0YSwgIWlzTmV3LCBub2RlT2JqLnVybF9qdW1wX2FmdGVy
X25vZGUpOwogICAgIHJldHVybiBuZXcgUHJvbWlzZSgocmVzb2x2ZSwgcmVqZWN0KT0+ewogICAg
ICAgYXBpKHsKICAgICAgICAgdXJsOiBtc3FsVXJsLAo=
--000000000000a83f7505cda9a1e2--