On Sun, Jan 24, 2021, at 21:46, Mark Rofail wrote: >Thank you for this find, please find the fix below
Many thanks for fixing. I can confirm it now works like expected for the reported case: CREATE SCHEMA catalog_clone; CREATE TABLE catalog_clone.pg_proc AS SELECT * FROM pg_catalog.pg_proc; CREATE TABLE catalog_clone.pg_type AS SELECT * FROM pg_catalog.pg_type; ALTER TABLE catalog_clone.pg_type ADD PRIMARY KEY (oid); ALTER TABLE catalog_clone.pg_proc ADD FOREIGN KEY (EACH ELEMENT OF proargtypes) REFERENCES catalog_clone.pg_type (oid); UPDATE catalog_clone.pg_proc SET proargtypes = '19 25 12345'::oidvector WHERE oid = 79; ERROR: insert or update on table "pg_proc" violates foreign key constraint "pg_proc_proargtypes_fkey" DETAIL: Key (EACH ELEMENT OF proargtypes)=(19 25 12345) is not present in table "pg_type". Excellent! I'll continue testing over the next couple of days and report if I find any more oddities. /Joel
