pgsql: Refer to the default foreign key match style as MATCH SIMPLE int
От | Tom Lane |
---|---|
Тема | pgsql: Refer to the default foreign key match style as MATCH SIMPLE int |
Дата | |
Msg-id | E1SgPeS-0002tr-Bh@gemulon.postgresql.org обсуждение исходный текст |
Список | 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(-)
В списке pgsql-committers по дате отправления: