diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2012-06-17 20:16:07 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2012-06-17 20:16:44 -0400 |
| commit | f5297bdfe4c4a47376c41b96161fb55c2294a0b1 (patch) | |
| tree | a16c04a93f38ec3ecde20ed318911b5dc31fcae6 /src/backend/utils/adt/ruleutils.c | |
| parent | bb7520cc26dcd392e3dce294b685b3a0d6dae9e9 (diff) | |
| download | postgresql-f5297bdfe4c4a47376c41b96161fb55c2294a0b1.tar.gz postgresql-f5297bdfe4c4a47376c41b96161fb55c2294a0b1.zip | |
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.
Diffstat (limited to 'src/backend/utils/adt/ruleutils.c')
| -rw-r--r-- | src/backend/utils/adt/ruleutils.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/backend/utils/adt/ruleutils.c b/src/backend/utils/adt/ruleutils.c index 9ca3b9d0c44..5bf3533a114 100644 --- a/src/backend/utils/adt/ruleutils.c +++ b/src/backend/utils/adt/ruleutils.c @@ -1184,7 +1184,7 @@ pg_get_constraintdef_worker(Oid constraintId, bool fullCommand, case FKCONSTR_MATCH_PARTIAL: string = " MATCH PARTIAL"; break; - case FKCONSTR_MATCH_UNSPECIFIED: + case FKCONSTR_MATCH_SIMPLE: string = ""; break; default: |