X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AF0A5D1D263 for ; Sat, 31 Jan 2004 10:51:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 90249-09 for ; Sat, 31 Jan 2004 06:51:26 -0400 (AST) Received: from mta04-svc.ntlworld.com (mta04-svc.ntlworld.com [62.253.162.44]) by svr1.postgresql.org (Postfix) with ESMTP id A8312D1B57C for ; Sat, 31 Jan 2004 06:51:23 -0400 (AST) Received: from [81.98.165.129] by mta04-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with ESMTP id <20040131105017.DHSK28193.mta04-svc.ntlworld.com@[81.98.165.129]> for ; Sat, 31 Jan 2004 10:50:17 +0000 Mime-Version: 1.0 (Apple Message framework v609) Content-Transfer-Encoding: 7bit Message-Id: <3968B922-53DB-11D8-A6EB-0003938366A4@beya-records.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: pgsql-sql@postgresql.org From: beyaRecords - The home Urban music Subject: Mechanics of Update:Cascade Date: Sat, 31 Jan 2004 10:50:03 +0000 X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/289 X-Sequence-Number: 16682 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