Hi Jian,
On Sat, Dec 27, 2025 at 1:28 PM jian he <[email protected]> wrote:
> hi.
>
> while working on let ALTER COLUMN SET DATA TYPE cope with trigger
> dependency.
> I found this bug, it involves several ALTER COLUMN SET DATA TYPE calls.
>
> DROP TABLE IF EXISTS main_table;
> CREATE TABLE main_table (a int, b int, check(a = b));
> ALTER TABLE main_table ALTER COLUMN a SET DATA TYPE numeric;
> ALTER TABLE main_table ALTER COLUMN a SET DATA TYPE int;
> ALTER TABLE main_table ALTER COLUMN a SET DATA TYPE text;
> ALTER TABLE main_table ALTER COLUMN b SET DATA TYPE text;
> INSERT INTO main_table VALUES ('a', 'a');
>
> This also applies to statistics, indexes. for statistics: the error is only
> observable after running ANALYZE manually.
>
Yeah, I can easily reproduce this.
--
Thanks,
Srinath Reddy Sadipiralla
EDB: https://www.enterprisedb.com/
