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