title: Enforce Referential Integrity on Materialized Path?
body: <p>I'm trying to implement a tree like structure using a Materialized Path model described here: <a href="http://www.dbazine.com/oracle/or-articles/tropashko4" rel="nofollow noreferrer">http://www.dbazine.com/oracle/or-articles/tropashko4</a>.</p>
  
  <p>Is it possible to enforce referential integrity on the [path] field?  I don't see how SQL could do it, do I have to do it manually in the DAL?</p>