--让主键失效
alter table table_name disable primary key cascade;
--重建表或删除相应数据
truncate table table_name ;
delete from table_name where ...;
--让主键重新生效
alter table table_name enable primary key;

我菜，看不太懂