From: Arne Roland <A.Roland@index.de>
To: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Rename of triggers for partitioned tables
Thread-Topic: Rename of triggers for partitioned tables
Thread-Index: AQHWxEk1+rora/wutkWbcRQhC03q0A==
Date: Thu, 26 Nov 2020 23:28:31 +0000
Message-ID: <d0fd7040c2fb4de1a111b9d9ccc456b8@index.de>
Accept-Language: en-US, de-DE
Content-Language: en-US
Content-Type: multipart/mixed;
	boundary="_005_d0fd7040c2fb4de1a111b9d9ccc456b8indexde_"
MIME-Version: 1.0
Precedence: bulk

--_005_d0fd7040c2fb4de1a111b9d9ccc456b8indexde_
Content-Type: multipart/alternative;
	boundary="_000_d0fd7040c2fb4de1a111b9d9ccc456b8indexde_"

--_000_d0fd7040c2fb4de1a111b9d9ccc456b8indexde_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,


I got too annoyed at building queries for gexec all the time. So wrote a pa=
tch to fix the issue that the rename of partitioned trigger doesn't affect =
children.


In case there isn't a dependent trigger with the same name on the child the=
 function errors out. If the user touched the trigger of the child, it's no=
t a sensitive idea to mess with it.


I'm not happy with the interface change in trigger.h. Yet I don't like the =
idea of creating another layer of indirection either.


Even though it's a small patch, there might be other things I'm missing, so=
 I'd appreciate feedback.


Regards

Arne

--_000_d0fd7040c2fb4de1a111b9d9ccc456b8indexde_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi=
n-bottom:0;} --></style>
</head>
<body dir=3D"ltr">
<div id=3D"divtagdefaultwrapper" style=3D"font-size:12pt;color:#000000;font=
-family:Calibri,Arial,Helvetica,sans-serif;" dir=3D"ltr">
<p>Hello,</p>
<p><br>
</p>
<p>I got too annoyed at building queries for gexec all the time. So wrote a=
 patch to fix the issue that the rename of partitioned trigger doesn't affe=
ct children.</p>
<p><br>
</p>
<p>In case there isn't a dependent trigger with the same name on the child =
the function errors out. If the user touched the trigger of the child, it's=
 not a sensitive idea to mess with it.<br>
</p>
<p><br>
</p>
<p>I'm not happy with the interface change in <span>trigger.h</span>. Yet I=
 don't like the idea of creating another layer of indirection either.</p>
<p><br>
</p>
<p>Even though it's a small patch, there might be other things I'm missing,=
 so I'd appreciate feedback.</p>
<p><br>
</p>
<p>Regards</p>
<p>Arne<br>
</p>
</div>
</body>
</html>

--_000_d0fd7040c2fb4de1a111b9d9ccc456b8indexde_--

--_005_d0fd7040c2fb4de1a111b9d9ccc456b8indexde_
Content-Type: text/x-patch; name="recursive_tgrename.patch"
Content-Description: recursive_tgrename.patch
Content-Disposition: attachment; filename="recursive_tgrename.patch";
	size=7352; creation-date="Thu, 26 Nov 2020 23:09:36 GMT";
	modification-date="Thu, 26 Nov 2020 23:09:36 GMT"
