Re: apparent RI bug - Mailing list pgsql-sql

From chester c young
Subject Re: apparent RI bug
Date
Msg-id 447857.57570.qm@web54302.mail.re2.yahoo.com
Whole thread Raw
In response to Re: apparent RI bug  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
--- Stephan Szabo <sszabo@megazone.bigpanda.com> wrote:

> > is 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.

this is very good news that there is a reason why the RI did not work,
which is to say, RI not working randomly is very frightening


> > 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.

in my opinion the most important thing is that it's documented.

btw, cheers! you're my hero of the week!!


     ____________________________________________________________________________________
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: Stephan Szabo
Date:
Subject: Re: apparent RI bug
Next
From: "luke\.78\@libero\.it"
Date:
Subject: Problem with now() in function pgsql