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 1ksMyy-0004w0-Ru for pgadmin-hackers@arkaria.postgresql.org; Thu, 24 Dec 2020 09:32:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ksMyx-0004V3-R6 for pgadmin-hackers@arkaria.postgresql.org; Thu, 24 Dec 2020 09:32:27 +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 ) id 1ksMyx-0004Uv-Fh for pgadmin-hackers@lists.postgresql.org; Thu, 24 Dec 2020 09:32:27 +0000 Received: from mail-il1-x12a.google.com ([2607:f8b0:4864:20::12a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ksMyu-0002Qr-8c for pgadmin-hackers@postgresql.org; Thu, 24 Dec 2020 09:32:26 +0000 Received: by mail-il1-x12a.google.com with SMTP id n9so1569860ili.0 for ; Thu, 24 Dec 2020 01:32:23 -0800 (PST) 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=xomJR7J2PF1OLgFHkmagxdk5ffHRzuS2y4GtLHL83hM=; b=yVsOaK6Vfz3Em9y9Uezk4aM6vuQaFjTPMahjk+ZDq9WxYIkPoD8HvSOvboVl33gZIM TCBZqeb0u71SOVN8w3izabS8bbx+HtA1Q9SP3xWDz31cNwWADRtGGDeuYZPFG7nXV2Ew k9Jg0rkl6vfwogn6MeFYmjXzuNsH90T4rX2dOk4MRJ+hZLZawaSgu1AE58Da7WxwjkkB zzIRNBzZleuclIoQC98XMjM+egQYHbI/l4JqfPYJmcVXByGMTkbp3ppJzleE2cOkGkZh j4v56MX1jZhWv+mIFJHkofHeSJ2aqt7N1rGjBjUS0C4+Oi0IIHFWy9GPPl2/9NMtmRTF oBvA== 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=xomJR7J2PF1OLgFHkmagxdk5ffHRzuS2y4GtLHL83hM=; b=Bn1LbL97GonLjtLtjaNQQ5nGA3gIJuA7DCVtx3dcEuNHKAhGDBZQQVie/+WnRpgVs+ KtL7241qLsorh4lIt+8Gi25uKKLpQamwz+H/tvN9PS0hL7GQu5q5UlCwjxtYTPkHRPCZ 6a5dWvSvyCF9Ek3R3ptRkLPW3arBuxqZ7NW1mjBYkuWttnv1melNrpzPKc/PNrTC9QLF QEdKBImK21UpFveF4PdQgxxVFumuewYpTcvkzd1mqwm8uTu743GmqWLNvT5cVf7g7bAm +J9AV0E2Dd0lDju1AbMwyAjPFM8GiWrK7gvdu9zJr4SWptjqntvY4qqR3qH7rk7DForP l2dQ== X-Gm-Message-State: AOAM531Jj6gADYalEoYPdksHe2ctasalA94FOtwiXUMl858UXACrGkZr gy2nVFX7A3DcizuSH6ldGCn842LsUuDKp/81iMS6Epy7MMK/YMLfISgxV5NkWJOfwO/8httjg23 EE5iDPQ/Pxunb6hphjFHld55mmhU+FtsH+9A/yijKLJtpp7R6JLCT4N+mzPtIkaSgpYixOEHyt9 aWLLXIXych/4dPRwstyTKUzazNU34DG7B1pEZznDpTqTDfqxmCAb+Mb5xIRQ== X-Google-Smtp-Source: ABdhPJxDhff7gcOm3CpuZ3poO8GMmDilXZEX0KMdFSaC7v0MkP5cRpM3q90JKA+jaWgnt07XFZ8VJIcwdz+q3Un/hXM= X-Received: by 2002:a92:9a42:: with SMTP id t63mr28803595ili.176.1608802342155; Thu, 24 Dec 2020 01:32:22 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Thu, 24 Dec 2020 15:02:11 +0530 Message-ID: Subject: Re: [pgAdmin][RM5571] Expression in exclusion constraint is misinterpreted and quoted as column name by mistake To: Aditya Toshniwal Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000001e4c9a05b7327cb5" 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: Precedence: bulk --0000000000001e4c9a05b7327cb5 Content-Type: text/plain; charset="UTF-8" Thanks, patch applied. On Thu, Dec 24, 2020 at 1:46 PM Aditya Toshniwal < aditya.toshniwal@enterprisedb.com> wrote: > Hi, > > Attached patch fixes the failing RESQL test cases. > > On Thu, Dec 24, 2020 at 1:15 PM Akshay Joshi < > akshay.joshi@enterprisedb.com> wrote: > >> Thanks, patch applied. >> >> On Wed, Dec 23, 2020 at 6:10 PM Aditya Toshniwal < >> aditya.toshniwal@enterprisedb.com> wrote: >> >>> Hi Hackers, >>> >>> Attached is the patch to add support for expressions in exclusion >>> constraints. This also fixes the SQL generated for existing expression >>> based constraints also. >>> Docs updated and test cases enhanced. >>> >>> Please review. >>> >>> -- >>> Thanks, >>> Aditya Toshniwal >>> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* >>> >>> "Don't Complain about Heat, Plant a TREE" >>> >> >> >> -- >> *Thanks & Regards* >> *Akshay Joshi* >> *pgAdmin Hacker | Principal Software Architect* >> *EDB Postgres * >> >> *Mobile: +91 976-788-8246* >> > > > -- > Thanks, > Aditya Toshniwal > pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* > > "Don't Complain about Heat, Plant a TREE" > -- *Thanks & Regards* *Akshay Joshi* *pgAdmin Hacker | Principal Software Architect* *EDB Postgres * *Mobile: +91 976-788-8246* --0000000000001e4c9a05b7327cb5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, patch applied.

On Thu, Dec 24, 2020 at 1:46 PM Adit= ya Toshniwal <adity= a.toshniwal@enterprisedb.com> wrote:
Hi,

Attached patch fixes the f= ailing RESQL test cases.

On Thu, Dec 24, 2020 at 1:15 PM Akshay Joshi = <aksh= ay.joshi@enterprisedb.com> wrote:
Thanks, patch applied.

<= div class=3D"gmail_quote">
On Wed, Dec= 23, 2020 at 6:10 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com= > wrote:
Hi Hackers,

Attached is the patch to add support for expressio= ns in exclusion constraints. This also fixes the SQL generated for existing= expression based constraints also.
Docs updated and test cases enhanced.
<= br>
Please review.

--
Thanks,
Aditya Toshniwal
pgAdmin hacker=C2=A0| Sr. Software Engineer | edbpostgres.com
"Don't Co= mplain about Heat, Plant a TREE"
=


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



--
Thanks,
Aditya Toshniwal=
pgAdmin hacker=C2=A0| Sr. Software Engineer | edbpostgres.com
&quo= t;Don't Complain about Heat, Plant a TREE"


--
Thanks & Regards
Akshay Joshi
pgAdmi= n Hacker | Principal Software Architect
EDB Postgres
Mobile: +91 976-788-8246

--0000000000001e4c9a05b7327cb5--