pgsql: Change FK trigger naming convention to fix self-referential FKs.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Change FK trigger naming convention to fix self-referential FKs.
Date: 2011-10-26 17:19:53
Message-ID: E1RJ78r-0008Vt-Cj@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Change FK trigger naming convention to fix self-referential FKs.

Use names like "RI_ConstraintTrigger_a_NNNN" for FK action triggers and
"RI_ConstraintTrigger_c_NNNN" for FK check triggers. This ensures the
action trigger fires first in self-referential cases where the very same
row update fires both an action and a check trigger. This change provides
a non-probabilistic solution for bug #6268, at the risk that it could break
client code that is making assumptions about the exact names assigned to
auto-generated FK triggers. Hence, change this in HEAD only. No need for
forced initdb since old triggers continue to work fine.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/1e3b21dd5e1070d301153690c1751bef74f03fa4

Modified Files
--------------
src/backend/commands/tablecmds.c | 26 ++++++++++++--------------
1 files changed, 12 insertions(+), 14 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Magnus Hagander 2011-10-26 17:26:46 pgsql: MingW doesn't support wcstombs_s()...
Previous Message Tom Lane 2011-10-26 17:03:38 pgsql: Change FK trigger creation order to better support self-referent