From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Refer to the default foreign key match style as MATCH SIMPLE int |
Date: | 2012-06-18 00:17:04 |
Message-ID: | E1SgPeS-0002tr-Bh@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Refer to the default foreign key match style as MATCH SIMPLE internally.
Previously we followed the SQL92 wording, "MATCH <unspecified>", but since
SQL99 there's been a less awkward way to refer to the default style.
In addition to the code changes, pg_constraint.confmatchtype now stores
this match style as 's' (SIMPLE) rather than 'u' (UNSPECIFIED). This
doesn't affect pg_dump or psql because they use pg_get_constraintdef()
to reconstruct foreign key definitions. But other client-side code might
examine that column directly, so this change will have to be marked as
an incompatibility in the 9.3 release notes.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/f5297bdfe4c4a47376c41b96161fb55c2294a0b1
Modified Files
--------------
doc/src/sgml/catalogs.sgml | 2 +-
src/backend/catalog/information_schema.sql | 2 +-
src/backend/commands/trigger.c | 4 +-
src/backend/parser/gram.y | 4 +-
src/backend/utils/adt/ri_triggers.c | 208 ++++++++++++++++------------
src/backend/utils/adt/ruleutils.c | 2 +-
src/include/catalog/catversion.h | 2 +-
src/include/nodes/parsenodes.h | 4 +-
src/test/regress/expected/foreign_key.out | 2 +-
src/test/regress/sql/foreign_key.sql | 2 +-
10 files changed, 134 insertions(+), 98 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Farina | 2012-06-18 03:39:13 | Re: [COMMITTERS] pgsql: New SQL functons pg_backup_in_progress() and pg_backup_start_tim |
Previous Message | Peter Eisentraut | 2012-06-17 23:57:14 | pgsql: Make documentation of --help and --version options more consiste |