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 1gRWvY-0003jt-JF for pgsql-committers@arkaria.postgresql.org; Tue, 27 Nov 2018 06:32:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gRWvX-0004YY-02 for pgsql-committers@arkaria.postgresql.org; Tue, 27 Nov 2018 06:32:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gRWvV-0004YR-1C for pgsql-committers@lists.postgresql.org; Tue, 27 Nov 2018 06:32:54 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gRWvN-0004AY-7C for pgsql-committers@lists.postgresql.org; Tue, 27 Nov 2018 06:32:51 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id E6E84C82; Tue, 27 Nov 2018 01:32:29 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Tue, 27 Nov 2018 01:32:30 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=D/79YWvFgE9nl4AJ/0SoPxNTsTG KK14npFmW1Vgf3n0=; b=v3tMoKAN5J4iVevM4AVeEZLpnyHsHkcZeVz6CajWSmH LvOIxmQs1b21tJea8p/kymXgs3IKxyQqGGoG+oXTyn53HIhER/k9s4RdM8ImMZGq AFCZJw+vX9g+SL8PBebtXrC++zrlPjt3aBTI5xMD//+tLz37kK0rkvaMtMJ0kOmo arhZJjuIVxbPRX8ymWJ6HzPMrxD+HPOugRR4EFB9TAKr3dC0J2XPmzvVtuDqH34+ vyAnzgXMqU5hEPWbLScZuvI4CCzXUtQ3H2tC+WyzQqXYbN+eZOgvpb5av7/mWyKR kqEQ2+qc3ywNRkcGkd1hsh89kSgEjq+zTRmgh0YrwZA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=D/79YW vFgE9nl4AJ/0SoPxNTsTGKK14npFmW1Vgf3n0=; b=UK+u1UOiOgiRIB9+VMFB1N 7tWdGfTg0UADIYSk9V1ZuYH5oCGlG3OwyWzlp3Lq0sNks768dxO0lvRpBVCP4f9M wYc3s+yvlU+5gBwr0XH6Xs3Klxdo952O/fdbCkmYY5cRGmx8DWyR+DImGamvAXwA KEQlbnsZIj+3SSKNIZ6CF+AQWu/4coYsCeYlIU64iIQtJNnlejKF1pRhkEb3lJo8 rxu56ggW/gMvgRa13NsBNRzuLcNvweogM3TO1i8OPKx4yfZz88X0tEEhec8M5ssh ii3saNQRoAYvp+fdef/l8+YS7FCY1tfCAJRTXO4mESYoYz20S0EluKXqI6US8wWw == X-ME-Sender: X-ME-Proxy: Received: from intern.anarazel.de (c-98-210-140-171.hsd1.ca.comcast.net [98.210.140.171]) by mail.messagingengine.com (Postfix) with ESMTPA id B4973102F7; Tue, 27 Nov 2018 01:32:28 -0500 (EST) Date: Mon, 26 Nov 2018 22:32:26 -0800 From: Andres Freund To: Tom Lane Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Update pg_upgrade test for reg* to include regrole and regnamesp Message-ID: <20181127063226.mpyijg3jwrmmm3rr@alap3.anarazel.de> References: <8863.1543297423@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8863.1543297423@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On 2018-11-27 00:43:43 -0500, Tom Lane wrote: > Andres Freund writes: > > Update pg_upgrade test for reg* to include regrole and regnamespace. > > This has broken all the back-branch cross-version upgrade tests, Hm, darn it. Gotta rewrite the query to reference those new types without the regtype casts (as to_regtype without errors doesn't exist far enough back). Seems easier than having a version check for the different types. > to go along with the HEAD cases you already broke :-( The cross-version bug around pg_largeobject_metadata ought to be fixed now. I'm hoping for a response by Andrew about the ordering bit, you're welcome to opine on that too. I see that prairiedog https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=prairiedog&dt=2018-11-27%2005%3A30%3A39 failed just it's last run, but I'm not clear whether that's just a random failure, or something I can't don't recognize without further information. Greetings, Andres Freund