Re: apparent RI bug

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: apparent RI bug
Date: 2008-04-03 20:16:42
Message-ID: 811324.18014.qm@web54305.mail.re2.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

--- Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2008-04-03 20:35:15 Re: apparent RI bug
Previous Message Marcin Krawczyk 2008-04-03 19:26:52 Re: connections between servers