虽然出现这个错误很挫，但有时候还是会被你或者你的同事碰到。为了避免这个错误，postgresql数据库中可以通过触发器来解决，这里用的是plpgsql 。
1、修改postgresql.conf配置增加：custom_variable_classes = ‘limits’
重新加载：pg_ctl reload
2、创建触发器函数create or replace function zero_counter() returns trigger language plpgsql as$body$declarebegin perform set_config(\'limits.test\', \'0\', true); if tg_op = \'update\' then return new; end if; return old;end;$body$;create or replace function limit_modifications() returns trigger language plpgsql as$body$declare i int4;begin i := current_setting(\'limits.test\')::int4 1; perform set_config(\'limits.test\', i::text, true); if i > 5000 then raise exception \'% of more than 5000 row is forbidden.\', tg_op; end if; if tg_op = \'update\' then return new; end if; return old;end;$body$;3、测试forummon=# create table test as select i as id, \'password for: \' || i as pass from generate_series(1,10000) i;forummon=# create trigger zero_counter before update or delete on test for each statement execute procedure zero_counter();create triggerforummon=# create trigger limit_modifications before update or delete on test for each row execute procedure limit_modifications();create triggerforummon=# \\d test table \public.test\ column | type | modifiers | storage | stats target | description -------- --------- ----------- ---------- -------------- ------------- id | integer | | plain | | pass | text | | extended | | triggers: limit_modifications before delete or update on test for each row execute procedure limit_modifications() zero_counter before delete or update on test for each statement execute procedure zero_counter()has oids: noforummon=# update test set pass = \'qq\' where id<5003 ;error: update of more than 5000 row is forbidden.forummon=# update test set pass = \'qq\' where id<5000 ;update 4999forummon=# drop table test ;drop table总结批量操作的数量限制可以在limit_modifications中修改，切记在update不确定时先select再update。
参考连接：http://www.depesz.com/2007/07/27/update-account-set-password-new_password-oops/