]> granicus.if.org Git - postgresql/commit
Second phase of committing Rod Taylor's pg_depend/pg_constraint patch.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 12 Jul 2002 18:43:19 +0000 (18:43 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 12 Jul 2002 18:43:19 +0000 (18:43 +0000)
commit7c6df91dda27accab3097390ef0d21d93028c7a1
tree5705b975e8de4edf82252e6df28e0bd57c83cb95
parent791a40f943e2a9353c5823fb4f2bd446ec623d38
Second phase of committing Rod Taylor's pg_depend/pg_constraint patch.
pg_relcheck is gone; CHECK, UNIQUE, PRIMARY KEY, and FOREIGN KEY
constraints all have real live entries in pg_constraint.  pg_depend
exists, and RESTRICT/CASCADE options work on most kinds of DROP;
however, pg_depend is not yet very well populated with dependencies.
(Most of the ones that are present at this point just replace formerly
hardwired associations, such as the implicit drop of a relation's pg_type
entry when the relation is dropped.)  Need to add more logic to create
dependency entries, improve pg_dump to dump constraints in place of
indexes and triggers, and add some regression tests.
77 files changed:
doc/src/sgml/catalogs.sgml
doc/src/sgml/ref/alter_table.sgml
doc/src/sgml/ref/comment.sgml
doc/src/sgml/ref/drop_aggregate.sgml
doc/src/sgml/ref/drop_domain.sgml
doc/src/sgml/ref/drop_function.sgml
doc/src/sgml/ref/drop_index.sgml
doc/src/sgml/ref/drop_language.sgml
doc/src/sgml/ref/drop_operator.sgml
doc/src/sgml/ref/drop_rule.sgml
doc/src/sgml/ref/drop_sequence.sgml
doc/src/sgml/ref/drop_table.sgml
doc/src/sgml/ref/drop_trigger.sgml
doc/src/sgml/ref/drop_type.sgml
doc/src/sgml/ref/drop_view.sgml
doc/src/sgml/release.sgml
src/backend/bootstrap/bootparse.y
src/backend/catalog/Makefile
src/backend/catalog/dependency.c [new file with mode: 0644]
src/backend/catalog/heap.c
src/backend/catalog/index.c
src/backend/catalog/indexing.c
src/backend/catalog/namespace.c
src/backend/catalog/pg_constraint.c [new file with mode: 0644]
src/backend/catalog/pg_depend.c [new file with mode: 0644]
src/backend/catalog/pg_type.c
src/backend/commands/aggregatecmds.c
src/backend/commands/cluster.c
src/backend/commands/comment.c
src/backend/commands/dbcommands.c
src/backend/commands/functioncmds.c
src/backend/commands/indexcmds.c
src/backend/commands/operatorcmds.c
src/backend/commands/proclang.c
src/backend/commands/tablecmds.c
src/backend/commands/trigger.c
src/backend/commands/typecmds.c
src/backend/commands/view.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/outfuncs.c
src/backend/parser/analyze.c
src/backend/parser/gram.y
src/backend/rewrite/rewriteDefine.c
src/backend/rewrite/rewriteRemove.c
src/backend/rewrite/rewriteSupport.c
src/backend/tcop/utility.c
src/backend/utils/cache/lsyscache.c
src/backend/utils/cache/relcache.c
src/bin/initdb/initdb.sh
src/bin/pg_dump/pg_dump.c
src/bin/psql/describe.c
src/include/access/tupdesc.h
src/include/catalog/catname.h
src/include/catalog/catversion.h
src/include/catalog/dependency.h [new file with mode: 0644]
src/include/catalog/heap.h
src/include/catalog/index.h
src/include/catalog/indexing.h
src/include/catalog/pg_constraint.h [new file with mode: 0644]
src/include/catalog/pg_depend.h [new file with mode: 0644]
src/include/catalog/pg_relcheck.h [deleted file]
src/include/commands/comment.h
src/include/commands/defrem.h
src/include/commands/proclang.h
src/include/commands/trigger.h
src/include/nodes/parsenodes.h
src/include/rewrite/rewriteRemove.h
src/include/utils/lsyscache.h
src/test/regress/expected/alter_table.out
src/test/regress/expected/domain.out
src/test/regress/expected/foreign_key.out
src/test/regress/expected/sanity_check.out
src/test/regress/output/constraints.source
src/test/regress/sql/alter_table.sql
src/test/regress/sql/domain.sql
src/test/regress/sql/foreign_key.sql