Re: Referential integrity problem postgresql 7.2 ?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: "Stephen R. van den Berg" <srb@cuci.nl>, pgsql-bugs@postgresql.org
Date: 2002-06-11T18:43:17Z
Lists: pgsql-bugs, pgsql-hackers
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> On Mon, 10 Jun 2002, Stephen R. van den Berg wrote:
>> ERROR:  <unnamed> referential integrity violation - key referenced
>> from b not found in a
>> Or should it work because the check is deferred and in the
>> end no violations are present?

> It should work (and does in current sources).  If you look in the archives
> you should be able to get info on how to patch 7.2 (it came up recently,
> I'm not sure which list, and Tom Lane sent the message in question).

BTW, should we back-patch that into 7.2.*?  I was resistant to the idea
because of concern about lack of testing, but seeing that we've gotten
several complaints maybe we should do it anyway.

			regards, tom lane