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 1kwMat-0007kX-Vl for pgadmin-hackers@arkaria.postgresql.org; Mon, 04 Jan 2021 09:56:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kwMas-0002Rp-UX for pgadmin-hackers@arkaria.postgresql.org; Mon, 04 Jan 2021 09:56:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kwMas-0002Rh-Cp for pgadmin-hackers@lists.postgresql.org; Mon, 04 Jan 2021 09:56:06 +0000 Received: from mail-il1-x134.google.com ([2607:f8b0:4864:20::134]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kwMao-0008I1-CW for pgadmin-hackers@postgresql.org; Mon, 04 Jan 2021 09:56:05 +0000 Received: by mail-il1-x134.google.com with SMTP id e7so21027294ile.7 for ; Mon, 04 Jan 2021 01:56:02 -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=cgRNqNNoOBhSixqeYyaw5GcUsQlQQ1cke6R75KcGzn8=; b=EX+zz6mDAn+iiyGjZ5vGO+6UR4DFE+Op/DfdJzXi6efttGSfdnOi81N9L7j+L/7npR m/K/Bsgif0c70iKuynoqCwqkOPWbN5upZVEBdAwGjoq2hOaNMKiAYRd9dI5gW/LnN11f rjhu3siZ8b+ffxTAhHNJJUxrkgUYS8hKSf3HyagmukKHL4FI0UEQAqyyYEoifrMrHvoO PMB3580Q45cs3c9YUkZJVECc/Ybc7JXtJuE5Axr8L7AJyOxW5uDa61u0odGgaLSXgsEC yQSrVGFpuf1ZbMxehBhEt1Lqw1mdAT/l8LalG/DkeXQqznLW/GE3jzVqUp8lo8ASQUHI Mpvw== 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=cgRNqNNoOBhSixqeYyaw5GcUsQlQQ1cke6R75KcGzn8=; b=r1nRzyp8/PNuFLj9FvYdklPeZLk+ubfYTfk/c5CMLER6UC/JkhwLpLENnCzR7nG7SL tP+xOJ2Cnxj1DrPnvjA9Jm7RbCK7WZP5B8rGH+NXSP4ERDntRWuM6v/DAvEE5EmqrM8l 2spiQf6579sGq5E6Paxel6lGHOurCjMLWBnX7VDN1+kkYZy4o3MaATsAWfbMHJ+CMEuf BRbRsp0buLu2yIcPN63GEH7EBeLR1NCqrKLcufVI0W2FJLxAbnUD2QHv/xxSMptL7vnX MgUot38IPjzmuUnliBkQhXGI0ljiZE47tYk2rYCFBg73y/CnpDAsySzOGP4DsCvaP86l bKbQ== X-Gm-Message-State: AOAM532flHowRO/eLzKEVHqMPSkhA33//LNJIAHvkF5dI0RzbIPTPrU/ dJRblJJ/xeZxI5SH0BT7Y7FLZ5XGPIm32XNgFAkMteKT7ZDo8M/9bON9/DAZkbWgoH2gjF6Eu0M ByAmOhqMz+PVCzTxmdisGaJZ9Cp7+gEbUScHi1Lyk4rSdFe1R+K/2RwOxi1RF7YjiWH2fDKLrIl H9gmI0dF3y+dvgtN2jiWRco71Dq9/u2g0zvAhWpgNHcKuUSggkB8gL1dkZ3w== X-Google-Smtp-Source: ABdhPJyregtyanwOq8VwJK3gmWckULJKFDEOGYpkvc4PPynmvg+cEMDWhZiG7Qvcg+KhfueYjTCgiZe+MPWs6fdpsxk= X-Received: by 2002:a92:9a42:: with SMTP id t63mr69737838ili.176.1609754161603; Mon, 04 Jan 2021 01:56:01 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Mon, 4 Jan 2021 15:25:50 +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="000000000000fa7f2605b8101897" 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 --000000000000fa7f2605b8101897 Content-Type: text/plain; charset="UTF-8" Thanks, patch applied. On Fri, Jan 1, 2021 at 12:35 PM Aditya Toshniwal < aditya.toshniwal@enterprisedb.com> wrote: > Hi Hackers, > > The changes in CREATE TABLE sql were missed. Attached patch adds the > changes. > > On Thu, Dec 24, 2020 at 3:02 PM Akshay Joshi < > akshay.joshi@enterprisedb.com> wrote: > >> 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* >> > > > -- > 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* --000000000000fa7f2605b8101897 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, patch applied.

On Fri, Jan 1, 2021 at 12:35 PM Adit= ya Toshniwal <adity= a.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

The changes in CRE= ATE TABLE sql were missed. Attached=C2=A0patch adds the changes.

On Th= u, Dec 24, 2020 at 3:02 PM Akshay Joshi <akshay.joshi@enterprisedb.com> w= rote:
Thanks, patch applied.

On Thu, Dec 24, 2020 at 1:46 PM Aditya Toshn= iwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi,

Attached patch = fixes the failing RESQL test cases.

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

= On Wed, Dec 23, 2020 at 6:10 PM Aditya Toshniwal <aditya.toshniwal@enterpris= edb.com> wrote:
Hi Hackers,

Attached is the patch to add support fo= r expressions in exclusion constraints. This also fixes the SQL generated f= or existing expression based constraints also.
Docs updated and test cases = enhanced.

Please review.

--
<= div dir=3D"ltr">
Thanks,
Aditya Toshniwal
pgAdmin hacker=C2=A0| Sr. Software Engineer | edbpostgres.com
&quo= t;Don't Complain 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"


--
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

--000000000000fa7f2605b8101897--