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 1s9eHa-003y3b-RO for pgsql-docs@arkaria.postgresql.org; Wed, 22 May 2024 05:13:00 +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 1s9eHZ-00EBbb-Qp for pgsql-docs@arkaria.postgresql.org; Wed, 22 May 2024 05:12:57 +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 1s9eHY-00EBbS-O1 for pgsql-docs@lists.postgresql.org; Wed, 22 May 2024 05:12:57 +0000 Received: from fout3-smtp.messagingengine.com ([103.168.172.146]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s9eHR-001Olz-Bo for pgsql-docs@lists.postgresql.org; Wed, 22 May 2024 05:12:55 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.48]) by mailfout.nyi.internal (Postfix) with ESMTP id A41D1138011B; Wed, 22 May 2024 01:12:47 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute7.internal (MEProxy); Wed, 22 May 2024 01:12:47 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc: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=fm1; t=1716354767; x=1716441167; bh=HbEf1VSsSR cW2RvqRWFyKS9MXKavxgGMpxbWh1lC/rc=; b=UC7jVfRyaEwgFC7CDd3d/VnPhi 76+NPUHUzfzaqVNPZyD6cmMjc2gdgevvjDsB1+xwOKdi0r4ym7Rz0qEXorTP6jwh 0JWv8zRHaPWxCON4ivERUPxo1aikhiqEzUsAHgMIjvAG9rPU+8QG2Hyq5BsEdBwD BO/0OMBmUU9pGzLVxnqusRrBL3E8gZjVRMSrwDggxiJMTMdHwa3tOxbmp3l2iUKE WSNYlf3ehhBKtNvr0fxcQJyK82ieEAmh2KE0gcDjE4lpIJcTgQeewYrI8RW76Q4e M8WPgEKMxHe8/0pM0yPUUpvGKXdPUWsoxXjLA1Gw0ZDiPa46vMAToaG3+IAw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc: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= fm1; t=1716354767; x=1716441167; bh=HbEf1VSsSRcW2RvqRWFyKS9MXKav xgGMpxbWh1lC/rc=; b=RXgU9Ug33kdaxDIh6X2KDOtcbnb2RhhB7V/FDth36Aks FnwOZ9xXKSLNoFy0UqjRg7wRVgxiCJ/9LZT/Wkor/j8NI/cRWyLzITiOwWKEDimp tLmXFmmfy9/4GYv8l9SQs6PZp5kKQfqRYOrT2MmgeRt3qH1qIjxT1aKEPqTYijiT Ol3LydYf6sOQorvKMr6wQkjvS+gVf/TDEdtpo6oJm+FjhxH31rt+blNq/f5UwiwS ybCoUmvtbXJXfgmgMo9KBnlX5h+YDOy9E9HaQSezNkMNN9y9TpbHi9JO7Y+UQ3IA rb5AHuday7Nbd3FDvGTlaA5ADMs5Kk8oImo4Q+TaUA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrvdeifedgledtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 22 May 2024 01:12:46 -0400 (EDT) Date: Wed, 22 May 2024 14:12:36 +0900 From: Michael Paquier To: Erik Wienhold Cc: pgsql-docs@lists.postgresql.org Subject: Re: column_name of ALTER MATERIALIZED VIEW should only refer to an existing column Message-ID: References: <6880ca53-7961-4eeb-86d5-6bd05fc2027e@ewie.name> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="0BpQ5KQixLN/LBDn" Content-Disposition: inline In-Reply-To: <6880ca53-7961-4eeb-86d5-6bd05fc2027e@ewie.name> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0BpQ5KQixLN/LBDn Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, May 22, 2024 at 02:59:37AM +0200, Erik Wienhold wrote: > Here's a patch for $SUBJECT. Looks like the current wording was copied > from ALTER TABLE. In ALTER VIEW we correctly state that column_name > must be an existing column. Fun. You are right, none of the patterns supported by this query are able to add an attribute, so this new formulation makes sense. Will fix once we are out of release freeze time on HEAD. Thanks! -- Michael --0BpQ5KQixLN/LBDn Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmZNfsQACgkQnvQgOdby QH3sKQ/8DNAMWpFY9Wq+WcnJk5Zlb2rQjhmNyuuuDoNKNlCAnCUW6bV6Rat8Axh5 M40/9/brf4XlfFUwJUjyhW5UXeFzNhNylaVr3oc0W378cSVJjXcIalGO3aQE3GAd lrdmtmD4MoyhSx6zC6yuyFIzO4wAPRuRzrdauAZBoie6PWo9glsOgxgsx/olkTdd 0qM54hBC+TR0bewnTwBNTwFxfxTzpo48282m52kuwhdjCepxr7g5BHLqNBJrIHh0 EahMMqJAgdaU3LpEH5Is0P2B7opAWnu+Pe4rJpBR2PvlUqOgNz4bBtYlmBQbeMKt UE7uZ75ogqoQwmmPjLm/dzOviNnW4LiGsVlKu+xykbw2ZN0MN4JXOWlWI7XZ35QN GG/CZfltV08Qp1sHO4lC5XKKLWKMHdjyDjdTFHNetV7Ox330uGBl9d8rWDemNFJF lCkhspOo7CCakBa782o/kgGvmv/d7x2pEM3Iz90hDHOWMuAiD94hAkmxsMS7dg27 OMQJnONHyZxNpsrGMnBOTEOUpHvUz87OI8hnzccS74d7yM8kjnvCHktzuD8VARmn CEUSFi0MUN/1FBDpumZH4q9h1ymFNF1HPbx6QCzbtlVszuaYv4ksSHppEZn1gTSt IpRaMTkvlPP2ZaOLkc4hD10iQmPKyOShFikvkLNhmPTSbOFVv5g= =3yUO -----END PGP SIGNATURE----- --0BpQ5KQixLN/LBDn--