On Wed, 27 Nov 2002, fred wrote:
> Ok,
> Thank you for your quick answer,
> I'm affraid I made a mistake on my mail.
> I really wanted to automaticly delete line in the 'fact' table when I delete
> a line in the 'fact' table.
> But when I suppress a line in the 'coop' table I still have the relat
Ok,
Thank you for your quick answer,
I'm affraid I made a mistake on my mail.
I really wanted to automaticly delete line in the 'fact' table when I delete
a line in the 'fact' table.
But when I suppress a line in the 'coop' table I still have the related line
in the 'fact' table.
Do you think ther
On Wed, 27 Nov 2002, fred wrote:
> 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 ?
On delete cascade goes the other direction. What
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 nu