The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.3/static/routine-reindex.html Description:
Hi, As per the doc provided by postgres, for rebuild index we can do concurrently which doesn't take any lock. 1)create new index concurrently with different name 2)drop old index 3)rename new index with old index name my question is I was trying to keep all the queries(create, drop, alter) in a function. And 'll call the function when required. But i got below error "CREATE INDEX CONCURRENTLY cannot be executed from a function or multi-command string" Please help me on this Thanks, jasho -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
