Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table bar (bar_id int primary key);
insert into bar values (1), (2)
2 rows affected

create table foo (
    foo_id int primary key,
    bar_id int,
    foreign key (bar_id) references bar(bar_id) on update cascade
);

insert into foo (foo_id, bar_id) values (1, 1), (2, 2);
2 rows affected

select * from foo


foo_id
bar_id


1
1

2
2


update bar set bar_id = bar_id + 1000
2 rows affected

select *
from foo


foo_id
bar_id


1
1001

2
1002