Home > mailing lists

Mechanics of UpDate:Cascade - Mailing list pgsql-sql

From	beyaNet Consultancy
Subject	Mechanics of UpDate:Cascade
Date	January 31, 2004 19:05:04
Msg-id	94326F1E-53DA-11D8-A6EB-0003938366A4@ntlworld.com Whole thread Raw
List	pgsql-sql

Tree view

Hi,
could someone please explain to me the mechanics of an UpDate:Cascade? 
Delete:Cascade I fully understand but not Update. I have 2 tables A and 
B. On B I have created a foreign key on user_id in both B and A for 
Update and Delete cascade. If I delete from A it deletes all from B. If 
I update A what happens in B?

regards


Andrew

pgsql-sql by date:

From: David Arnold
Date: 31 January 2004, 19:04:40
Subject: An order by question

From: Stephan Szabo
Date: 31 January 2004, 20:41:34
Subject: Re: Sometimes referential integrity seems not to work

Mechanics of UpDate:Cascade - Mailing list pgsql-sql

Previous

Next