2017-05-25 9:38 GMT-03:00 <jashobanta.mahapa...@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 <http://www.timbira.com.br>
