Re: [ADMIN] CASCADE PB

2002-11-27 Thread Stephan Szabo
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

Re: [ADMIN] CASCADE PB

2002-11-27 Thread fred
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

Re: [ADMIN] CASCADE PB

2002-11-27 Thread Stephan Szabo
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

[ADMIN] CASCADE PB

2002-11-27 Thread fred
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