create table base (x int primary key);
 create table derived(x int primary key, y int default 123 references base(x) on delete set default);
 insert into base values(456);
 insert into derived values (111, 456);

 --- bang:
 delete from base where true;