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 <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1uXO2n-009FUO-3q
	for pgsql-bugs@arkaria.postgresql.org; Thu, 03 Jul 2025 17:48:21 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1uXO2k-00Euxb-VZ
	for pgsql-bugs@arkaria.postgresql.org; Thu, 03 Jul 2025 17:48:19 +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 <tgl@sss.pgh.pa.us>)
	id 1uXO2k-00EuxM-Mw
	for pgsql-bugs@lists.postgresql.org; Thu, 03 Jul 2025 17:48:19 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1uXO2j-005Ou0-2X
	for pgsql-bugs@lists.postgresql.org;
	Thu, 03 Jul 2025 17:48:18 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 563HmEGf4069865;
	Thu, 3 Jul 2025 13:48:14 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: jian he <jian.universality@gmail.com>
cc: Peter Eisentraut <peter@eisentraut.org>, exclusion@gmail.com,
        pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18970: Atempt to alter type of table column used in row type
 with check leads to assertion failure
In-reply-to: <3266569.1751399577@sss.pgh.pa.us>
References: <18970-a7d1cfe1f8d5d8d9@postgresql.org>
 <CACJufxGYBfGbOj3x0C0U-FsMR4K-gDEyxE6hjBJ870FnkDAO4w@mail.gmail.com>
 <2482012.1751216513@sss.pgh.pa.us> <2537374.1751218360@sss.pgh.pa.us>
 <CACJufxGKJtGNRRSXfwMW9SqVOPEMdP17BJ7DsBf=tNsv9pWU9g@mail.gmail.com>
 <2682232.1751250210@sss.pgh.pa.us>
 <CACJufxH2NDhi4nTx_csqBao9i4bfxCyCXi7B8G=_XnWu8ru2TQ@mail.gmail.com>
 <2828229.1751296483@sss.pgh.pa.us>
 <CACJufxEZ2DzyAKNBLqW+-2BqFAbT5Wnxkgkw6ogcbBBsndkD=Q@mail.gmail.com>
 <3266569.1751399577@sss.pgh.pa.us>
Comments: In-reply-to Tom Lane <tgl@sss.pgh.pa.us>
	message dated "Tue, 01 Jul 2025 15:52:57 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <4069863.1751564894.1@sss.pgh.pa.us>
Date: Thu, 03 Jul 2025 13:48:14 -0400
Message-ID: <4069864.1751564894@sss.pgh.pa.us>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/4069864.1751564894%40sss.pgh.pa.us>
Precedence: bulk

For the moment I've just gone ahead and pushed the bug fix,
with test cases that demonstrate the inconsistency in
behavior between stored and virtual generated columns.
Whether we should change that is probably a matter for
a separate thread.

			regards, tom lane