MIME-Version: 1.0
From: Yogesh Mahajan <yogesh.mahajan@enterprisedb.com>
Date: Tue, 1 Dec 2020 11:04:09 +0530
Message-ID: 
 <CAMa=N=OfaK4h3m9sL0RNWx-AZ_dA13zJVxJM4KrTW-cBgr8s5A@mail.gmail.com>
Subject: [pgAdmin][Patch] Bug #5886 - New foreign key creation on exist table
To: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="0000000000000223ec05b5607c2a"
Precedence: bulk

--0000000000000223ec05b5607c2a
Content-Type: multipart/alternative; boundary="0000000000000223e905b5607c28"

--0000000000000223e905b5607c28
Content-Type: text/plain; charset="UTF-8"

Hi,

Please find the attached patch which fixes the false error shown while
adding a new foreign key from table dialogue in case of an already existing
foreign key with Auto FK Index=True to table.

Thanks,
Yogesh Mahajan
EnterpriseDB

--0000000000000223e905b5607c28
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;font-size:small">Hi,</div><div class=3D"gmail_default" style=3D"=
font-family:verdana,sans-serif;font-size:small"><br></div><div class=3D"gma=
il_default" style=3D"font-family:verdana,sans-serif;font-size:small">Please=
 find the attached patch which fixes the false error shown while adding a n=
ew foreign key from table dialogue in case of an already existing foreign k=
ey with Auto FK Index=3DTrue to table.</div><div class=3D"gmail_default" st=
yle=3D"font-family:verdana,sans-serif;font-size:small"><br></div><div><div =
dir=3D"ltr" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><font face=
=3D"verdana, sans-serif">Thanks,</font><div><font face=3D"verdana, sans-ser=
if">Yogesh Mahajan</font></div><div><font face=3D"verdana, sans-serif">Ente=
rpriseDB<br></font></div></div></div></div></div>

--0000000000000223e905b5607c28--

--0000000000000223ec05b5607c2a
Content-Type: application/x-patch; name="RM5886_v1.patch"
Content-Disposition: attachment; filename="RM5886_v1.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_ki4qtgpl0>
X-Attachment-Id: f_ki4qtgpl0

ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh
dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9mb3JlaWduX2tleS9zdGF0aWMvanMv
Zm9yZWlnbl9rZXkuanMgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVy
cy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29uc3RyYWludHMvZm9yZWlnbl9rZXkvc3RhdGlj
L2pzL2ZvcmVpZ25fa2V5LmpzCmluZGV4IDMwMjcyOGJhZC4uYTM2ZDM4NWFlIDEwMDY0NAotLS0g
YS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2No
ZW1hcy90YWJsZXMvY29uc3RyYWludHMvZm9yZWlnbl9rZXkvc3RhdGljL2pzL2ZvcmVpZ25fa2V5
LmpzCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFi
YXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9mb3JlaWduX2tleS9zdGF0aWMvanMvZm9y
ZWlnbl9rZXkuanMKQEAgLTEwOTcsMTEgKzEwOTcsMTMgQEAgZGVmaW5lKCdwZ2FkbWluLm5vZGUu
Zm9yZWlnbl9rZXknLCBbCiAKICAgICAgICAgICB2YXIgY292ZXJpbmdpbmRleCA9IHRoaXMuZ2V0
KCdjb3ZlcmluZ2luZGV4JyksCiAgICAgICAgICAgICBhdXRvaW5kZXggPSB0aGlzLmdldCgnYXV0
b2luZGV4Jyk7Ci0gICAgICAgICAgaWYgKGF1dG9pbmRleCAmJiAoXy5pc1VuZGVmaW5lZChjb3Zl
cmluZ2luZGV4KSB8fCBfLmlzTnVsbChjb3ZlcmluZ2luZGV4KSB8fAotICAgICAgICAgICAgICBT
dHJpbmcoY292ZXJpbmdpbmRleCkucmVwbGFjZSgvXlxzK3xccyskL2csICcnKSA9PSAnJykpIHsK
LSAgICAgICAgICAgIG1zZyA9IGdldHRleHQoJ1BsZWFzZSBzcGVjaWZ5IGNvdmVyaW5nIGluZGV4
IG5hbWUuJyk7Ci0gICAgICAgICAgICB0aGlzLmVycm9yTW9kZWwuc2V0KCdjb3ZlcmluZ2luZGV4
JywgbXNnKTsKLSAgICAgICAgICAgIHJldHVybiBtc2c7CisgICAgICAgICAgaWYgKHRoaXMuaXNO
ZXcoKSl7CisgICAgICAgICAgICBpZiAoYXV0b2luZGV4ICYmIChfLmlzVW5kZWZpbmVkKGNvdmVy
aW5naW5kZXgpIHx8IF8uaXNOdWxsKGNvdmVyaW5naW5kZXgpIHx8CisgICAgICAgICAgICAgICAg
U3RyaW5nKGNvdmVyaW5naW5kZXgpLnJlcGxhY2UoL15ccyt8XHMrJC9nLCAnJykgPT0gJycpKSB7
CisgICAgICAgICAgICAgIG1zZyA9IGdldHRleHQoJ1BsZWFzZSBzcGVjaWZ5IGNvdmVyaW5nIGlu
ZGV4IG5hbWUuJyk7CisgICAgICAgICAgICAgIHRoaXMuZXJyb3JNb2RlbC5zZXQoJ2NvdmVyaW5n
aW5kZXgnLCBtc2cpOworICAgICAgICAgICAgICByZXR1cm4gbXNnOworICAgICAgICAgICAgfQog
ICAgICAgICAgIH0KIAogICAgICAgICAgIHJldHVybiBudWxsOwo=
--0000000000000223ec05b5607c2a--