More FK patches

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <pgsql-patches(at)postgresql(dot)org>
Subject: More FK patches
Date: 2001-11-13 02:22:15
Message-ID: 20011112181333.Q76772-200000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


This patch should help fix cases with two separate fk constraints
in a row that happen to reference the same pk constraint with
an on update cascade and similar cases. It now should detect
correctly that a pk row was added later after a delete or update
on a no action deferred fk and not incorrect error as well
as dropping a check on insert/update to the fk table if the
row we're being referred to no longer is valid (I'm using
HeapTupleSatisfiesItself because the comment implied it was
what I was looking for and it appears to work :) ).

I've got regression tests but I'm holding off on those until
we decide whether or not we're dropping the triggered data change
errors since a couple of the tests would hit that case and I'll
either change them or drop them if we're not dropping the error.

Attachment Content-Type Size
fix1.patch text/plain 5.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2001-11-13 02:50:17 Foreign key referential actions
Previous Message Tom Lane 2001-11-13 01:52:14 Re: ALTER TABLE ADD COLUMN can't use NOT NULL?

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-11-13 04:07:04 Re: More FK patches
Previous Message Tom Lane 2001-11-13 01:51:16 Re: Patch to add Heimdal kerberos support