Re: Can i force deletion of dependent rows? - Mailing list pgsql-sql

From Shruthi A
Subject Re: Can i force deletion of dependent rows?
Date
Msg-id 6caee9521002130925u46ac27c1u9c0c2f3f202e411f@mail.gmail.com
Whole thread Raw
In response to Re: Can i force deletion of dependent rows?  (Shoaib Mir <shoaibmir@gmail.com>)
List pgsql-sql
Thanks people, but the trigger doesnt really solve my problem.  You see, there is actually a CHAIN of dependencies
whereB references A, C references B, D and E reference C and so on...   So if i start writing triggers for all these,
there'llbe a huge process to follow.  I'm not strictly against it, i might use it as a last resort, but i'm asking if a
simpleDML statement would solve my problem.<br /><br />Dear Shoaib, I did mention in a note that I don't want to
recreatethe 2 tables with the 'on delete cascade' clause.  The tables are ALREADY created and populated.  And they are
huge. So i cannot afford to drop and recreate them.  I want an option in DML only.  If that is possible that is.<br
/><br/><br />Thanks,<br />Shruthi<br /> 

pgsql-sql by date:

Previous
From: Shoaib Mir
Date:
Subject: Re: Can i force deletion of dependent rows?
Next
From: Tim Landscheidt
Date:
Subject: Re: Can i force deletion of dependent rows?