Re: Issue while creating index dynamically

On Thu, Jul 25, 2024 at 7:42 AM veem v <veema0000@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
thenbe 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