Re: apparent RI bug - Mailing list pgsql-sql

From chester c young
Subject Re: apparent RI bug
Date
Msg-id 811324.18014.qm@web54305.mail.re2.yahoo.com
Whole thread Raw
In response to Re: apparent RI bug  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: apparent RI bug  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
--- Stephan Szabo <sszabo@megazone.bigpanda.com> 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 so, is this
by design?

     ____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.  
http://tc.deals.yahoo.com/tc/blockbuster/text5.com


pgsql-sql by date:

Previous
From: "Marcin Krawczyk"
Date:
Subject: Re: connections between servers
Next
From: Stephan Szabo
Date:
Subject: Re: apparent RI bug