赞
踩
The ability to temporarily enable or disable a trigger is provided by ALTER TABLE, not by ALTER TRIGGER
, because ALTER TRIGGER
has no convenient way to express the option of enabling or disabling all of a table's triggers at once.
参考:
https://www.postgresql.org/docs/current/static/sql-altertrigger.html
https://www.postgresql.org/docs/current/static/sql-altertable.html
alter table tab_xxx enable trigger [ trigger_name
| ALL | USER ]
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。