pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
CREATE INDEX CONCURRENTLY cannot be executed within a pipeline 2+ messages / 2 participants [nested] [flat]
* CREATE INDEX CONCURRENTLY cannot be executed within a pipeline @ 2023-02-10 16:24 Timur <timur.luchkin@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Timur @ 2023-02-10 16:24 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org Hi, 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: There are no any updates to the Liquibase during last time. It uses JDBC, not libpq, so don't know how its related to pipelines... ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: CREATE INDEX CONCURRENTLY cannot be executed within a pipeline @ 2023-02-10 17:38 Tom Lane <tgl@sss.pgh.pa.us> parent: Timur <timur.luchkin@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2023-02-10 17:38 UTC (permalink / raw) To: Timur <timur.luchkin@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org Timur <timur.luchkin@gmail.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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-02-10 17:38 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-02-10 16:24 CREATE INDEX CONCURRENTLY cannot be executed within a pipeline Timur <timur.luchkin@gmail.com> 2023-02-10 17:38 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox