自己安装的openGauss环境
启动openGauss
gs_ctl -D /gauss/data/db1/ start
登录openGauss
gsql -d postgres -p 26000 -r
1.创建源表和触发表，在源表上创建insert触发器，创建操作触发表的触发器函数
create table products_s
(product_id INTEGER,
product_name Char(30)
);
create table products_t
(product_id INTEGER,
product_name Char(30)
);
CREATE OR REPLACE FUNCTION tri_insert_func() RETURNS TRIGGER AS
$$
DECLARE
BEGIN
INSERT INTO products_t VALUES(NEW.product_id, NEW.product_name);
RETURN NEW;
END
$$ LANGUAGE PLPGSQL;
CREATE TRIGGER insert_trigger
BEFORE INSERT ON products_s
FOR EACH ROW
EXECUTE PROCEDURE tri_insert_func();
2.在源表上执行insert操作，查看触发操作是否生效；禁用触发器后，再次查看触发操作是否生效
insert into products_s(product_id,product_name) values(1,‘desc’),(2,‘modify’),(3,‘add’);
select * from products_s;
select * from products_t;
ALTER TABLE products_s DISABLE TRIGGER insert_trigger;
insert into products_s(product_id,product_name) values(4,‘create’),(5,‘alter’);
select * from products_s;
select * from products_t;
3.使用系统表PG_TRIGGER和\dS+查看触发器
select * from PG_TRIGGER;
\dS+ products_s;
4.重命名触发器
alter TRIGGER insert_trigger on products_s rename to insert_trigger_rn;
5.删除触发器
DROP TRIGGER insert_trigger_rn ON products_s;
