postgres的分表

最新推荐文章于 2023-12-20 20:18:37 发布

pc_2012

最新推荐文章于 2023-12-20 20:18:37 发布

阅读量528

点赞数

分类专栏：代码备份文章标签： sql postgres 分表

本文链接：https://blog.csdn.net/u011990157/article/details/11169621

版权

代码备份专栏收录该内容

3 篇文章 0 订阅

订阅专栏

CREATE TABLE audit.A_audit_1 ( CHECK (end_rev_time > '2013-09-04 17:30:08.942' or end_rev_time is null) ) INHERITS (audit.A_audit);

CREATE TABLE audit.A_audit_2 ( CHECK (end_rev_time <= '2013-09-04 17:30:08.942') ) INHERITS (audit.A_audit);




CREATE INDEX action_audit_A_1 ON audit.A_audit_1 USING btree (end_rev_time);

CREATE INDEX action_audit_A_2 ON audit.A_audit_2 USING btree (end_rev_time);





--- Trigger function


CREATE OR REPLACE FUNCTION on_action_log_insert() 
RETURNS TRIGGER AS $$

BEGIN
 IF ( NEW.end_rev_time > '2013-09-04 17:30:08.942' or NEW.end_rev_time is null) 
		THEN
        
			INSERT INTO audit.A_audit_1 VALUES (NEW.*);
 
	ELSE
	INSERT INTO audit.A_audit_2 VALUES (NEW.*);
 
	 END IF;
 RETURN NULL;
END;

$$ LANGUAGE plpgsql;





--- Attach trigger function to table

CREATE TRIGGER action_log_insert
    
BEFORE INSERT ON audit.A_audit
    
FOR EACH ROW EXECUTE PROCEDURE on_action_log_insert();