Home > mailing lists

Mechanics of Update:Cascade - Mailing list pgsql-sql

From	beyaRecords - The home Urban music
Subject	Mechanics of Update:Cascade
Date	January 31, 2004 09:51:28
Msg-id	3968B922-53DB-11D8-A6EB-0003938366A4@beya-records.com Whole thread Raw
Responses	Re: Mechanics of Update:Cascade Re: Mechanics of Update:Cascade
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?

many thanks

pgsql-sql by date:

From: "email lists"
Date: 31 January 2004, 04:03:09
Subject: Re: query not using index for descending records?

From: Stephan Szabo
Date: 31 January 2004, 14:23:53
Subject: Re: [NOVICE] 'select nextval('seq_name');' in a function ?

Mechanics of Update:Cascade - Mailing list pgsql-sql

Previous

Next