Re: CREATE INDEX CONCURRENTLY cannot be executed within a pipeline

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Timur <timur(dot)luchkin(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: CREATE INDEX CONCURRENTLY cannot be executed within a pipeline
Date: 2023-02-10 17:38:43
Message-ID: 4139340.1676050723@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Timur <timur(dot)luchkin(at)gmail(dot)com> writes:
> After the release of PostgreSQL 14.7 Liquibase started to fail with:

> Reason: liquibase.exception.DatabaseException: ERROR: CREATE INDEX
> CONCURRENTLY cannot be executed within a pipeline [Failed SQL:

You need to report that to the Liquibase authors. They're
trying to do something that's unsupported, but which we previously
failed to detect. Basically: you can't do that in a pipeline
because there will already be an open transaction, which would
accidentally get committted by the CREATE INDEX CONCURRENTLY.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2023-02-10 20:14:56 Re: BUG #17786: Assert on indxpath.c
Previous Message Timur 2023-02-10 16:24:23 CREATE INDEX CONCURRENTLY cannot be executed within a pipeline