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 1fhJ8p-0008Qf-3W for pgsql-pkg-debian@arkaria.postgresql.org; Sun, 22 Jul 2018 18:31:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fhJ8n-0008SL-NZ for pgsql-pkg-debian@arkaria.postgresql.org; Sun, 22 Jul 2018 18:31:33 +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 1fhJ8n-0008SD-Fb for pgsql-pkg-debian@lists.postgresql.org; Sun, 22 Jul 2018 18:31:33 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fhJ8j-0004HY-Jx for pgsql-pkg-debian@lists.postgresql.org; Sun, 22 Jul 2018 18:31:32 +0000 Received: from msg.df7cb.de (unknown [IPv6:2a02:908:147b:4ae0:76e5:bff:fef3:7e00]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 41YY9V4J29z3Dwy; Sun, 22 Jul 2018 20:31:26 +0200 (CEST) Date: Sun, 22 Jul 2018 20:31:26 +0200 From: Christoph Berg To: Adrien Nayrat Cc: pgsql-pkg-debian@lists.postgresql.org Subject: Re: Issue with postgres 11beta2 and powa on debian stretch amd64 Message-ID: <20180722183126.GA18253@msg.df7cb.de> References: <924f10ca-5d97-261e-8074-3763fbbe86c9@anayrat.info> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <924f10ca-5d97-261e-8074-3763fbbe86c9@anayrat.info> User-Agent: Mutt/1.10.0 (2018-05-17) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: Adrien Nayrat 2018-07-22 <924f10ca-5d97-261e-8074-3763fbbe86c9@anayrat.info> > Hello, > > I installed postgresql-11-powa on a fresh debian stretch amd64 with > postgresql-11 beta2 > > I got several errors "set-valued function called in context that cannot accept a > set" which should be fixed : Hi, this is caused by a change between PG11 beta1 and beta2 which causes several extensions to fail with that error message. Fixed by recompiling the postgresql-11-powa packages. > FYI, I do not have this error if I build powa from github's sources. So, I seems > it is a packing issue. Additionally, the testsuite was faulty in two ways, firstly it didn't depend on postgresql-server-dev-all so pg_buildext was not available which made the for-loop [1] a no-op, and secondly it didn't actually invoke any functions, so it wouldn't have spotted this problem anyway. (Now fixed in lines 11-14.) [1] https://github.com/powa-team/powa-archivist/blob/master/debian/tests/create-extension#L5 Thanks for spotting and reporting! Christoph