最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

postgresql - Call multiple REINDEX CONCURRENTLY commands - Stack Overflow

programmeradmin4浏览0评论

I detected several indexes that need reindexing, then I created a simple script to call REINDEX CONCURRENTLY for them

reindex index concurrently public."chp_id2015";
reindex index concurrently public."chp_tm2015";
reindex index concurrently public."chp_or2015";

When I call the script from pgadmin I get

ERROR:  REINDEX CONCURRENTLY cannot run inside a transaction block 
SQL state: 25001

It might be some option from pgadmin (by default the session has AUTOCOMMIT ON)

发布评论

评论列表(0)

  1. 暂无评论