Content-Transfer-Encoding: base64

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL2FsdGVyLmMgYi9zcmMvYmFja2VuZC9j
b21tYW5kcy9hbHRlci5jCmluZGV4IGIxMWViZjBmNjEuLmU5MmRhZTc4ZjcgMTAwNjQ0Ci0tLSBh
L3NyYy9iYWNrZW5kL2NvbW1hbmRzL2FsdGVyLmMKKysrIGIvc3JjL2JhY2tlbmQvY29tbWFuZHMv
YWx0ZXIuYwpAQCAtMzY1LDcgKzM2NSw3IEBAIEV4ZWNSZW5hbWVTdG10KFJlbmFtZVN0bXQgKnN0
bXQpCiAJCQkJCQkJCQkgc3RtdC0+bmV3bmFtZSk7CiAKIAkJY2FzZSBPQkpFQ1RfVFJJR0dFUjoK
LQkJCXJldHVybiByZW5hbWV0cmlnKHN0bXQpOworCQkJcmV0dXJuIHJlbmFtZXRyaWcoc3RtdCwg
MCwgMCk7CiAKIAkJY2FzZSBPQkpFQ1RfUE9MSUNZOgogCQkJcmV0dXJuIHJlbmFtZV9wb2xpY3ko
c3RtdCk7CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC9jb21tYW5kcy90cmlnZ2VyLmMgYi9zcmMv
YmFja2VuZC9jb21tYW5kcy90cmlnZ2VyLmMKaW5kZXggYzMzNmIyMzhhYS4uMDM5Mzg2OTU4YSAx
MDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvY29tbWFuZHMvdHJpZ2dlci5jCisrKyBiL3NyYy9iYWNr
ZW5kL2NvbW1hbmRzL3RyaWdnZXIuYwpAQCAtMTM1NywxMiArMTM1Nyw3IEBAIGdldF90cmlnZ2Vy
X29pZChPaWQgcmVsaWQsIGNvbnN0IGNoYXIgKnRyaWduYW1lLCBib29sIG1pc3Npbmdfb2spCiAJ
cmV0dXJuIG9pZDsKIH0KIAotLyoKLSAqIFBlcmZvcm0gcGVybWlzc2lvbnMgYW5kIGludGVncml0
eSBjaGVja3MgYmVmb3JlIGFjcXVpcmluZyBhIHJlbGF0aW9uIGxvY2suCi0gKi8KLXN0YXRpYyB2
b2lkCi1SYW5nZVZhckNhbGxiYWNrRm9yUmVuYW1lVHJpZ2dlcihjb25zdCBSYW5nZVZhciAqcnYs
IE9pZCByZWxpZCwgT2lkIG9sZHJlbGlkLAotCQkJCQkJCQkgdm9pZCAqYXJnKQorc3RhdGljIHZv
aWQgY2FsbGJhY2tGb3JSZW5hbWVUcmlnZ2VyKGNoYXIqIHJlbG5hbWUsIE9pZCByZWxpZCkKIHsK
IAlIZWFwVHVwbGUJdHVwbGU7CiAJRm9ybV9wZ19jbGFzcyBmb3JtOwpAQCAtMTM3OSwyMiArMTM3
NCwzMiBAQCBSYW5nZVZhckNhbGxiYWNrRm9yUmVuYW1lVHJpZ2dlcihjb25zdCBSYW5nZVZhciAq
cnYsIE9pZCByZWxpZCwgT2lkIG9sZHJlbGlkLAogCQllcmVwb3J0KEVSUk9SLAogCQkJCShlcnJj
b2RlKEVSUkNPREVfV1JPTkdfT0JKRUNUX1RZUEUpLAogCQkJCSBlcnJtc2coIlwiJXNcIiBpcyBu
b3QgYSB0YWJsZSwgdmlldywgb3IgZm9yZWlnbiB0YWJsZSIsCi0JCQkJCQlydi0+cmVsbmFtZSkp
KTsKKwkJCQkJCXJlbG5hbWUpKSk7CiAKIAkvKiB5b3UgbXVzdCBvd24gdGhlIHRhYmxlIHRvIHJl
bmFtZSBvbmUgb2YgaXRzIHRyaWdnZXJzICovCiAJaWYgKCFwZ19jbGFzc19vd25lcmNoZWNrKHJl
bGlkLCBHZXRVc2VySWQoKSkpCi0JCWFjbGNoZWNrX2Vycm9yKEFDTENIRUNLX05PVF9PV05FUiwg
Z2V0X3JlbGtpbmRfb2JqdHlwZShnZXRfcmVsX3JlbGtpbmQocmVsaWQpKSwgcnYtPnJlbG5hbWUp
OworCQlhY2xjaGVja19lcnJvcihBQ0xDSEVDS19OT1RfT1dORVIsIGdldF9yZWxraW5kX29ianR5
cGUoZ2V0X3JlbF9yZWxraW5kKHJlbGlkKSksIHJlbG5hbWUpOwogCWlmICghYWxsb3dTeXN0ZW1U
YWJsZU1vZHMgJiYgSXNTeXN0ZW1DbGFzcyhyZWxpZCwgZm9ybSkpCiAJCWVyZXBvcnQoRVJST1Is
CiAJCQkJKGVycmNvZGUoRVJSQ09ERV9JTlNVRkZJQ0lFTlRfUFJJVklMRUdFKSwKIAkJCQkgZXJy
bXNnKCJwZXJtaXNzaW9uIGRlbmllZDogXCIlc1wiIGlzIGEgc3lzdGVtIGNhdGFsb2ciLAotCQkJ
CQkJcnYtPnJlbG5hbWUpKSk7CisJCQkJCQlyZWxuYW1lKSkpOwogCiAJUmVsZWFzZVN5c0NhY2hl
KHR1cGxlKTsKIH0KIAogLyoKLSAqCQlyZW5hbWV0cmlnCQktIGNoYW5nZXMgdGhlIG5hbWUgb2Yg
YSB0cmlnZ2VyIG9uIGEgcmVsYXRpb24KKyAqIFBlcmZvcm0gcGVybWlzc2lvbnMgYW5kIGludGVn
cml0eSBjaGVja3MgYmVmb3JlIGFjcXVpcmluZyBhIHJlbGF0aW9uIGxvY2suCisgKi8KK3N0YXRp
YyB2b2lkCitSYW5nZVZhckNhbGxiYWNrRm9yUmVuYW1lVHJpZ2dlcihjb25zdCBSYW5nZVZhciAq
cnYsIE9pZCByZWxpZCwgT2lkIG9sZHJlbGlkLAorCQkJCQkJCQkgdm9pZCAqYXJnKQoreworCQlj
YWxsYmFja0ZvclJlbmFtZVRyaWdnZXIocnYtPnJlbG5hbWUsIHJlbGlkKTsKK30KKworLyoKKyAq
CQlyZW5hbWVvbmx5dHJpZwkJLSBjaGFuZ2VzIHRoZSBuYW1lIG9mIGEgdHJpZ2dlciBvbiBhIHJl
bGF0aW9uCiAgKgogICoJCXRyaWdnZXIgbmFtZSBpcyBjaGFuZ2VkIGluIHRyaWdnZXIgY2F0YWxv
Zy4KICAqCQlObyByZWNvcmQgb2YgdGhlIHByZXZpb3VzIG5hbWUgaXMga2VwdC4KQEAgLTE0MDcs
NDEgKzE0MTIsMjYgQEAgUmFuZ2VWYXJDYWxsYmFja0ZvclJlbmFtZVRyaWdnZXIoY29uc3QgUmFu
Z2VWYXIgKnJ2LCBPaWQgcmVsaWQsIE9pZCBvbGRyZWxpZCwKICAqCQl1cGRhdGUgcm93IGluIGNh
dGFsb2cKICAqLwogT2JqZWN0QWRkcmVzcwotcmVuYW1ldHJpZyhSZW5hbWVTdG10ICpzdG10KQor
cmVuYW1lb25seXRyaWcoUmVuYW1lU3RtdCAqc3RtdCwgUmVsYXRpb24gdGdyZWwsIE9pZCByZWxp
ZCwgT2lkIHRncGFyZW50KQogewogCU9pZAkJCXRnb2lkOwogCVJlbGF0aW9uCXRhcmdldHJlbDsK
LQlSZWxhdGlvbgl0Z3JlbDsKIAlIZWFwVHVwbGUJdHVwbGU7CiAJU3lzU2NhbkRlc2MgdGdzY2Fu
OwogCVNjYW5LZXlEYXRhIGtleVsyXTsKLQlPaWQJCQlyZWxpZDsKIAlPYmplY3RBZGRyZXNzIGFk
ZHJlc3M7CiAKLQkvKgotCSAqIExvb2sgdXAgbmFtZSwgY2hlY2sgcGVybWlzc2lvbnMsIGFuZCBh
Y3F1aXJlIGxvY2sgKHdoaWNoIHdlIHdpbGwgTk9UCi0JICogcmVsZWFzZSB1bnRpbCBlbmQgb2Yg
dHJhbnNhY3Rpb24pLgotCSAqLwotCXJlbGlkID0gUmFuZ2VWYXJHZXRSZWxpZEV4dGVuZGVkKHN0
bXQtPnJlbGF0aW9uLCBBY2Nlc3NFeGNsdXNpdmVMb2NrLAotCQkJCQkJCQkJIDAsCi0JCQkJCQkJ
CQkgUmFuZ2VWYXJDYWxsYmFja0ZvclJlbmFtZVRyaWdnZXIsCi0JCQkJCQkJCQkgTlVMTCk7CiAK
IAkvKiBIYXZlIGxvY2sgYWxyZWFkeSwgc28ganVzdCBuZWVkIHRvIGJ1aWxkIHJlbGNhY2hlIGVu
dHJ5LiAqLwogCXRhcmdldHJlbCA9IHJlbGF0aW9uX29wZW4ocmVsaWQsIE5vTG9jayk7CiAKKwog
CS8qCiAJICogU2NhbiBwZ190cmlnZ2VyIHR3aWNlIGZvciBleGlzdGluZyB0cmlnZ2VycyBvbiBy
ZWxhdGlvbi4gIFdlIGRvIHRoaXMgaW4KIAkgKiBvcmRlciB0byBlbnN1cmUgYSB0cmlnZ2VyIGRv
ZXMgbm90IGV4aXN0IHdpdGggbmV3bmFtZSAoVGhlIHVuaXF1ZSBpbmRleAogCSAqIG9uIHRncmVs
aWQvdGduYW1lIHdvdWxkIGNvbXBsYWluIGFueXdheSkgYW5kIHRvIGVuc3VyZSBhIHRyaWdnZXIg
ZG9lcwogCSAqIGV4aXN0IHdpdGggb2xkbmFtZS4KIAkgKgotCSAqIE5PVEUgdGhhdCB0aGlzIGlz
IGNvb2wgb25seSBiZWNhdXNlIHdlIGhhdmUgQWNjZXNzRXhjbHVzaXZlTG9jayBvbiB0aGUKLQkg
KiByZWxhdGlvbiwgc28gdGhlIHRyaWdnZXIgc2V0IHdvbid0IGJlIGNoYW5naW5nIHVuZGVybmVh
dGggdXMuCi0JICovCi0JdGdyZWwgPSB0YWJsZV9vcGVuKFRyaWdnZXJSZWxhdGlvbklkLCBSb3dF
eGNsdXNpdmVMb2NrKTsKLQotCS8qCiAJICogRmlyc3QgcGFzcyAtLSBsb29rIGZvciBuYW1lIGNv
bmZsaWN0CiAJICovCiAJU2NhbktleUluaXQoJmtleVswXSwKQEAgLTE0NzIsNiArMTQ2Miw3IEBA
IHJlbmFtZXRyaWcoUmVuYW1lU3RtdCAqc3RtdCkKIAkJCQlBbnVtX3BnX3RyaWdnZXJfdGduYW1l
LAogCQkJCUJURXF1YWxTdHJhdGVneU51bWJlciwgRl9OQU1FRVEsCiAJCQkJUG9pbnRlckdldERh
dHVtKHN0bXQtPnN1Ym5hbWUpKTsKKwogCXRnc2NhbiA9IHN5c3RhYmxlX2JlZ2luc2Nhbih0Z3Jl
bCwgVHJpZ2dlclJlbGlkTmFtZUluZGV4SWQsIHRydWUsCiAJCQkJCQkJCU5VTEwsIDIsIGtleSk7
CiAJaWYgKEhlYXBUdXBsZUlzVmFsaWQodHVwbGUgPSBzeXN0YWJsZV9nZXRuZXh0KHRnc2Nhbikp
KQpAQCAtMTQ4NCw3ICsxNDc1LDEyIEBAIHJlbmFtZXRyaWcoUmVuYW1lU3RtdCAqc3RtdCkKIAkJ
dHVwbGUgPSBoZWFwX2NvcHl0dXBsZSh0dXBsZSk7CS8qIG5lZWQgYSBtb2RpZmlhYmxlIGNvcHkg
Ki8KIAkJdHJpZ2Zvcm0gPSAoRm9ybV9wZ190cmlnZ2VyKSBHRVRTVFJVQ1QodHVwbGUpOwogCQl0
Z29pZCA9IHRyaWdmb3JtLT5vaWQ7Ci0KKwkJaWYgKHRncGFyZW50ICE9IDAgJiYgdGdwYXJlbnQg
IT0gdHJpZ2Zvcm0tPnRncGFyZW50aWQpIHsKKwkJCWVyZXBvcnQoRVJST1IsCisJCQkJCShlcnJj
b2RlKEVSUkNPREVfVU5ERUZJTkVEX09CSkVDVCksCisJCQkJCSBlcnJtc2coInRyaWdnZXIgXCIl
c1wiIGZvciB0YWJsZSBcIiVzXCIgaXMgbm90IGRlcGVuZGVudCBvbiB0aGUgdHJpZ2dlciBvbiBc
IiVzXCIiLAorCQkJCQkJCXN0bXQtPnN1Ym5hbWUsIFJlbGF0aW9uR2V0UmVsYXRpb25OYW1lKHRh
cmdldHJlbCksIHN0bXQtPnJlbGF0aW9uLT5yZWxuYW1lKSkpOworCQl9CiAJCW5hbWVzdHJjcHko
JnRyaWdmb3JtLT50Z25hbWUsCiAJCQkJICAgc3RtdC0+bmV3bmFtZSk7CiAKQEAgLTE1MjIsNiAr
MTUxOCw3MyBAQCByZW5hbWV0cmlnKFJlbmFtZVN0bXQgKnN0bXQpCiAJcmV0dXJuIGFkZHJlc3M7
CiB9CiAKKy8qCisgKgkJcmVuYW1ldHJpZwkJLSBjaGFuZ2VzIHRoZSBuYW1lIG9mIGEgdHJpZ2dl
ciBvbiBhIHBvc3NpYmx5IHBhcnRpdGlvbmVkIHJlbGF0aW9uIHJlY3VyaXN2ZWx5CisgKgorICoJ
CSAgYWx0ZXIgbmFtZSBvZiBwYXJlbnQgdHJpZ2dlciB1c2luZyByZW5hbWVvbmx5dHJpZworICoJ
CSAgcmVjdXJzaXZlIG92ZXIgY2hpbGRyZW4gYW5kIGNoYW5nZSB0aGVpciBuYW1lcyBpbiB0aGUg
c2FtZSBtYW5uZXIKKyAqCisgKi8KK09iamVjdEFkZHJlc3MKK3JlbmFtZXRyaWcoUmVuYW1lU3Rt
dCAqc3RtdCwgT2lkIHRnb2lkLCBPaWQgcmVsaWQpCit7CisKKwlSZWxhdGlvbgl0Z3JlbDsKKwlP
aWQJCSBuZXd0Z29pZDsKKwlPYmplY3RBZGRyZXNzICAgdGdhZGRyZXNzOworCS8qCisJICogTk9U
RSB0aGF0IHRoaXMgaXMgY29vbCBvbmx5IGJlY2F1c2Ugd2UgaGF2ZSBBY2Nlc3NFeGNsdXNpdmVM
b2NrIG9uIHRoZQorCSAqIHJlbGF0aW9uLCBzbyB0aGUgdHJpZ2dlciBzZXQgd29uJ3QgYmUgY2hh
bmdpbmcgdW5kZXJuZWF0aCB1cy4KKwkgKi8KKwl0Z3JlbCA9IHRhYmxlX29wZW4oVHJpZ2dlclJl
bGF0aW9uSWQsIFJvd0V4Y2x1c2l2ZUxvY2spOworCisJLyoKKwkgKiBMb29rIHVwIG5hbWUsIGNo
ZWNrIHBlcm1pc3Npb25zLCBhbmQgYWNxdWlyZSBsb2NrICh3aGljaCB3ZSB3aWxsIE5PVAorCSAq
IHJlbGVhc2UgdW50aWwgZW5kIG9mIHRyYW5zYWN0aW9uKS4KKwkgKiBJZiByZWxpZCBpcyBzZXQg
dGhlIGxhc3QgY2FsbCBvZiByZW5hbXRyaWcgYWxyZWFkeSBsb2NrZWQgdGhpcyByZWxhdGlvbi4K
KwkgKi8KKwlpZiAocmVsaWQgPT0gMCkgeworCQlyZWxpZCA9IFJhbmdlVmFyR2V0UmVsaWRFeHRl
bmRlZChzdG10LT5yZWxhdGlvbiwgQWNjZXNzRXhjbHVzaXZlTG9jaywKKwkJCQkJCQkJCQkgMCwK
KwkJCQkJCQkJCQkgUmFuZ2VWYXJDYWxsYmFja0ZvclJlbmFtZVRyaWdnZXIsCisJCQkJCQkJCQkJ
IE5VTEwpOworCX0gZWxzZSB7CisJCWNhbGxiYWNrRm9yUmVuYW1lVHJpZ2dlcihOVUxMLCByZWxp
ZCk7CisJCUxvY2tSZWxhdGlvbk9pZChyZWxpZCwgQWNjZXNzRXhjbHVzaXZlTG9jayk7CisJfQor
CXRnYWRkcmVzcyA9IHJlbmFtZW9ubHl0cmlnKHN0bXQsIHRncmVsLCByZWxpZCwgdGdvaWQpOwor
CW5ld3Rnb2lkID0gdGdhZGRyZXNzLm9iamVjdElkOworCisJIC8qCisJICogIEluIGNhc2Ugd2Ug
aGF2ZSBhIHBhcnRpb25lZCB0YWJsZSB3ZSB0cmF2ZXJzZSB0aGVtIGFuZCByZW5hbWUgZXZlcnkg
ZGVwZW5kZW5kIHN1YnRyaWdnZXIKKwkgKiBvZiB0aGUgc2FtZSBuYW1lIG9yIGVycm9yIG91dCBp
ZiBpdCBkb2Vzbid0IGV4aXN0LgorCSAqLworCSBpZiAoaGFzX3N1YmNsYXNzKHJlbGlkKSkKKwkg
eworCQkgTGlzdENlbGwgICAqY2hpbGQ7CisJCSBMaXN0CSAgICpjaGlsZHJlbjsKKyAKKwkJIC8q
IE1ha2Ugc3VyZSBpdCBzdGF5cyBhIGNoaWxkLiAqLworCQkgY2hpbGRyZW4gPSBmaW5kX2luaGVy
aXRhbmNlX2NoaWxkcmVuKHJlbGlkLCBBY2Nlc3NFeGNsdXNpdmVMb2NrKTsKKyAKKwkJIC8qCisJ
CSAgKiBmaW5kX2FsbF9pbmhlcml0b3JzIGRvZXMgdGhlIHJlY3Vyc2l2ZSBzZWFyY2ggb2YgdGhl
IGluaGVyaXRhbmNlCisJCSAgKiBoaWVyYXJjaHksIHNvIGFsbCB3ZSBoYXZlIHRvIGRvIGlzIHBy
b2Nlc3MgYWxsIG9mIHRoZSByZWxpZHMgaW4gdGhlCisJCSAgKiBsaXN0IHRoYXQgaXQgcmV0dXJu
cy4KKwkJICAqLworCQkgZm9yZWFjaChjaGlsZCwgY2hpbGRyZW4pCisJCSB7CisJCQkgT2lkCQkg
Y2hpbGRyZWxpZCA9IGxmaXJzdF9vaWQoY2hpbGQpOworIAorCQkJIGlmIChjaGlsZHJlbGlkID09
IHJlbGlkKQorCQkJCSBjb250aW51ZTsKKwkJCSByZW5hbWV0cmlnKHN0bXQsIG5ld3Rnb2lkLCBj
aGlsZHJlbGlkKTsKKwkJIH0KKwkgfQorCSByZXR1cm4gdGdhZGRyZXNzOworfQorCisKIAogLyoK
ICAqIEVuYWJsZURpc2FibGVUcmlnZ2VyKCkKZGlmZiAtLWdpdCBhL3NyYy9pbmNsdWRlL2NvbW1h
bmRzL3RyaWdnZXIuaCBiL3NyYy9pbmNsdWRlL2NvbW1hbmRzL3RyaWdnZXIuaAppbmRleCAyNDQ1
NDBkOTBiLi44ZThlYjk4ZWMwIDEwMDY0NAotLS0gYS9zcmMvaW5jbHVkZS9jb21tYW5kcy90cmln
Z2VyLmgKKysrIGIvc3JjL2luY2x1ZGUvY29tbWFuZHMvdHJpZ2dlci5oCkBAIC0xNTgsNyArMTU4
LDkgQEAgZXh0ZXJuIE9iamVjdEFkZHJlc3MgQ3JlYXRlVHJpZ2dlcihDcmVhdGVUcmlnU3RtdCAq
c3RtdCwgY29uc3QgY2hhciAqcXVlcnlTdHJpbmcKIGV4dGVybiB2b2lkIFJlbW92ZVRyaWdnZXJC
eUlkKE9pZCB0cmlnT2lkKTsKIGV4dGVybiBPaWQJZ2V0X3RyaWdnZXJfb2lkKE9pZCByZWxpZCwg
Y29uc3QgY2hhciAqbmFtZSwgYm9vbCBtaXNzaW5nX29rKTsKIAotZXh0ZXJuIE9iamVjdEFkZHJl
c3MgcmVuYW1ldHJpZyhSZW5hbWVTdG10ICpzdG10KTsKK2V4dGVybiBPYmplY3RBZGRyZXNzIHJl
bmFtZXRyaWcoUmVuYW1lU3RtdCAqc3RtdCwgT2lkIHRnb2lkLCBPaWQgcmVsaWQpOworCitleHRl
cm4gT2JqZWN0QWRkcmVzcyByZW5hbWVvbmx5dHJpZyhSZW5hbWVTdG10ICpzdG10LCBSZWxhdGlv
biB0Z3JlbCwgT2lkIHJlbGlkLCBPaWQgdGdwYXJlbnQpOwogCiBleHRlcm4gdm9pZCBFbmFibGVE
aXNhYmxlVHJpZ2dlcihSZWxhdGlvbiByZWwsIGNvbnN0IGNoYXIgKnRnbmFtZSwKIAkJCQkJCQkJ
IGNoYXIgZmlyZXNfd2hlbiwgYm9vbCBza2lwX3N5c3RlbSwgTE9DS01PREUgbG9ja21vZGUpOwo=

