最近在學習Postgresql寫了一個簡單的觸發器
create or replace function his_sdata.student_delete_trigger()
returns trigger as $$
begin
delete from his_sdata.score where student_no =old.student_no;
return old;
end;
$$
language plpgsql;
create trigger delete_student_trigger
after delete on his_sdata.student
for each row execute procedure his_sdata.student_delete_trigger ();
然后在洗掉資料的時候報錯：
SQL 錯誤 [0A000]: ERROR: function cannot execute on segment because it issues a non-SELECT statement (seg0 127.0.0.1:33000 pid=56887)
Detail:
SQL statement "delete from his_sdata.score where student_no = $1 "
PL/pgSQL function "student_delete_trigger" line 2 at SQL statement
ERROR: function cannot execute on segment because it issues a non-SELECT statement (seg0 127.0.0.1:33000 pid=56887)
Detail:
SQL statement "delete from his_sdata.score where student_no = $1 "
PL/pgSQL function "student_delete_trigger" line 2 at SQL statement
ERROR: function cannot execute on segment because it issues a non-SELECT statement (seg0 127.0.0.1:33000 pid=56887)
Detail:
SQL statement "delete from his_sdata.score where student_no = $1 "
PL/pgSQL function "student_delete_trigger" line 2 at SQL statement
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/55809.html
標籤：PostgreSQL