Delete cascade for multi tables?

From: "Zhidian Du" <duzhidian(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Delete cascade for multi tables?
Date: 2002-11-08 05:36:55
Message-ID: F76s7nlT2NqFJ3sl3xb00000084@hotmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Browse pgsql-sql by date

  From Date Subject
Next Message Zhidian Du 2002-11-08 06:19:09 No promany key in parent table, how to use delete cascade?
Previous Message Prime Ho 2002-11-08 05:17:52 get source table.field name from view's field