git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 8504905) | patch
Support deferrable uniqueness constraints.
2009年7月29日 20:56:21 +0000 (20:56 +0000)
2009年7月29日 20:56:21 +0000 (20:56 +0000)
commit 25d9bf2e3e66ee2e546c5c523d148ecab6ee1dcc
Support deferrable uniqueness constraints.

The current implementation fires an AFTER ROW trigger for each tuple that
looks like it might be non-unique according to the index contents at the
time of insertion. This works well as long as there aren't many conflicts,
but won't scale to massive unique-key reassignments. Improving that case
is a TODO item.

Dean Rasheed
51 files changed:
doc/src/sgml/catalogs.sgml diff | blob | blame | history
doc/src/sgml/indexam.sgml diff | blob | blame | history
doc/src/sgml/ref/create_table.sgml diff | blob | blame | history
doc/src/sgml/ref/set_constraints.sgml diff | blob | blame | history
src/backend/access/gin/gininsert.c diff | blob | blame | history
src/backend/access/gist/gist.c diff | blob | blame | history
src/backend/access/hash/hash.c diff | blob | blame | history
src/backend/access/heap/tuptoaster.c diff | blob | blame | history
src/backend/access/index/indexam.c diff | blob | blame | history
src/backend/access/nbtree/nbtinsert.c diff | blob | blame | history
src/backend/access/nbtree/nbtree.c diff | blob | blame | history
src/backend/bootstrap/bootparse.y diff | blob | blame | history
src/backend/catalog/index.c diff | blob | blame | history
src/backend/catalog/indexing.c diff | blob | blame | history
src/backend/catalog/sql_features.txt diff | blob | blame | history
src/backend/catalog/toasting.c diff | blob | blame | history
src/backend/commands/Makefile diff | blob | blame | history
src/backend/commands/constraint.c [new file with mode: 0644] blob
src/backend/commands/copy.c diff | blob | blame | history
src/backend/commands/indexcmds.c diff | blob | blame | history
src/backend/commands/tablecmds.c diff | blob | blame | history
src/backend/commands/trigger.c diff | blob | blame | history
src/backend/executor/execMain.c diff | blob | blame | history
src/backend/executor/execUtils.c diff | blob | blame | history
src/backend/nodes/copyfuncs.c diff | blob | blame | history
src/backend/nodes/equalfuncs.c diff | blob | blame | history
src/backend/nodes/outfuncs.c diff | blob | blame | history
src/backend/parser/gram.y diff | blob | blame | history
src/backend/parser/parse_utilcmd.c diff | blob | blame | history
src/backend/tcop/utility.c diff | blob | blame | history
src/backend/utils/adt/ruleutils.c diff | blob | blame | history
src/backend/utils/cache/relcache.c diff | blob | blame | history
src/bin/pg_dump/pg_dump.c diff | blob | blame | history
src/bin/pg_dump/pg_dump.h diff | blob | blame | history
src/bin/psql/describe.c diff | blob | blame | history
src/include/access/genam.h diff | blob | blame | history
src/include/access/nbtree.h diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/index.h diff | blob | blame | history
src/include/catalog/pg_attribute.h diff | blob | blame | history
src/include/catalog/pg_index.h diff | blob | blame | history
src/include/catalog/pg_proc.h diff | blob | blame | history
src/include/commands/defrem.h diff | blob | blame | history
src/include/commands/trigger.h diff | blob | blame | history
src/include/executor/executor.h diff | blob | blame | history
src/include/nodes/parsenodes.h diff | blob | blame | history
src/include/utils/builtins.h diff | blob | blame | history
src/test/regress/expected/sanity_check.out diff | blob | blame | history
src/test/regress/input/constraints.source diff | blob | blame | history
src/test/regress/output/constraints.source diff | blob | blame | history
src/test/regress/sql/sanity_check.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /