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 <pgadmin-hackers-owner+archive@lists.postgresql.org>)
	id 1jJ9ou-0007E2-03
	for pgadmin-hackers@arkaria.postgresql.org; Tue, 31 Mar 2020 05:52:16 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgadmin-hackers-owner+archive@lists.postgresql.org>)
	id 1jJ9or-0000j7-Rf
	for pgadmin-hackers@arkaria.postgresql.org; Tue, 31 Mar 2020 05:52:13 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <aditya.toshniwal@enterprisedb.com>)
	id 1jJ9or-0000j0-Fl
	for pgadmin-hackers@lists.postgresql.org; Tue, 31 Mar 2020 05:52:13 +0000
Received: from mail-ed1-x544.google.com ([2a00:1450:4864:20::544])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <aditya.toshniwal@enterprisedb.com>)
	id 1jJ9oj-0007Dr-Df
	for pgadmin-hackers@postgresql.org; Tue, 31 Mar 2020 05:52:12 +0000
Received: by mail-ed1-x544.google.com with SMTP id de14so23670437edb.4
        for <pgadmin-hackers@postgresql.org>;
 Mon, 30 Mar 2020 22:52:04 -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=jnMDIrMEaRbBdqG4GcQeOW1I/6Wox6XVsh22gGNY5OQ=;
        b=TCLodUrsbXPvRlY94zR3bUnmU8VnLQY7z4enDoBt2YBgvbVBkBv66WIeV2LVlcOtri
         RC9+niZAuemG6Kj8zyLnSO3k4lV1EPARw5sA0IXIHm8y94IvG76Dz4ZNplMicnWoUyND
         QipvtGmOLzXXrEdEOPFTVCjSWQ5E1UpWP2UaynI4ptITpI2zC2jxN1WHym98c0a4LWV3
         sOGizacdQJp/lgP/pPXeY2gDjUOmOlL5KKs1N5n20rq7ElsV/t2oOtk9p1P2lWp3IXX4
         7w3gFQ77YWPmBEiigj0gdKNuzF5WlIw6K9XMeTa8jHfFxv/9BF/AOqi5/qCer92z2tXj
         Ncwg==
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=jnMDIrMEaRbBdqG4GcQeOW1I/6Wox6XVsh22gGNY5OQ=;
        b=knKiPipoc3K6edqEY8k44nAHw7w1yt2SioXrW/OB3IOzaPojp9uYwaPMiUI7gX4E2x
         ZwBBpcWbLTEu4+Em75xyZaicCSuo0f70BzoQDImoryFCiW14H6LcshYActtbSFUfqM71
         lg/toCIr2DcHuIh5XuKnmYLkV/hnoqGWbrIbLesKigLo4W5CrY7ogPLbNtCag/wm/fE5
         UIb+wTrfORZIkLlNwTUHIXDcz0p/i2CGSvtdr0LgSUiCrHwlG5/n3l3tbjsQsGdowBVX
         ILDxFyJLNFSsBabtOJZtgzzeiMD6YIuDVOUMHyjlKAavYaiTiBnpVYeFvk5Qf6Ss2BYn
         NhYQ==
X-Gm-Message-State: ANhLgQ0RCuPnRgbUoh5+YdqmfBlXztBXwG4pzNnQmaOFBq6+ml6+tvwJ
	xgFKHX9lSGF1Up7oMITZKiWu3u144HbwPYrYl1CBoiuPw9rdJZYCZO0sCG7ZmTvs5EG4fUOASOA
	FgbkV1wRT4Z+2Dqqemr9MhItTIWMA+EPkPf6OL75Bn/tbulv/R2IfKiTpcradVW6wJzW5l1+DWi
	i8+SWTBTnDrU+Ed5ljITcx4gE8uB+XHl6/DGYG2KwxUdYgBOxNmAPaUgnT
X-Google-Smtp-Source: 
 ADFU+vtGXIQUi1nnwrxehC2BGR2qhqKPMOOIFqsfKssMl995uZGLw7QcsPrjZ7BK5BB8O+xSR9MluPfgdTeVPUjqcBk=
X-Received: by 2002:a17:906:360f:: with SMTP id
 q15mr13611646ejb.299.1585633924092;
 Mon, 30 Mar 2020 22:52:04 -0700 (PDT)
MIME-Version: 1.0
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Date: Tue, 31 Mar 2020 11:21:28 +0530
Message-ID: 
 <CAM9w-_nLi+a8E=5eXW98XbFHH1gmYBbjR8pJSphgjh5gkdvMTg@mail.gmail.com>
Subject: [pgAdmin][RM5268] Wrong SQL generated when we update FTS
 Configuration and FTS Dictionary
To: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000ca6f6e05a2202a5c"
X-CLOUD-SEC-AV-Info: edb,google_mail,monitor
X-CLOUD-SEC-AV-Sent: true
X-Gm-Spam: 0
X-Gm-Phishy: 0
List-Id: <pgadmin-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgadmin-hackers@lists.postgresql.org>
List-Owner: <mailto:pgadmin-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgadmin-hackers>
Precedence: bulk

--000000000000ca6f6e05a2202a5c
Content-Type: multipart/alternative; boundary="000000000000ca6f6c05a2202a5a"

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

Hi Hackers,

Attached is a tiny patch to fix SQL generated when any token in FTS
Configuration  or any option in FTS Dictionary is changed.

