Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sX07G-000umA-Mt for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Jul 2024 15:10:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sX07E-00GB5l-FB for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Jul 2024 15:10:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sX07D-00GB5d-EK for pgsql-hackers@lists.postgresql.org; Thu, 25 Jul 2024 15:10:48 +0000 Received: from fhigh3-smtp.messagingengine.com ([103.168.172.154]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sX079-001ONX-FG for pgsql-hackers@postgresql.org; Thu, 25 Jul 2024 15:10:46 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.48]) by mailfhigh.nyi.internal (Postfix) with ESMTP id E5FCE1140154; Thu, 25 Jul 2024 11:10:40 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute7.internal (MEProxy); Thu, 25 Jul 2024 11:10:40 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ilmari.org; h=cc :cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1721920240; x=1722006640; bh=y3NLJ9ThmlEiTWNl0ZCjmTzvzE+uVrbTXo7PxBltML4=; b= mgNyf7xyQ2Dnx24F+1nZtNVBRutPqyfcQ/rt1MvurMiWN6G5Nyn5EfQcC2leGTuS /SYqgF8Ocn7wmbxpvw4n45x6PMQCgyb9ltazRiPI5f9OH+hA9i45naEzivuEee7p g2ROZZaj/IH3RhdNSpvDc3zVG51gv3dXQRSod6JGX7evt3KDgC+XcSOPYnotuqpY Of6Y4aHh3dsqdmJWSaEs/w7eHVlPpQkIKK2Kyro2qiZEQdpKIqmEiR7LvMu2v9SM vb1oyJE3RC+kQXMGGkETyuc4mHQ61AmhYKXVaM/NPOSWmT9aC5mnXl6GKiVTsHqj CssNLekoIV89XVjQB7g2dA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1721920240; x= 1722006640; bh=y3NLJ9ThmlEiTWNl0ZCjmTzvzE+uVrbTXo7PxBltML4=; b=M DXiV6a7HNrtpZsAP/0vo6GVOUwZuHiq21Bdjl55enTQ3NWFzJb27Q/p+nFyT/Tfu 0PFhnZnD+qW2QrXLuFzvYzVF6HGBSQK4N3OK7TvtqgQSQwl95APIoZ+jGKsrt9KU ByXemjBIQpxYlO2H11gQQkRpYBy84VaFRlsMhRTm0q10ijR0qVh49+P4XvGKPc1I 2S19rrEimFYRPlzKsJXSE1DsZmofG5JK8AVmkNd/bBAsYV39f6LsiUO7uyHYrbFN 9kTAz43kplB0W/NYCl57Ie7/4/CXyXViojPp7L/HnyjRK90IgNJk6Swr2KVZvsH3 ow2g24hpUEdSujyqU2d0w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrieefgdekhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefhvfevufhfffgjkfgfgggtgfesthekredttderjeenucfhrhhomhepffgrghhf ihhnnhcukfhlmhgrrhhiucforghnnhhsnohkvghruceoihhlmhgrrhhisehilhhmrghrih drohhrgheqnecuggftrfgrthhtvghrnhephfeuudduhefgffeijeehuedtleffledvledv hfeihfevkeejuddtleegfeejueelnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdroh hrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehi lhhmrghrihesihhlmhgrrhhirdhorhhgpdhnsggprhgtphhtthhopedt X-ME-Proxy: Feedback-ID: i1ff147bf:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 25 Jul 2024 11:10:39 -0400 (EDT) From: =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= To: Nathan Bossart Cc: px shi , pgsql-hackers@postgresql.org Subject: Re: CREATE MATERIALIZED VIEW References: <87cyn1eft4.fsf@wibble.ilmari.org> <87a5i5ef7e.fsf@wibble.ilmari.org> <877cd9edcx.fsf@wibble.ilmari.org> Date: Thu, 25 Jul 2024 16:10:37 +0100 In-Reply-To: (Nathan Bossart's message of "Thu, 25 Jul 2024 09:54:01 -0500") Message-ID: <874j8deccy.fsf@wibble.ilmari.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Nathan Bossart writes: > On Thu, Jul 25, 2024 at 03:49:02PM +0100, Dagfinn Ilmari Mannsåker wrote: >> Nathan Bossart writes: >>> However, since it looks like the feature was never actually supported in a >>> release, and the revert has been in place for over a decade, I think it'd >>> be reasonable to remove the tab completion now. It looks like the folks on >>> the 2021 thread felt similarly. >> >> Keeping it in the grammar makes sense for the more specific error >> message, but I don't think the tab completion should be suggesting bogus >> things, regardless of whether it's the grammar or the parse analysis >> that rejects it. > > Would you mind creating a commitfest entry for this one? I'll plan on > committing this early next week unless any objections materialize. Done: https://commitfest.postgresql.org/49/5139/ I've taken the liberty of setting you as the committer, and the target version to 17 even though it turns out to be an older bug, since it's arguably a follow-on fix to the incomplete fix in c951e9042dd1. - ilmari