Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkoET-0000sF-Je for pgadmin-hackers@arkaria.postgresql.org; Tue, 09 Jul 2019 11:24:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hkoER-0004oG-Pk for pgadmin-hackers@arkaria.postgresql.org; Tue, 09 Jul 2019 11:24:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkoER-0004o8-64 for pgadmin-hackers@lists.postgresql.org; Tue, 09 Jul 2019 11:24:23 +0000 Received: from mail-wr1-x444.google.com ([2a00:1450:4864:20::444]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkoEO-0005fy-Dz for pgadmin-hackers@postgresql.org; Tue, 09 Jul 2019 11:24:22 +0000 Received: by mail-wr1-x444.google.com with SMTP id n9so11456304wrr.4 for ; Tue, 09 Jul 2019 04:24:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin.org; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=H6+CYm3xxJtWGr1ySSh6oiMTpIICWQuvfSHbUyyvoH0=; b=nmh7/54qA5l96fTeqU7HFCVddora41g+i0nZbc1ts015ZumZU0HNtZuTyPPEkqHCng wfd629iTTFYmk8C6FWmtBw3KLsX/Jl87aNH3oXopLtTKbzG5P938G0ZSPRho7b5GoX6v kUR7iPgmWFo3Aam47x1QcrEhtjQlYkboB9BicfZAPoN2GmLGiXZyFstFhUpzU0QlIb/4 YBaYwFmK7P1srunx/YH1Y6QNaukiqHmTJIeqKGIXUpVaC7GdfxWsH2M9NazEG7VoS+Ug 1y/rCFotbGHUMhzITqQpU3qyi1cyGOKO5MiV9pRH8gpZ4yPYLqHoa+xKKbgTXng947JQ NgCQ== 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=H6+CYm3xxJtWGr1ySSh6oiMTpIICWQuvfSHbUyyvoH0=; b=Ovcw6fy5Qrxd2l9a1RpH0FcsF78HP22Re3nYewHV05aTnVku6TyX1rgyck5hUHfMS9 lQojLZ/6XADQp0GyTsLhggc3oSvOfJQp5bpSyW5IDqA/6NPVFrFN1Ce8b9kcZ5giDHvc W4zO2NbqB52Fja2czzb2Qee30+cesXAfkI2FsVDh8KiTaC0YEtJn0t0PmQUBHaxjAJwZ nR1dJ93Ow7vjF++KY2yt/iiH/tIVvdP1qFruj+9p4uLyvhEF1o1xp//kF61dRb6r0ASY ltiKZIaSNsAbewdB4JTfzUJ8yMqQCVHX1dnBrO0gyWYyAzIRbS0rNZxfpt2iuBQXcWV/ o78g== X-Gm-Message-State: APjAAAUzf4oea++IuADIB9Ot6NLpGovpveaAC2boRGOZDat91hh6nOY9 LUUkE+LpsOgnjVCyFjCxK3skEXDv74soiG6NRONpCw== X-Google-Smtp-Source: APXvYqwdiHqCIUVeB5MDyIoIbLTmHa4uLID2385MTrmx1nodXFoL/SzQZXEtFRCLraZtbtJUg4HdMJpZGmotQGVH5yE= X-Received: by 2002:adf:e4c6:: with SMTP id v6mr6464117wrm.315.1562671458447; Tue, 09 Jul 2019 04:24:18 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dave Page Date: Tue, 9 Jul 2019 12:24:06 +0100 Message-ID: Subject: Re: RE-SQL test patch for extension node To: Nagesh Dhope Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000002e8731058d3dcdf8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000002e8731058d3dcdf8 Content-Type: text/plain; charset="UTF-8" Hi I have a sneaking suspicion that the work Akshay and Khushboo have been doing might have broken this :-( Create Extension with all options..............OK ... 2019-07-09 12:22:55,268: ERROR flask.app: Failed to execute query (execute_dict) for the server #5- DB:test_db_d08e5 (Query-id: 1400245): Error Message:ERROR: schema "test_extension_schema" does not exist Alter Extension version..............FAIL Traceback (most recent call last): File "/Users/dpage/git/pgadmin4/web/regression/re_sql/tests/test_resql.py", line 230, in execute_test_case self.assertEquals(response.status_code, 200) File "/opt/local/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/unittest/case.py", line 1338, in deprecated_func return original_func(*args, **kwargs) File "/opt/local/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/unittest/case.py", line 839, in assertEqual assertion_func(first, second, msg=msg) File "/opt/local/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/unittest/case.py", line 832, in _baseAssertEqual raise self.failureException(msg) AssertionError: 500 != 200 On Tue, Jul 9, 2019 at 6:16 AM Nagesh Dhope wrote: > Hi Dave, > > Please find updated patch with *sslinfo.* > > On Mon, Jul 8, 2019 at 2:03 PM Dave Page wrote: > >> Hi >> >> On Fri, Jul 5, 2019 at 5:16 PM Nagesh Dhope < >> nagesh.dhope@enterprisedb.com> wrote: >> >>> Hi Hackers, >>> Please review attached patch for RE-SQL test cases for *extension* >>> node. >>> >> >> Unfortunately this fails on PostgreSQL 12 as the deprecated timetravel >> contrib module has finally been removed. >> >> Perhaps use sslinfo? That seems less likely to go away anytime soon. >> >> Thanks. >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --0000000000002e8731058d3dcdf8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi

I have a sneaking suspicion that the= work Akshay and Khushboo have been doing might have broken this :-(=C2=A0<= /div>

Create Extension with all options..............OK<= br>=C2=A0... 2019-07-09 12:22:55,268: ERROR flask.app: Failed to execute qu= ery (execute_dict) for the server #5- DB:test_db_d08e5 (Query-id: 1400245):=
Error Message:ERROR: =C2=A0schema "test_extension_schema" doe= s not exist

Alter Extension version..............FAIL
Traceback (= most recent call last):
=C2=A0 File "/Users/dpage/git/pgadmin4/web/= regression/re_sql/tests/test_resql.py", line 230, in execute_test_case=
=C2=A0 =C2=A0 self.assertEquals(response.status_code, 200)
=C2=A0 Fi= le "/opt/local/Library/Frameworks/Python.framework/Versions/3.7/lib/py= thon3.7/unittest/case.py", line 1338, in deprecated_func
=C2=A0 =C2= =A0 return original_func(*args, **kwargs)
=C2=A0 File "/opt/local/L= ibrary/Frameworks/Python.framework/Versions/3.7/lib/python3.7/unittest/case= .py", line 839, in assertEqual
=C2=A0 =C2=A0 assertion_func(first, = second, msg=3Dmsg)
=C2=A0 File "/opt/local/Library/Frameworks/Pytho= n.framework/Versions/3.7/lib/python3.7/unittest/case.py", line 832, in= _baseAssertEqual
=C2=A0 =C2=A0 raise self.failureException(msg)
Asse= rtionError: 500 !=3D 200


On Tue, Jul 9, 2019 at 6:1= 6 AM Nagesh Dhope <nage= sh.dhope@enterprisedb.com> wrote:
Hi=C2=A0Dave,

= Please find updated patch with sslinfo.

On Mon, Jul 8, 2019 at = 2:03 PM Dave Page <dpage@pgadmin.org> wrote:
Hi

On Fri, Jul 5, 2019 = at 5:16 PM Nagesh Dhope <nagesh.dhope@enterprisedb.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft:1px solid rgb(204,204,204);padding-left:1ex">
Hi Hacker= s,
Please review attached patch for RE-SQL test cases for extension<= /b> node.=C2=A0

Unfortunately t= his fails on PostgreSQL 12 as the deprecated timetravel contrib module has = finally been removed.

Perhaps use sslinfo? That se= ems less likely to go away anytime soon.

Thanks.
=C2=A0
--
Dave Page
Blog: = http://pgsnake.bl= ogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com<= br>The Enterprise PostgreSQL Company


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @p= gsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL = Company
--0000000000002e8731058d3dcdf8--