]> granicus.if.org Git - postgresql/commit
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)
commitb3120804ad1692322a6d905b352df7fa0d7cdd80
tree93aaf632df82db20e63c952be8a6fd1e4ec15629
parent4e08a625b006ba3992be881b516773adba5863e4
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