Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 26D07475A71 for ; Fri, 8 Nov 2002 00:36:51 -0500 (EST) Received: from hotmail.com (f76.law12.hotmail.com [64.4.19.76]) by postgresql.org (Postfix) with ESMTP id 78581475EBB for ; Fri, 8 Nov 2002 00:36:50 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 7 Nov 2002 21:36:55 -0800 Received: from 128.123.37.105 by lw12fd.law12.hotmail.msn.com with HTTP; Fri, 08 Nov 2002 05:36:55 GMT X-Originating-IP: [128.123.37.105] From: "Zhidian Du" To: pgsql-sql@postgresql.org Subject: Delete cascade for multi tables? Date: Thu, 07 Nov 2002 22:36:55 -0700 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 08 Nov 2002 05:36:55.0941 (UTC) FILETIME=[D9808B50:01C286E8] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/124 X-Sequence-Number: 10266 Hello, I have several tables and one table is a reference table, all other tables are master tablls of this reference table. One record in these master tables have several records in the reference table. I want to delete cascade when delete one record one reocrd in mater tables and delete the releated records in the referecne table. How can I create reference table? Thanks. Zhidian Du _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail