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 |
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? |
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 |