OSDN Git Service

Support SQL-compliant triggers on columns, ie fire only if certain columns
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 14 Oct 2009 22:14:25 +0000 (22:14 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 14 Oct 2009 22:14:25 +0000 (22:14 +0000)
commitb2734a0d792df710aeeab21242cfa21ab470c773
treefea1d5961054f413f63995339f1aa6037d825b9e
parentbe922e8555a87263973a038c54171f2db833810d
Support SQL-compliant triggers on columns, ie fire only if certain columns
are named in the UPDATE's SET list.

Note: the schema of pg_trigger has not actually changed; we've just started
to use a column that was there all along.  catversion bumped anyway so that
this commit is included in the history of potentially interesting changes
to system catalog contents.

Itagaki Takahiro
17 files changed:
doc/src/sgml/catalogs.sgml
doc/src/sgml/ref/create_trigger.sgml
doc/src/sgml/trigger.sgml
src/backend/catalog/index.c
src/backend/commands/tablecmds.c
src/backend/commands/trigger.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/optimizer/plan/setrefs.c
src/backend/parser/gram.y
src/backend/utils/adt/ruleutils.c
src/bin/pg_dump/pg_dump.c
src/include/catalog/catversion.h
src/include/catalog/pg_trigger.h
src/include/nodes/parsenodes.h
src/test/regress/expected/triggers.out
src/test/regress/sql/triggers.sql