From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/ref/drop_trigger.sgml | 127 +++++++++++++++++++++++++++++++++++++ 1 file changed, 127 insertions(+) create mode 100644 doc/src/sgml/ref/drop_trigger.sgml (limited to 'doc/src/sgml/ref/drop_trigger.sgml') diff --git a/doc/src/sgml/ref/drop_trigger.sgml b/doc/src/sgml/ref/drop_trigger.sgml new file mode 100644 index 0000000..728541e --- /dev/null +++ b/doc/src/sgml/ref/drop_trigger.sgml @@ -0,0 +1,127 @@ + + + + + DROP TRIGGER + + + + DROP TRIGGER + 7 + SQL - Language Statements + + + + DROP TRIGGER + remove a trigger + + + + +DROP TRIGGER [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] + + + + + Description + + + DROP TRIGGER removes an existing + trigger definition. To execute this command, the current + user must be the owner of the table for which the trigger is defined. + + + + + Parameters + + + + + IF EXISTS + + + Do not throw an error if the trigger does not exist. A notice is issued + in this case. + + + + + + name + + + The name of the trigger to remove. + + + + + + table_name + + + The name (optionally schema-qualified) of the table for which + the trigger is defined. + + + + + + CASCADE + + + Automatically drop objects that depend on the trigger, + and in turn all objects that depend on those objects + (see ). + + + + + + RESTRICT + + + Refuse to drop the trigger if any objects depend on it. This is + the default. + + + + + + + + Examples + + + Destroy the trigger if_dist_exists on the table + films: + + +DROP TRIGGER if_dist_exists ON films; + + + + + Compatibility + + + The DROP TRIGGER statement in + PostgreSQL is incompatible with the SQL + standard. In the SQL standard, trigger names are not local to + tables, so the command is simply DROP TRIGGER + name. + + + + + See Also + + + + + + + -- cgit v1.2.3