postgresql 使用函数跟触发器将表改成自读

CREATE OR REPLACE FUNCTION prevent_write()
RETURNS TRIGGER AS $$
BEGIN
  RAISE EXCEPTION 'This table is read-only';
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER readonly_trigger
BEFORE INSERT OR UPDATE OR DELETE ON test_mod_szlib_catalog.marc_record
FOR EACH ROW
EXECUTE PROCEDURE prevent_write();

以上作用是生成一个函数，当进行增删改的时候报错This table is read-only