SV: Foreign key checks/referential integrity. - Mailing list pgsql-hackers

From Jarmo Paavilainen
Subject SV: Foreign key checks/referential integrity.
Date
Msg-id 001601c0c771$bbced4a0$1501a8c0@telia.com
Whole thread Raw
In response to Foreign key checks/referential integrity.  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
Hi,

...
> key reference). Isn't then the query valid for those tuples which do not
> result in a violation of the referential integrity test? Shouldn't those
> tuples in a be deleted?

The "all or nothing" approach causes this. And _here_ **I think** its
correct behaviour. (IMHO user and backend transactions are not the same
thing).

// Jarmo



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [PATCHES] Patch for PostgreSQL 7.0.3 to compile on Tru64 UNIX v5.0A
Next
From: Tom Lane
Date:
Subject: Re: Authentication with PGSQL