Re: More FK patches - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: More FK patches
Date
Msg-id 200111220228.fAM2SiY04472@candle.pha.pa.us
Whole thread Raw
In response to More FK patches  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: More FK patches
List 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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Rejection of the smallest int8
Next
From: "Eiji Tokuya"
Date:
Subject: Added Encoding