ALTER TABLE results in "could not find cast from 3904 to 3831" - Mailing list pgsql-bugs

Hi everyone,

Consider the following test case:

CREATE TABLE t0(c0 int4range UNIQUE, FOREIGN KEY (c0) REFERENCES t0(c0));
ALTER TABLE t0 ALTER c0 SET DATA TYPE int4range; -- ERROR:  could not
find cast from 3904 to 3831

Unexpectedly, the ALTER TABLE results in an error. If, for example,
the references to the type "int4range" are replaced by "int", the two
statements execute without error.

Best,
Manuel