Re: Referential integrity problem postgresql 7.2 ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Referential integrity problem postgresql 7.2 ?
Date: 2002-06-11 18:43:17
Message-ID: 3139.1023820997@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2002-06-11 19:05:42 Re: Referential integrity problem postgresql 7.2 ?
Previous Message Stephan Szabo 2002-06-11 17:54:27 Re: Referential integrity problem postgresql 7.2 ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2002-06-11 19:05:42 Re: Referential integrity problem postgresql 7.2 ?
Previous Message Igor Kovalenko 2002-06-11 18:14:58 Re: Native Win32/OS2/BeOS/NetWare ports