Mechanics of UpDate:Cascade

From: beyaNet Consultancy <beyanet(at)ntlworld(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Mechanics of UpDate:Cascade
Date: 2004-01-31 10:45:26
Message-ID: 94326F1E-53DA-11D8-A6EB-0003938366A4@ntlworld.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message beyaRecords - The home Urban music 2004-01-31 10:50:03 Mechanics of Update:Cascade
Previous Message email lists 2004-01-31 05:09:15 Re: query not using index for descending records?