触发器在postgresql中不工作

Question

我有以下表格:

测试

<表类>地址价值tbody><<tr>a150

这对我来说很好。创建表

create table "test"(
address varchar(10),
value int
);
create table table1 (
address varchar(10),
amount int
);
insert into table1 
values('abc', 0);

你触发

CREATE OR REPLACE FUNCTION address_trigger()
RETURNS trigger LANGUAGE plpgsql AS $$
BEGIN
UPDATE table1
SET amount = amount + new.value
WHERE NEW.address = table1.address;
RETURN NEW;
end;
$$;
CREATE TRIGGER update_table1
AFTER INSERT
ON "test"
FOR EACH ROW
EXECUTE PROCEDURE address_trigger();

测试它

insert into "test"
values ('abc', 10),
('abc', 30);
select * 
from table1;

输出

address amount
abc 40