Re: bug: repeated ALTER COLUMN SET DATA TYPE corrupt check constraint

Поиск
Список
Период
Сортировка
От Srinath Reddy Sadipiralla
Тема Re: bug: repeated ALTER COLUMN SET DATA TYPE corrupt check constraint
Дата
Msg-id CAFC+b6ry2Q20K1LYhUK6bW8YsYFouJVeMfQBUHPFvkOCFmoLnA@mail.gmail.com
обсуждение исходный текст
Ответ на bug: repeated ALTER COLUMN SET DATA TYPE corrupt check constraint  (jian he <jian.universality@gmail.com>)
Ответы Re: bug: repeated ALTER COLUMN SET DATA TYPE corrupt check constraint
Список pgsql-hackers
Hi Jian,

On Sat, Dec 27, 2025 at 1:28 PM jian he <jian.universality@gmail.com> 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/

В списке pgsql-hackers по дате отправления: