FK on update no action patch - Mailing list pgsql-patches

From Stephan Szabo
Subject FK on update no action patch
Date
Msg-id 20030409164240.A72205-200000@megazone23.bigpanda.com
Whole thread Raw
Responses Re: FK on update no action patch  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: FK on update no action patch  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
During looking stuff up for a discussion on -general, I realized that I'd
placed the check for newly created matching pk rows for on update no
action earlier than it needed to be so that it'd check even when the key
values hadn't changed.  This patch moves it to after checking for NULLs in
the old row and comparing the values since the select's probably more
expensive.

Regression tests appear to pass as do simple tests.

Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: array support patch phase 1 patch
Next
From: Michael Graff
Date:
Subject: IPv6 address parsing for inet/cidr types (take II)