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 1kNtX4-0002UH-Gi for pgadmin-hackers@arkaria.postgresql.org; Thu, 01 Oct 2020 08:01:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kNtX0-0006iq-MI for pgadmin-hackers@arkaria.postgresql.org; Thu, 01 Oct 2020 08:01:38 +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 1kNtX0-0006ig-Dg for pgadmin-hackers@lists.postgresql.org; Thu, 01 Oct 2020 08:01:38 +0000 Received: from mail-io1-xd41.google.com ([2607:f8b0:4864:20::d41]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kNtWx-0003FZ-Jk for pgadmin-hackers@postgresql.org; Thu, 01 Oct 2020 08:01:37 +0000 Received: by mail-io1-xd41.google.com with SMTP id u6so5613914iow.9 for ; Thu, 01 Oct 2020 01:01:35 -0700 (PDT) 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=Z6sXtNYioENQFHymPvaIdX+OfGG7t3PwZQZfZUZiU2I=; b=yLN2wRjJP37ccWS+IpRYW39q8F3cnPhrxKhHQ5qE7c9CNRSJ2Zcabdocwu1umlNEkt tNZ//2JpUSZnDMwBKUYY3V9S3cQMwMWcND7/XEiy+iGR/tG7OqgGkaOvtS13E0VFZVoF XO3Q58v9SYq8imC+ZqukYGhtNW4xQZFxCKqsJOzp5PbqniKQJz5Kz9fW0k08F9bss+cc skWYieQc0qCg9YmEFjeXmE8YxbZmawfAyyEvhzOKElnwSZuXvO5yE1WM+MFyPWIWhZVe T5LbK0hwxwbPr5SGxhuzrUQEEci7KlCGqOxpIlHKJBRhZz97RAOOtXdw1VYcm51R+jGe d4PQ== 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=Z6sXtNYioENQFHymPvaIdX+OfGG7t3PwZQZfZUZiU2I=; b=RlPZSPBU64+XXxWLpPoeS8eBM6+7t2q8bl0RqVjyYTsRXgLSS2dUVwcmpwSi89P/9d j6FSmr/GuMn8NqJzZ/IeLlQW7QJXe+YoirgKyvfEKp+PJbTs989PDT0ri8lKLkvauHvs /SAsJtW+WHBXVvmUcfc8LSVRpuNbwms7MJOohG+qgPu0b35pbg3qulBkjnuV3YpTfD15 jlbeptDFi4i/gqyW41rqmeLM1x/q7g/ng0qzpNHK0Ij2ZMfreXBT4JIcDZTQ8QUmyMVS 4Hj83sqsEapLuHSLI/vwpvqUT1FAdXVKwP/YHxuJxGEXzA0ho0NzzjtY41tD/2POQGj4 VHeg== X-Gm-Message-State: AOAM5325kFko26egwq8XaU7oRdxrFWwGGrShQdcpv3lR9Kz/U0QGWPGm W7MzK96gYYGWM5FTy/hKcNG17v16E19nqJzChAYuH3T7cWii7pgDHVVp4Z8Z4f73OSJWpRUJyfS D2TCp5sz3rGE39Zu7QU8gooI1X6C1cQAAMeiCqQ6hK09i7iy9G6f3s4C+hGpuWJga9ftVKiaKrj 8X9sxxstxnvcZJaY1V9LjjFZXL2EMXWX0REu1JQrBJRKVrrOQL3OythfXlHw== X-Google-Smtp-Source: ABdhPJwMUyUzfXPidMQHYscMgABedu9FsGY66SWk0K6+gUH4W8VAljWPwMswzYk2Sv6GcIuswu+LvpBWPgtLohZRaFE= X-Received: by 2002:a05:6638:240d:: with SMTP id z13mr5274322jat.7.1601539294395; Thu, 01 Oct 2020 01:01:34 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Thu, 1 Oct 2020 13:31:23 +0530 Message-ID: Subject: Re: [pgAdmin4][Patch] - Fix for Sqlalchemy Operational error To: Khushboo Vashi Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000bc9caf05b0976c26" 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 --000000000000bc9caf05b0976c26 Content-Type: text/plain; charset="UTF-8" Thanks, patch applied. On Wed, Sep 30, 2020 at 3:38 PM Khushboo Vashi < khushboo.vashi@enterprisedb.com> wrote: > Hi, > > Sqlalchemy gives an operational error with the SQL query with boolean > true/false for Python versions < 3.7. Please find the attached patch to fix > it. > > Thanks, > Khushboo > -- *Thanks & Regards* *Akshay Joshi* *pgAdmin Hacker | Sr. Software Architect* *EDB Postgres * *Mobile: +91 976-788-8246* --000000000000bc9caf05b0976c26 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, patch applied.

On Wed, Sep 30, 2020 at 3:38 PM Khus= hboo Vashi <khushboo.= vashi@enterprisedb.com> wrote:
Hi,

Sqlalchemy gi= ves an operational error with the SQL query with boolean true/false for Pyt= hon versions < 3.7. Please find the attached patch to fix it.
=
Thanks,
Khushboo


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