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 1sWzr6-000tNV-IF for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Jul 2024 14:54:08 +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 1sWzr5-00G3NT-2T for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Jul 2024 14:54:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sWzr4-00G3NK-P8 for pgsql-hackers@lists.postgresql.org; Thu, 25 Jul 2024 14:54:06 +0000 Received: from mail-il1-x134.google.com ([2607:f8b0:4864:20::134]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sWzr2-001Pgg-IF for pgsql-hackers@postgresql.org; Thu, 25 Jul 2024 14:54:06 +0000 Received: by mail-il1-x134.google.com with SMTP id e9e14a558f8ab-39834949f27so2648875ab.2 for ; Thu, 25 Jul 2024 07:54:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721919243; x=1722524043; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=NJFQG3+f19ZDOgYMe+j8ZzPJx6RXRck7HMdiauxfZik=; b=iwTqfJrZ8dp0bo9Rt8QCupxD5dHmt1LTUi1aQjExJbR57cKqdSHx0RAbK9bJNpsBdS 9xH2NnB0A/GjLg8e9JIWk4Xe8J8l2MD+Q0vtHah+r884ImiMeVYPgllBQUeU7eELbvRZ LUdedHguPGKIJP5sOcy5BDAPhXgz4yiTwb9cGNJjXc+l+ix36cytch2GIW9KMEiji5wL bZ+b1XBkzhYROqbElf++/L57D8BP3H4QBK/JGTTq72w+Id/vRfIy1b1NYBbA442IDA7G eRQValTBrhdAJJchqLKte32V+zNh2vRG7fF+93Pg2sZetPQpt6U16YmKzEM0fUF0V0BY 2u4A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721919243; x=1722524043; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=NJFQG3+f19ZDOgYMe+j8ZzPJx6RXRck7HMdiauxfZik=; b=FfE0+UzsMnShYGkZLIVLgbbe9t/PN54FhsTWynHoiz2EW1Ya004LFTYZT7APr5tD88 upB6dDZNOAEJcAZ2cD/0LvQ5DhyiOqIxrYe74u7JRuBmE/mAw4ndG1X/Iir8i2mPozqs honFUDHxDG/pg9J4Znwmbwg68CAELyt5l+KFkJZNMuNEOrq/yNNX5wA/jGvtrgo3DtuE WGcY5l7bM6MfccmhDx+noQotdOGNVhlCj31uMqRCQe7Et8yA0rAwTyA+Sdlp2MJjcE6h pPNtI37PFNAptcZdzrnpHUdUnsxjPbgFCooT5y1JajBHNuOSKzsnc2RUaPtrfCTtUWOP prDw== X-Forwarded-Encrypted: i=1; AJvYcCX2PXb8IxzyFCo3tqIUJ53qQXEkkOU9BApIcbd1Rz4XFTXD7eEpF/rIERb5DkHt/DvwBLyjhjwNXm76cIsTniQxhWWFprBB2JaHJtY4 X-Gm-Message-State: AOJu0Yw5M27T7xVGa+3zg7KrQ2nNwZQg5YuigRWM/N3PMQjPfmzRWQ84 refygVMUSjzK0MbY+9o4s+yRro1jEW+qv9jY4gpADT2hAZO8m/+/ X-Google-Smtp-Source: AGHT+IFSDE8/dkDwVq8Wcu5W/HwkWfw7CR7gfNxlfoQ+jdc5pIOfefirbDTNa8tvk32Ya74Bi7miXg== X-Received: by 2002:a05:6e02:1609:b0:397:980d:bb1b with SMTP id e9e14a558f8ab-39a217f5e0cmr43395045ab.7.1721919242841; Thu, 25 Jul 2024 07:54:02 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-39a22e7f3acsm6548355ab.14.2024.07.25.07.54.02 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 25 Jul 2024 07:54:02 -0700 (PDT) Date: Thu, 25 Jul 2024 09:54:01 -0500 From: Nathan Bossart To: Dagfinn Ilmari =?iso-8859-1?Q?Manns=E5ker?= Cc: px shi , pgsql-hackers@postgresql.org Subject: Re: CREATE MATERIALIZED VIEW Message-ID: References: <87cyn1eft4.fsf@wibble.ilmari.org> <87a5i5ef7e.fsf@wibble.ilmari.org> <877cd9edcx.fsf@wibble.ilmari.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <877cd9edcx.fsf@wibble.ilmari.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. -- nathan