Rule names are now unique per-relation, rather than unique globally.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 18 Apr 2002 20:01:11 +0000 (20:01 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 18 Apr 2002 20:01:11 +0000 (20:01 +0000)
commitef9993127feef05ee489bf330cf4776c8954b70d
tree115f1116cbea1f26e674a813fde07a2068e8803e
parentd370ca504ae17b4791d11aebbb299acbd531446e
Rule names are now unique per-relation, rather than unique globally.
DROP RULE and COMMENT ON RULE syntax adds an 'ON tablename' clause,
similar to TRIGGER syntaxes.  To allow loading of existing pg_dump
files containing COMMENT ON RULE, the COMMENT code will still accept
the old syntax --- but only if the target rulename is unique across
the whole database.
35 files changed:
doc/src/sgml/func.sgml
doc/src/sgml/ref/comment.sgml
doc/src/sgml/ref/drop_rule.sgml
doc/src/sgml/release.sgml
src/backend/catalog/indexing.c
src/backend/commands/comment.c
src/backend/commands/tablecmds.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/parser/gram.y
src/backend/rewrite/rewriteDefine.c
src/backend/rewrite/rewriteRemove.c
src/backend/rewrite/rewriteSupport.c
src/backend/tcop/postgres.c
src/backend/tcop/utility.c
src/backend/utils/adt/ruleutils.c
src/backend/utils/cache/relcache.c
src/backend/utils/cache/syscache.c
src/bin/initdb/initdb.sh
src/bin/pg_dump/pg_dump.c
src/include/catalog/catversion.h
src/include/catalog/indexing.h
src/include/catalog/pg_proc.h
src/include/catalog/pg_rewrite.h
src/include/nodes/nodes.h
src/include/nodes/parsenodes.h
src/include/rewrite/rewriteDefine.h
src/include/rewrite/rewriteRemove.h
src/include/rewrite/rewriteSupport.h
src/include/utils/builtins.h
src/include/utils/syscache.h
src/test/regress/expected/errors.out
src/test/regress/expected/rules.out
src/test/regress/sql/errors.sql
src/test/regress/sql/rules.sql