Re: [DOCS] postgres index rebuild
| От | Euler Taveira |
|---|---|
| Тема | Re: [DOCS] postgres index rebuild |
| Дата | |
| Msg-id | CAHE3wgiUSijFbCajxEo9+dhXakAaZZXxJWW1DBoUHUijQ8jSJQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | [DOCS] postgres index rebuild (jashobanta.mahapatra@mahindracomviva.com) |
| Ответы |
Re: [DOCS] postgres index rebuild
|
| Список | pgsql-docs |
2017-05-25 9:38 GMT-03:00 <jashobanta.mahapatra@mahindracomviva.com>:
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 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.
--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
В списке pgsql-docs по дате отправления: