Hello, I use postgreSQL 7.2.3 and I have trouble on deleting. I would like to automaticly delete line in the 'coop' table when I dlete the line in the 'fact' table but it is not ok. Where is my mistake ? This is my database:
create table coop ( id_coop serial not null, nom_coop varchar(50) not null, primary key(id_coop) ); create table fact ( id_fact serial not null, id_coop integer references coop(id_coop) on delete cascade, date_fact timestamp not null, montant_fact decimal(6,3), primary key(id_fact) ); Thank's for your support. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster