RE: sql table referential integrity

I started fresh and this works

create table rob.order_header (
d_id bigint not null generated always as identity primary key,
Description varchar(200) allocate(25) not null
)
;
create table rob.order_header_overflow (
d_id bigint not null ,
ExtraColumn varchar(200) allocate(25) not null,
constraint x2 foreign key (d_id) references rob.order_header (d_id)
on delete cascade
-- not supported: on update cascade
)
;
insert into rob.order_header (description)
values('test')
;
select d_id from rob.order_header;
-- returns a 1

insert into rob.order_header_overflow (d_id, extraColumn)
values(1, 'bravo')
;
select d_id from rob.order_header_overflow;
-- returns a 1


delete from rob.order_header where d_id = 1;

select * from rob.order_header_overflow;
-- no rows returned. Got deleted.


Rob Berendt