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 1s9aKj-003Oqp-UF for pgsql-docs@arkaria.postgresql.org; Wed, 22 May 2024 00:59:59 +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 1s9aKi-00DQCc-1y for pgsql-docs@arkaria.postgresql.org; Wed, 22 May 2024 00:59:56 +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 1s9aKh-00DQCU-JA for pgsql-docs@lists.postgresql.org; Wed, 22 May 2024 00:59:55 +0000 Received: from mout-u-107.mailbox.org ([80.241.59.207]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s9aKZ-001NDv-M8 for pgsql-docs@lists.postgresql.org; Wed, 22 May 2024 00:59:54 +0000 Received: from smtp102.mailbox.org (smtp102.mailbox.org [10.196.197.102]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-107.mailbox.org (Postfix) with ESMTPS id 4VkXyP0RVdz9sWJ for ; Wed, 22 May 2024 02:59:41 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ewie.name; s=MBO0001; t=1716339581; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type; bh=2HgF5X6sOLO5bIY01MJdvQ5rTqfU1VdV6bZ1e1coNoY=; b=CYK9juf9ZcTAJLuzgJET+ZPlbsNy+iOj24+6hsHfj33Vjq0hha/7u6mDPQhr4T4MmaWvsd C9C5cY9eaKRWdzny3FVc9OvIMybodUnWrz0e6WsOQQ8XkeOuHPLnD6IK0p9TrQASR2iYNn Wp3TXuJrqnSh0PYxrziXpMxTdneQEDbD0BCaMVnTCY7HYAAi37wzOPgE15lnI8r4KkQWQS WK91pRIHFid9qY8gz0tIe79ubRcih/W8JvjEYwQ3VwBw+ZjaA2+RjGOoV/BOIIjAYZJ2Q9 DeXqCaWk0SbQxZyqvbLs9piqmS6p5ZR3vgb0dttXNJro77vlB6j/IZFAuiH3Xw== Date: Wed, 22 May 2024 02:59:37 +0200 From: Erik Wienhold To: pgsql-docs@lists.postgresql.org Subject: column_name of ALTER MATERIALIZED VIEW should only refer to an existing column Message-ID: <6880ca53-7961-4eeb-86d5-6bd05fc2027e@ewie.name> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="fclnfugu5dvcjlvt" Content-Disposition: inline List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --fclnfugu5dvcjlvt Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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. -- Erik --fclnfugu5dvcjlvt Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0001-doc-fix-column_name-parameter-in-ALTER-MATERIALIZED-.patch"