Please review.

-- 
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

--000000000000ca6f6c05a2202a5a
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"fon=
t-family:verdana,sans-serif">Attached is a tiny patch to fix SQL generated =
when any token in=C2=A0FTS Configuration=C2=A0 or any option in=C2=A0FTS Di=
ctionary is changed.</div><div class=3D"gmail_default" style=3D"font-family=
:verdana,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-f=
amily:verdana,sans-serif">Please review.</div><div><br></div>-- <br><div di=
r=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div=
 dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"l=
tr"><div><div dir=3D"ltr"><font size=3D"2" color=3D"#000000" face=3D"verdan=
a, sans-serif">Thanks and Regards,</font><div><span style=3D"background-col=
or:rgb(255,255,255)"><font size=3D"2" color=3D"#000000" face=3D"verdana, sa=
ns-serif">Aditya Toshniwal</font></span></div><div><font face=3D"verdana, s=
ans-serif"><span style=3D"background-color:rgb(255,255,255)"><font size=3D"=
2" color=3D"#000000">pgAdmin Hacker | Sr. Software Engineer |=C2=A0Enterpri=
seDB India |=C2=A0</font></span><span style=3D"color:rgb(0,0,0)">Pune</span=
></font></div><div><font color=3D"#38761d" face=3D"verdana, sans-serif" siz=
e=3D"1">&quot;Don&#39;t Complain about Heat, Plant a TREE&quot;</font></div=
></div></div></div></div></div></div></div></div></div></div></div>

--000000000000ca6f6c05a2202a5a--

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

ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh
dGFiYXNlcy9zY2hlbWFzL2Z0c19jb25maWd1cmF0aW9ucy9zdGF0aWMvanMvZnRzX2NvbmZpZ3Vy
YXRpb24uanMgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRh
YmFzZXMvc2NoZW1hcy9mdHNfY29uZmlndXJhdGlvbnMvc3RhdGljL2pzL2Z0c19jb25maWd1cmF0
aW9uLmpzCmluZGV4IGFiNDgzOGVhNS4uYmExM2Y0OThhIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1p
bi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdHNfY29u
ZmlndXJhdGlvbnMvc3RhdGljL2pzL2Z0c19jb25maWd1cmF0aW9uLmpzCisrKyBiL3dlYi9wZ2Fk
bWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z0c19j
b25maWd1cmF0aW9ucy9zdGF0aWMvanMvZnRzX2NvbmZpZ3VyYXRpb24uanMKQEAgLTE5LDYgKzE5
LDcgQEAgZGVmaW5lKCdwZ2FkbWluLm5vZGUuZnRzX2NvbmZpZ3VyYXRpb24nLCBbCiAKICAgLy8g
TW9kZWwgZm9yIHRva2VucyBjb250cm9sCiAgIHZhciBUb2tlbk1vZGVsID0gcGdBZG1pbi5Ccm93
c2VyLk5vZGUuTW9kZWwuZXh0ZW5kKHsKKyAgICBpZEF0dHJpYnV0ZTogJ3Rva2VuJywKICAgICBk
ZWZhdWx0czogewogICAgICAgdG9rZW46IHVuZGVmaW5lZCwKICAgICAgIGRpY3RuYW1lOiB1bmRl
ZmluZWQsCmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2Vy
dmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdHNfZGljdGlvbmFyaWVzL3N0YXRpYy9qcy9mdHNfZGlj
dGlvbmFyeS5qcyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh
dGFiYXNlcy9zY2hlbWFzL2Z0c19kaWN0aW9uYXJpZXMvc3RhdGljL2pzL2Z0c19kaWN0aW9uYXJ5
LmpzCmluZGV4IDkxZjFkMjNmYS4uMDg2NjZlODBjIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9i
cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdHNfZGljdGlv
bmFyaWVzL3N0YXRpYy9qcy9mdHNfZGljdGlvbmFyeS5qcworKysgYi93ZWIvcGdhZG1pbi9icm93
c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdHNfZGljdGlvbmFy
aWVzL3N0YXRpYy9qcy9mdHNfZGljdGlvbmFyeS5qcwpAQCAtMTksOCArMTksOSBAQCBkZWZpbmUo
J3BnYWRtaW4ubm9kZS5mdHNfZGljdGlvbmFyeScsIFsKIAogICAvLyBFeHRlbmQgdGhlIGJyb3dz
ZXIncyBub2RlIG1vZGVsIGNsYXNzIHRvIGNyZWF0ZSBhIG9wdGlvbi92YWx1ZSBwYWlyCiAgIHZh
ciBPcHRpb25MYWJlbE1vZGVsID0gcGdBZG1pbi5Ccm93c2VyLk5vZGUuTW9kZWwuZXh0ZW5kKHsK
KyAgICBpZEF0dHJpYnV0ZTogJ29wdGlvbicsCiAgICAgZGVmYXVsdHM6IHsKLSAgICAgIG9wdGlv
bnM6IHVuZGVmaW5lZCwKKyAgICAgIG9wdGlvbjogdW5kZWZpbmVkLAogICAgICAgdmFsdWU6IHVu
ZGVmaW5lZCwKICAgICB9LAogICAgIC8vIERlZmluZSB0aGUgc2NoZW1hIGZvciB0aGUgT3B0aW9u
cwo=
--000000000000ca6f6e05a2202a5c--