云数据库 GaussDB-ALTER TRIGGER:示例

时间：2025-02-12 15:07:58

云数据库 GaussDB

示例

  
       --创建源表及触发表。gaussdb=# CREATE TABLE test_trigger_src_tbl(id1 INT, id2 INT, id3 INT);gaussdb=# CREATE TABLE test_trigger_des_tbl(id1 INT, id2 INT, id3 INT);--创建DELETE触发器函数。gaussdb=# CREATE OR REPLACE FUNCTION TRI_DELETE_FUNC() RETURNS TRIGGER AS           $$           DECLARE           BEGIN                   DELETE FROM test_trigger_des_tbl WHERE id1=OLD.id1;                   RETURN OLD;           END           $$ LANGUAGE plpgsql;--创建DELETE触发器。gaussdb=# CREATE TRIGGER delete_trigger BEFORE DELETE ON test_trigger_src_tbl FOR EACH ROW EXECUTE PROCEDURE tri_delete_func();--修改触发器的名称。gaussdb=# ALTER TRIGGER delete_trigger ON test_trigger_src_tbl RENAME TO delete_trigger_renamed;--删除触发器。gaussdb=# DROP TRIGGER delete_trigger_renamed ON test_trigger_src_tbl;--删除函数。gaussdb=# DROP FUNCTION tri_delete_func;--删除源表及触发表。gaussdb=# DROP TABLE test_trigger_src_tbl;gaussdb=# DROP TABLE test_trigger_des_tbl;