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 s
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 t
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: referential integrity violation - key referenced
> >> from b not found in a
> >> Or should it work because the check is deferred and in the
> >> e
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Mon, 10 Jun 2002, Stephen R. van den Berg wrote:
>> ERROR: 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 (a
>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:
On Mon, 10 Jun 2002, Stephen R. van den Berg wrote:
> Should the following piece of code cause an:
> ERROR: 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 (a
On Mon, 18 Jun 2001 [EMAIL PROTECTED] wrote:
> Denis Sbragion ([EMAIL PROTECTED]) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> Referential integrity problem
>
> Long Description It looks like performing operation in two steps on
> tabl
Please take my name off of this email list.
Thank you!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 12:49 PM
To: [EMAIL PROTECTED]
Subject: [BUGS] Referential integrity problem
Denis Sbragion ([EMAIL PROTECTED]) reports a bug with a
This is a known problem. We don't have a fix yet.
> Hi,
> We think we have found a problem when deleting and inserting in
> the same transaction with constraints deferred:
>
>
> machine=> create table foo (bar int4 primary key, ref int4 references foo
> deferrable
