Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQ40F-0005PZ-8B for pgadmin-hackers@arkaria.postgresql.org; Tue, 05 Jun 2018 04:55:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQ40D-0002Oj-SO for pgadmin-hackers@arkaria.postgresql.org; Tue, 05 Jun 2018 04:55:25 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQ40D-0001uC-Jz for pgadmin-hackers@lists.postgresql.org; Tue, 05 Jun 2018 04:55:25 +0000 Received: from mail-lf0-x242.google.com ([2a00:1450:4010:c07::242]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fQ3qm-0002Lh-Sn for pgadmin-hackers@postgresql.org; Tue, 05 Jun 2018 04:46:02 +0000 Received: by mail-lf0-x242.google.com with SMTP id i83-v6so1367354lfh.5 for ; Mon, 04 Jun 2018 21:45:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=tbNC17kbWfb9Y7BWZHvrLwxsv7D4Fb3ylvApxBL+jF8=; b=FpvoGcRYntstPauF2S2sKJsCViZUt3bN6cZ85NYOdAaZHG+eqM5SlbTNWI2fcUafhS b2noNVk13gknjMJ4FGs9+o1A5IxjUiyyiZba8BWrzmhfdMm6aCMd62HAzFuTouSyZVTG 2ADDg+MU5iRd04LeHsvx74dY9ZEjbFBcSuTHxTfz04lueZ78Bjaz098xSb5AZLbupsS9 BLyxYfH6lOU+QR8DcY6G0X3cNpo4NqfSCq76N7nRslVZ3SVwL0WffsTN8INTt9OmameE j9PDQm0xHzilvuhdDexTWm2iLOsCqNpl5cJsSoBRqE3NSunYhMy4HecJd/L07bxpEfqo 3OjQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=tbNC17kbWfb9Y7BWZHvrLwxsv7D4Fb3ylvApxBL+jF8=; b=opMCebfRtnr+vlBnmwFATQJkDcUcp7m1JKjm0t2APh/V+Ta7TEwDlI5rsbZpsV1/4G O4gJAzATzgufbPLtsWPDi/70f9uQRyuXiQDdRQDiJ7mwOrQJj8fy68dkirDxQDCO6TJr tv6NmF0XbTIq9h9tehsIZyVyo1+myfMKzRy652JHoA3Jqg2hsXDkFAMZYP0CZMRhVP+l +9Dgs2H2KAFIqsgDW6vbtJ4UwAp2c/Pzab5PcTZwuAd87vh/2NNEE3xqTU9oWSpiZ+TV ymKwV3FZDmbXEI1BGjI4UqqRODJbV5MJhQl/++Is0lBrE0jAjUI5HPErGejwIb3ozWfP PKfg== X-Gm-Message-State: APt69E3YdBrD2Wu3dXyYG2/7WxofWI9EgUMmPDMlG5la5M3OuCsdyDHb EgraEFAkH2EtYDCsZoaQ0YC8I7/DtYVJcYJ9M+XGOw== X-Google-Smtp-Source: ADUXVKJTksYj4eIhG/SoakYQJpAwSPwOkHwnG59bRrccWHlL8TxJP67glcqwbETIwJhLDbwaKASjA7sBBl3q6ooSy08= X-Received: by 2002:a2e:f01:: with SMTP id 1-v6mr5643326ljp.47.1528173934044; Mon, 04 Jun 2018 21:45:34 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a2e:9e8a:0:0:0:0:0 with HTTP; Mon, 4 Jun 2018 21:45:33 -0700 (PDT) In-Reply-To: References: From: Aditya Toshniwal Date: Tue, 5 Jun 2018 10:15:33 +0530 Message-ID: Subject: Re: [pgAdmin4][RM#3289] Can't query SQL_ASCII database. To: Joao De Almeida Pereira Cc: Dave Page , pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000007e86b0056dddb8d3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000007e86b0056dddb8d3 Content-Type: text/plain; charset="UTF-8" Hi On Tue, Jun 5, 2018 at 1:08 AM, Joao De Almeida Pereira < jdealmeidapereira@pivotal.io> wrote: > Hello Aditya, > >> >> >> There is no change related to notifications in this patch. >> The below code is minor fix related to connection status of sql editor. >> Can you please share the code snippet if it is not the below. >> >> - # Check for the asynchronous notifies statements. >> - conn.check_notifies(True) >> - notifies = conn.get_notifies() >> + if status is not None: >> + # Check for the asynchronous notifies statements. >> + conn.check_notifies(True) >> + notifies = conn.get_notifies() >> >> > This is a minor fix, but is it related to querying SQL_ASCII database? > No its not. It is something I found when I was working on SQL_ASCII related changes. Well then, will send a separate patch for it. > > Thanks > Victoria && Joao > --0000000000007e86b0056dddb8d3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi

On Tue, Jun 5, 2018 at 1:08 AM, Joao De Almeida Pereira <jdea= lmeidapereira@pivotal.io> wrote:
Hello Aditya,


There is no change related to notifications in this patch.=C2=A0
The below code is minor fix related to connection status of sql edito= r. Can you please share the code snippet if it is not the below.
=
-=C2=A0 =C2=A0 =C2=A0 =C2=A0 # Check for the asynchrono= us notifies statements.
-=C2=A0 =C2=A0 =C2=A0 =C2=A0 conn.check_n= otifies(True)
-=C2=A0 =C2=A0 =C2=A0 =C2=A0 notifies =3D conn.get_= notifies()
+=C2=A0 =C2=A0 =C2=A0 =C2=A0 if status is not None:
+=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 # Check for the asynchro= nous notifies statements.
+=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 conn.check_notifies(True)
+=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 notifies =3D conn.get_notifies()


This is a minor fix, but is it relate= d to querying SQL_ASCII database?
No its= not. It is something I found when I was working on SQL_ASCII related chang= es.
Well then, will send a separate patch for it.

<= /div>
Thanks
Victoria && Joao

--0000000000007e86b0056dddb8d3--