--_005_d0fd7040c2fb4de1a111b9d9ccc456b8indexde_
Content-Type: application/sql; name="partitioned_tgrename.sql"
Content-Description: partitioned_tgrename.sql
Content-Disposition: attachment; filename="partitioned_tgrename.sql";
	size=597; creation-date="Thu, 26 Nov 2020 23:11:57 GMT";
	modification-date="Thu, 26 Nov 2020 23:11:57 GMT"
Content-Transfer-Encoding: base64

Y3JlYXRlIHRhYmxlIHAgKGlkIGludCwKcHJpbWFyeSBrZXkgKGlkKSkKcGFydGl0aW9uIGJ5IHJh
bmdlIChpZCk7CmNyZWF0ZSB0YWJsZSBwYgpwYXJ0aXRpb24gb2YgcApmb3IgdmFsdWVzIGZyb20g
KDEpCnRvICgxMCkKcGFydGl0aW9uIGJ5IHJhbmdlIChpZCk7CmNyZWF0ZSB0YWJsZSBwMQpwYXJ0
aXRpb24gb2YgcGIKZm9yIHZhbHVlcyBmcm9tICgxKQp0byAoNSk7CmNyZWF0ZSBmdW5jdGlvbiBm
ICgpCnJldHVybnMgdHJpZ2dlciBhcyAKJCQgYmVnaW4KcmV0dXJuIG5ldzsKZW5kOyQkCmxhbmd1
YWdlIHBscGdzcWw7CmNyZWF0ZSB0cmlnZ2VyIGEKYWZ0ZXIgaW5zZXJ0ICBvbiBwCmZvciBlYWNo
IHJvdwpleGVjdXRlIHByb2NlZHVyZSBmKCk7CnNlbGVjdCB0Z3JlbGlkOjpyZWdjbGFzcywgKiBm
cm9tIHBnX3RyaWdnZXIgd2hlcmUgdGduYW1lID0gJ2EnOwoKYWx0ZXIgdHJpZ2dlciBhIG9uIHAg
cmVuYW1lIHRvIGI7CnNlbGVjdCB0Z3JlbGlkOjpyZWdjbGFzcywgKiBmcm9tIHBnX3RyaWdnZXIg
d2hlcmUgdGduYW1lID0gJ2EnOwpzZWxlY3QgdGdyZWxpZDo6cmVnY2xhc3MsICogZnJvbSBwZ190
cmlnZ2VyIHdoZXJlIHRnbmFtZSA9ICdiJzsK

--_005_d0fd7040c2fb4de1a111b9d9ccc456b8indexde_--