Hi

I am playing with new features in Postgres 18.

Maybe I found a bug

(2025-03-18 19:28:06) postgres=# create table foo(a int constraint gzero
check(a > 10) NOT ENFORCED);
CREATE TABLE
(2025-03-18 19:29:37) postgres=# insert into foo values(0);
INSERT 0 1
(2025-03-18 19:29:49) postgres=# insert into foo values(6);
INSERT 0 1
(2025-03-18 19:29:55) postgres=# alter table foo alter constraint gzero
enforced;
ERROR:  FOREIGN KEY constraints cannot be marked ENFORCED
LINE 1: alter table foo alter constraint gzero enforced;

I know so altering enforcing constraint is not supported yet, but the error
message is surely wrong

gzero is not foreign key constraint

Regards

Pavel

Reply via email to