quier [mailto:michael.paqu...@gmail.com]
Sent: Saturday, May 27, 2017 1:44 AM
To: Euler Taveira
Cc: Jashobanta Mahapatra; pgsql-docs@postgresql.org
Subject: Re: [DOCS] postgres index rebuild
On Fri, May 26, 2017 at 3:24 PM, Euler Taveira wrote:
> CIC can't be executed inside a transaction block or a
On Fri, May 26, 2017 at 3:24 PM, Euler Taveira wrote:
> CIC can't be executed inside a transaction block or a user-defined function
> because it involves some phases that are not easily rollback-able. Instead
> create a small script with those commands.
If you are interested in the reasons why mu
2017-05-25 9:38 GMT-03:00 :
>
> 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"
CIC can't be executed inside a
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 wi
