postgres index rebuild

From: jashobanta(dot)mahapatra(at)mahindracomviva(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: postgres index rebuild
Date: 2017-05-25 12:38:42
Message-ID: 20170525123842.27681.14358@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Magnus Hagander 2017-05-25 14:14:48 Re: Legal Notice page in 10 not "backwards compatible" in online docs
Previous Message sundeep.sahoo 2017-05-25 03:57:21 Incorrect commands in manual for 9.6