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 1ksLJ3-0008He-0U for pgadmin-hackers@arkaria.postgresql.org; Thu, 24 Dec 2020 07:45:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ksLJ1-0000FR-VM for pgadmin-hackers@arkaria.postgresql.org; Thu, 24 Dec 2020 07:45:03 +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 1ksLJ1-0000FI-Ls for pgadmin-hackers@lists.postgresql.org; Thu, 24 Dec 2020 07:45:03 +0000 Received: from mail-io1-xd35.google.com ([2607:f8b0:4864:20::d35]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ksLJ0-0001KH-1d for pgadmin-hackers@postgresql.org; Thu, 24 Dec 2020 07:45:03 +0000 Received: by mail-io1-xd35.google.com with SMTP id z5so1374232iob.11 for ; Wed, 23 Dec 2020 23:45:01 -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=oH+S04hGinjbj0z4zb4LEKWZIBjGP1omMc9jNyLWB6g=; b=Oee1Kw+9/84Wrg/yh4MRaXYQvq2zMOVRIAJD6ZgRAy+ZnLuWx1fCK6tLJ9a+rpMEbb RN29E4ZcO6SoWeq0Vquo7jahocKcDQWV2y/ZIQ1ORCVIDgOaCHnsM4oSUYrFoWd18ZIa PbkiJkWNtVrwwFGV+LLSGyYOOZLqVi2VUoumbi8aTLTEkL5N2ZOt3XaXQJn0pEzGc/88 HwN6TFyxcsco0fzZlGQoVhZC2ULLCMEf7D4MSywc+8+U6IPcJD1GThoA2cngJNS6xGXD SepvYyQpEr8JLuniJhXJOeO5j798IdWPWqjC1U+P7LuM1D9RJG14aiD+QACaM3+c+KZZ ubvw== 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=oH+S04hGinjbj0z4zb4LEKWZIBjGP1omMc9jNyLWB6g=; b=HdI6xEcNJLEaZUuOb6DdwL9KK2dumGcbWHQDZVn2j1q+0UFrmHitV2A9NDh+PhfgHK GPj5Lko0WAfRN/QCdLuwbd8IC+S/4mPrKcC0sHnORKmAm34z2KW5V5T9ORfHjhtTOw3m kEvkEVRdn6bi8HTmNEYY1aUntm4X0o5fteforlxiBa/3dmbMOJgzkI0j2bhaJAd9zKn/ G9jR4Rfp2fbdfNyMry+dLblLwx5yj+lIClWw1A9FIZ1DpM9PiD1yN2TToawX7iEWZpIa woSMEkapoi6cIP0ZZYLie0/ArUJ4OmThgTXQ8/Lcpi8Dz8mls9/Zd5EgSxFcHHA/PaHh 9MBA== X-Gm-Message-State: AOAM532KYtPOUkGXuMZODbvMd+eu5TQBkkZfjniXougK5amhWTFlZJtR bwLkV1ktKJNxHxbDXsvOM11ei1ba8mgChW1ra2NQJVR/LLWePsu2w/yj+RT6Mb/Cudjg7+9mOm6 g7HxaGdduZLdAUM8Hgj9a4q1s4m+ct8lf578E77t4AL0HSSP9jGPYahFoMMy3Z3fTHfhgPZPPl1 PjnVwa1nbewN+M8qeXwZFGMS3kqbR9/XAhL5W64MzF6wmXP1061SQENX3mWnAiKZg= X-Google-Smtp-Source: ABdhPJzzolI3yHjdqFE1VO9aA57k24wNBslQ8wdpqpzFHVmAGGiAtz8pLAtPHbXGeLCNs4ilxqA0fR0FKqLbsIsAOAo= X-Received: by 2002:a5d:958c:: with SMTP id a12mr24215487ioo.18.1608795900548; Wed, 23 Dec 2020 23:45:00 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Thu, 24 Dec 2020 13:14:49 +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="0000000000002b37b705b730fc94" 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 --0000000000002b37b705b730fc94 Content-Type: text/plain; charset="UTF-8" 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* --0000000000002b37b705b730fc94 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, patch applied.

On Wed, Dec 23, 2020 at 6:10 PM Adit= ya Toshniwal <adity= a.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

Attached is the pa= tch to add support for expressions in exclusion constraints. This also fixe= s the SQL generated for existing expression based constraints also.
Docs up= dated and test cases enhanced.

Please review.

-- <= br>
Thanks,
Adi= tya Toshniwal
pgAdmin hacker=C2=A0| <= font size=3D"2" color=3D"#000000" face=3D"arial, sans-serif">Sr. Software E= ngineer | edbpostgres.com
"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

--0000000000002b37b705b730fc94--