From: jashobanta.mahapatra@mahindracomviva.com
To: pgsql-docs@postgresql.org
Subject: postgres index rebuild
Date: Thu, 25 May 2017 12:38:42 +0000
Message-ID: <20170525123842.27681.14358@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: jashobanta.mahapatra@mahindracomviva.com
Subject: Re: postgres index rebuild
In-Reply-To: <20170525123842.27681.14358@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox