Re: BUG #8227: referential integrity problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #8227: referential integrity problem
Date
Msg-id 1106.1371072994@sss.pgh.pa.us
Whole thread Raw
In response to BUG #8227: referential integrity problem  (greg@antrez.pl)
List pgsql-bugs
greg@antrez.pl writes:
> Is it ok that we loose referential integrity by locking DELETE on table
> test_item ?

Yes.  If you put a trigger on a table involved in an FK constraint, it's
your responsibility that the trigger doesn't break FK update operations.

            regards, tom lane

pgsql-bugs by date:

Previous
From: greg@antrez.pl
Date:
Subject: BUG #8227: referential integrity problem
Next
From: Hiroshi Inoue
Date:
Subject: Re: [ODBC] Segmentation Fault in Postgres server when using psqlODBC