Flashnux

GNU/Linux man pages

• CentOS
• Debian
• Red Hat
• Ubuntu
• Unix

Livre :
Expressions régulières,
Syntaxe et mise en oeuvre :

ISBN : 978-2-7460-9712-4
EAN : 9782746097124
(Editions ENI)

GNU/Linux	RedHat 6.2 (Zoot)
	drop_rule(l)

---

DROP_RULE

NAME
SYNOPSIS
DESCRIPTION
USAGE
COMPATIBILITY

---

NAME

DROP RULE − Removes an existing rule from the database

SYNOPSIS

DROP RULE name

INPUTS

name

The name of an existing rule to drop.

OUTPUTS

DROP

Message returned if successfully.

ERROR: RewriteGetRuleEventRel: rule "name" not found

This message occurs if the specified rule does not exist.

DESCRIPTION

DROP RULE drops a rule from the specified Postgres rule system. Postgres will immediately cease enforcing it and will purge its definition from the system catalogs.

NOTES
The DROP RULE statement is a Postgres language extension.

Refer to CREATE RULE for information on how to create rules.

Once a rule is dropped, access to historical information the rule has written may disappear.

USAGE

To drop the rewrite rule newrule:

DROP RULE newrule;

COMPATIBILITY

SQL92
There is no DROP RULE in SQL92.

---

---

drop_rule(l)