On Thu, Jul 25, 2024 at 7:42 AM veem v <veema0...@gmail.com> 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
