Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-hackers by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group