pgsql-server/src backend/utils/adt/ri_triggers ...

From: wieck(at)svr1(dot)postgresql(dot)org (Jan Wieck)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/src backend/utils/adt/ri_triggers ...
Date: 2003-10-31 03:58:21
Message-ID: 20031031035821.98FEBD1B53A@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: wieck(at)svr1(dot)postgresql(dot)org 03/10/30 23:58:21

Modified files:
src/backend/utils/adt: ri_triggers.c
src/test/regress/expected: foreign_key.out
src/test/regress/sql: foreign_key.sql

Log message:
Fix for possible referential integrity violation when a qualified ON INSERT
rule split the query into one INSERT and one UPDATE where the UPDATE
then hit's the just created row without modifying the key fields again.
In this special case, the new key slipped in totally unchecked.

Jan

Browse pgsql-committers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-10-31 04:14:56 Re: pgsql-server/src/tutorial syscat.source
Previous Message Tom Lane 2003-10-31 03:58:16 pgsql-server/src/tutorial syscat.source