Bidirectional foreign key constraints

address_person.sql

create table address (
    address_id serial primary key,
    person_id integer
);

create table person (
    person_id serial primary key,
    address_id integer
);

alter table address
add constraint fk_address_person_id
foreign key (person_id) references person (person_id)
on delete cascade
deferrable initially deferred;


alter table person
add constraint fk_person_address_id
foreign key (address_id) references address (address_id)
on delete cascade
deferrable initially deferred;

begin;
    -- set constraints all deferred;
    insert into person (person_id, address_id) values (1, 1);
    insert into address (address_id, person_id) values (1, 1);
commit;