Re: Referential integrity problem postgresql 7.2 ?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Referential integrity problem postgresql 7.2 ?
Date: 2002-06-11 17:54:27
Message-ID: 20020611105152.V80282-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


On Mon, 10 Jun 2002, Stephen R. van den Berg wrote:

> Should the following piece of code cause an:
> 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).

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-06-11 18:43:17 Re: Referential integrity problem postgresql 7.2 ?
Previous Message Stephan Szabo 2002-06-11 17:51:07 Re: referential integrity error

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2002-06-11 18:08:11 Re: New string functions; initdb required
Previous Message Billy O'Connor 2002-06-11 17:41:40 Re: Referential integrity problem postgresql 7.2 ?