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?
create table a(ia int primary key);
create table b(ia int references a
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
From billy Tue Jun 11 13:38:51 2002
Date: Tue, 11 Jun 2002 10:54:27 -0700 (PDT)
From: Stephan Szabo [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
On Mon, 10 Jun 2002, Stephen R. van den Berg wrote:
Should the following piece of code cause an:
Stephan Szabo [EMAIL PROTECTED] 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
On Tue, 11 Jun 2002, Tom Lane wrote:
Stephan Szabo [EMAIL PROTECTED] 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
On 2002.06.11 at 14:43:17 -0400, Tom Lane wrote:
Stephan Szabo [EMAIL PROTECTED] writes:
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
Stephan Szabo [EMAIL PROTECTED] writes:
As a related side note. The other part of the original patch (the NOT
EXISTS in the upd/del no action trigger) was rejected. For match
full and match unspecified the same result can be reached by doing another
query which may be better than the