CREATE INDEX CONCURRENTLY cannot run inside a transaction block

[jaffarhussain1011]

Hi,

I am using execute method and getting following error:

Base.php(381) : pg_query(): Query failed: ERROR: CREATE INDEX CONCURRENTLY cannot run inside a transaction block

My exact query is as following:
$this->get_adapter()->execute_ddl("DROP INDEX IF EXISTS ix_events_type_cd;");
$this->get_adapter()->execute_ddl("CREATE INDEX CONCURRENTLY IF NOT EXISTS
ix_events_type_cd ON public.xtable USING btree (type_cd);");

I am using postgres,
Any would be appreciated.

thanks,
Jaffar