]> granicus.if.org Git - postgresql/commit
Refer to the default foreign key match style as MATCH SIMPLE internally.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 18 Jun 2012 00:16:07 +0000 (20:16 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 18 Jun 2012 00:16:44 +0000 (20:16 -0400)
commitf5297bdfe4c4a47376c41b96161fb55c2294a0b1
treea16c04a93f38ec3ecde20ed318911b5dc31fcae6
parentbb7520cc26dcd392e3dce294b685b3a0d6dae9e9
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.
doc/src/sgml/catalogs.sgml
src/backend/catalog/information_schema.sql
src/backend/commands/trigger.c
src/backend/parser/gram.y
src/backend/utils/adt/ri_triggers.c
src/backend/utils/adt/ruleutils.c
src/include/catalog/catversion.h
src/include/nodes/parsenodes.h
src/test/regress/expected/foreign_key.out
src/test/regress/sql/foreign_key.sql