Skip site navigation (1) Skip section navigation (2)

Fk fix for noaction update/delete

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <pgsql-patches(at)postgresql(dot)org>
Subject: Fk fix for noaction update/delete
Date: 2002-07-21 17:34:06
Message-ID: 20020721102928.N4483-200000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-patches
	This should fix a bug where a row that was updated or
deleted that had another row inserted/updated to its old
value during the same statement or other statements before the
integrity check for noaction would incorrectly error.  This
could happen in deferred constraints or due to triggers or
functions. It's effectively a reworking of the previous patch that
did a not exists to instead do a separate check.


Attachment: fk_deferred_noaction_patch
Description: text/plain (10.5 KB)

Responses

pgsql-patches by date

Next:From: Manfred KoizarDate: 2002-07-21 21:00:22
Subject: Re: More heap tuple header fixes
Previous:From: Tom LaneDate: 2002-07-21 13:46:08
Subject: Re: guc GetConfigOptionByNum and tablefunc API - minor changes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group