MIME-Version: 1.0
References: <CAB+=1TVUKY2hxPQMiu78KVXHrZ+VL+MG_z3Cr8LKqkjs6oCsGg@mail.gmail.com>
 <CANzqJaDZ=1sMh6SH0JWz5_5S=-F+8bMi_1=Cia_gkM9yJTh56w@mail.gmail.com>
 <1085896.1721766747@sss.pgh.pa.us> <CAB+=1TWipB8gTq2Pop5MWA5e=8oWTAKa3no4UB4n3bbP5E81xg@mail.gmail.com>
In-Reply-To: <CAB+=1TWipB8gTq2Pop5MWA5e=8oWTAKa3no4UB4n3bbP5E81xg@mail.gmail.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Thu, 25 Jul 2024 09:55:33 +0200
Message-ID: <CAFCRh--wrGmmpB7-er_FiXTY2BtRW6tXrWEzOQAj4RuWGnoZvQ@mail.gmail.com>
Subject: Re: Issue while creating index dynamically
To: veem v <veema0000@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Ron Johnson <ronljohnsonjr@gmail.com>, 
	pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh--wrGmmpB7-er_FiXTY2BtRW6tXrWEzOQAj4RuWGnoZvQ%40mail.gmail.com>
Precedence: bulk

On Thu, Jul 25, 2024 at 7:42=E2=80=AFAM veem v <veema0000@gmail.com> wrote:
> I was thinking the individual statement will work fine if I pull out thos=
e 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 inde=
x 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