Re: BUG #8227: referential integrity problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: greg(at)antrez(dot)pl
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8227: referential integrity problem
Date: 2013-06-12 21:36:34
Message-ID: 1106.1371072994@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

greg(at)antrez(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Hiroshi Inoue 2013-06-13 13:31:20 Re: [ODBC] Segmentation Fault in Postgres server when using psqlODBC
Previous Message greg 2013-06-12 20:08:53 BUG #8227: referential integrity problem