From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/ref/drop_rule.sgml | 123 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 123 insertions(+) create mode 100644 doc/src/sgml/ref/drop_rule.sgml (limited to 'doc/src/sgml/ref/drop_rule.sgml') diff --git a/doc/src/sgml/ref/drop_rule.sgml b/doc/src/sgml/ref/drop_rule.sgml new file mode 100644 index 0000000..cc5d00e --- /dev/null +++ b/doc/src/sgml/ref/drop_rule.sgml @@ -0,0 +1,123 @@ + + + + + DROP RULE + + + + DROP RULE + 7 + SQL - Language Statements + + + + DROP RULE + remove a rewrite rule + + + + +DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] + + + + + Description + + + DROP RULE drops a rewrite rule. + + + + + Parameters + + + + + IF EXISTS + + + Do not throw an error if the rule does not exist. A notice is issued + in this case. + + + + + + name + + + The name of the rule to drop. + + + + + + table_name + + + The name (optionally schema-qualified) of the table or view that + the rule applies to. + + + + + + CASCADE + + + Automatically drop objects that depend on the rule, + and in turn all objects that depend on those objects + (see ). + + + + + + RESTRICT + + + Refuse to drop the rule if any objects depend on it. This is + the default. + + + + + + + + Examples + + + To drop the rewrite rule newrule: + + +DROP RULE newrule ON mytable; + + + + + Compatibility + + + DROP RULE is a + PostgreSQL language extension, as is the + entire query rewrite system. + + + + + See Also + + + + + + + + -- cgit v1.2.3