On Thu, Jul 25, 2024 at 7:42 AM veem v <veema0000@xxxxxxxxx> wrote: > I was thinking the individual statement will work fine if I pull out those from the begin..end block, as those will then be not bounded by any outer transaction. > However, When I was trying it from dbeaver by extracting individual index creation statements rather from within the "begin ..end;" block, it still failed with a different error as below. Why is it so? > > "SQL Error [25001]: Error: create index concurrently cannot be executed within a pipeline " Perhaps it's an artifact of DBeaver using [LibPQ's pipeline mode][1] when executing scripts? Maybe give it a try in `psql` instead. Or find a setting to disable pipeline mode? (which is new to v14). [1]: https://www.postgresql.org/docs/current/libpq-pipeline-mode.html
