SV: Foreign key checks/referential integrity.

From: "Jarmo Paavilainen" <netletter(at)comder(dot)com>
To: "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: SV: Foreign key checks/referential integrity.
Date: 2001-04-17 19:08:06
Message-ID: 001601c0c771$bbced4a0$1501a8c0@telia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-04-17 19:35:56 Re: Authentication with PGSQL
Previous Message Kyle VanderBeek 2001-04-17 18:29:27 Re: Large Object problems (was Re: JDBC int8 hack)