On Thu, 3 Apr 2008, chester c young wrote: > --- Stephan Szabo <[EMAIL PROTECTED]> wrote: > > > Is it possible you ever had a before delete trigger that just did a > > return > > NULL rather than raising an exception? IIRC, explicitly telling the > > system to ignore the delete will work on the referential actions. > > yes, it is possible, for example, a function without a body or without > a "return old". > > are you saying this would override the RI constraint?
If it returned something that would have prevented the delete without an error, yes. > if so, is this by design? It's basically an ongoing question (without concensus AFAIK) about whether a rule or trigger should be allowed to stop the referential action and what should happen if it does. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql