本文介绍了关系“旧”不存在的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我尝试执行此脚本时,出现错误:错误:关系旧不存在。 脚本:
When i try execute this script, i get an error: ERROR: relation "old" does not exist. Script:
update organization set row_status = 30;我发现了这样的问题,但他们没有帮助我。 我的触发器:
I found some question like this, but their dont help me. My trigger:
Create OR REPLACE function PMigrateDataToHistory() returns trigger as $PMigrateDataToHistory$ begin insert into organization_history select * from OLD; delete from organization as org USING OLD as o where o.id = org.id and o.version = org.version; insert into organization select n.id, n.created_at, n.updated_at, n.row_status, n.version + 1, n.resource from NEW as n; end; $PMigrateDataToHistory$ LANGUAGE plpgsql; CREATE TRIGGER TRMigrateDataToHistory AFTER update or delete ON organization FOR EACH ROW EXECUTE PROCEDURE PMigrateDataToHistory();推荐答案
对于第一个 INSERT ,使用类似的
For the first INSERT, use something like
INSERT INTO organization_history VALUES (OLD.*);DELETE 和第二个 INSERT 是构思错误的–首先,这会在 organization 表中造成很多不必要的混乱。
The DELETE and the second INSERT are ill-conceived – for one, this will cause a lot of unnecessary churn in the organization table.
使用之前触发器,将1添加到 NEW.version 并返回 NEW 。这将导致在记录写入表之前 调整值。
It would be much better to use a BEFORE trigger, add 1 to NEW.version and return NEW. This would cause the values to be adjusted before the record is written to the table.
更多推荐
关系“旧”不存在
发布评论