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 1fPvJv-0002mw-MD for pgadmin-hackers@arkaria.postgresql.org; Mon, 04 Jun 2018 19:39:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fPvJt-0003jj-Hu for pgadmin-hackers@arkaria.postgresql.org; Mon, 04 Jun 2018 19:39:09 +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 1fPvJt-0003jT-9K for pgadmin-hackers@lists.postgresql.org; Mon, 04 Jun 2018 19:39:09 +0000 Received: from mx0b-00296801.pphosted.com ([148.163.153.148]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fPvJo-00073r-Pl for pgadmin-hackers@postgresql.org; Mon, 04 Jun 2018 19:39:07 +0000 Received: from pps.filterd (m0114584.ppops.net [127.0.0.1]) by mx0b-00296801.pphosted.com (8.16.0.22/8.16.0.22) with SMTP id w54JaUuF006965 for ; Mon, 4 Jun 2018 19:39:02 GMT Received: from mail-io0-f197.google.com (mail-io0-f197.google.com [209.85.223.197]) by mx0b-00296801.pphosted.com with ESMTP id 2jbk0g2mxy-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Mon, 04 Jun 2018 19:39:02 +0000 Received: by mail-io0-f197.google.com with SMTP id 140-v6so184627iou.14 for ; Mon, 04 Jun 2018 12:39:01 -0700 (PDT) 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=JfH2YUo33QWEaMwLCcZ6QmL/MTUZtCpwCETFkVdXEas=; b=XXvc8USaGIpds4HOiraBxoky9WDZN8n6q+oCwArP9zQ9aLJ6QdZd8Z/FI30w51us7K EHqtP9wluoI3G09bYqGgHqBq9N1/WxXkrNHtI1gAsUd0XlSd++ZoiSku/pQLl2QhAPlO ZUhlr0FyY+iX8M5P305dvhkVaa50vRTe0J5MdoorR9tiQ2OfQogn6kXMLMUYsXRC4sTZ 4WIl5eRQnLMlMc/R7/eHHLvBLFgwge75JVZBnWC3knkN03n8N525Z2EiSZoycks+czvr vAo8/jecVir78gtzATSKXPT268tEBi4oAMnSqPSFyTXs0UyN7ruoh4c0rWlGHJr0dS7d MFSQ== X-Gm-Message-State: APt69E3wILEhPQbHBc7qZpbcmoulxHamvRwHSFA+5Rk1lgfc9LJGYYvk 0VyDpP3jij87xk+ncrpTUyp/cHMYI/qLABnM5JQlg8i+hrdFHtOafTSQFtpF8I6CB9uQo5AbUrd /EpFsPZYcUpPrpk0RFP5GUiigUj/dPs2eKXmgsQ4lulK0+fg4snKLpwMn8P0RIbNz0RHG X-Received: by 2002:a6b:a390:: with SMTP id m138-v6mr22635762ioe.116.1528141141380; Mon, 04 Jun 2018 12:39:01 -0700 (PDT) X-Google-Smtp-Source: ADUXVKIcCD0GSwDB15YIQzIsePnyJU3qKNgHyCbNm6ZBPDqa8Cshk6Y/2LAxwJaAlPuiy9CSE3SfQBOL9liWpTUWPM8= X-Received: by 2002:a6b:a390:: with SMTP id m138-v6mr22635750ioe.116.1528141141157; Mon, 04 Jun 2018 12:39:01 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Joao De Almeida Pereira Date: Mon, 4 Jun 2018 15:38:25 -0400 Message-ID: Subject: Re: [pgAdmin4][RM#3289] Can't query SQL_ASCII database. To: Aditya Toshniwal Cc: Dave Page , pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000e2dc24056dd61539" X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:,, definitions=2018-06-04_13:,, signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 priorityscore=1501 malwarescore=0 suspectscore=1 phishscore=0 bulkscore=0 spamscore=0 clxscore=1015 lowpriorityscore=0 mlxscore=0 impostorscore=0 mlxlogscore=800 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1805220000 definitions=main-1806040226 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000e2dc24056dd61539 Content-Type: text/plain; charset="UTF-8" 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? Thanks Victoria && Joao --000000000000e2dc24056dd61539 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Aditya,


There is no chang= e related to notifications in this patch.=C2=A0
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.

-= =C2=A0 =C2=A0 =C2=A0 =C2=A0 # Check for the asynchronous notifies statement= s.
-=C2=A0 =C2=A0 =C2=A0 =C2=A0 conn.check_notifies(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 asynchronous notifies state= ments.
+=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 conn.check_noti= fies(True)
+=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 notifies = =3D conn.get_notifies()

<= br>
This is a minor fix, but is it related to querying SQL_ASCII = database?

Thanks
Victoria && Joa= o
--000000000000e2dc24056dd61539--