Re: More FK patches

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: More FK patches
Date: 2001-11-22 02:28:44
Message-ID: 200111220228.fAM2SiY04472@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


Was this resolved?

---------------------------------------------------------------------------

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

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-11-22 02:43:45 Re: rename index?
Previous Message Bruce Momjian 2001-11-22 02:28:02 Re: Foreign key referential actions

Browse pgsql-patches by date

  From Date Subject
Next Message Eiji Tokuya 2001-11-22 03:44:46 Added Encoding
Previous Message Tom Lane 2001-11-21 22:15:04 Re: Rejection of the smallest int8