#4080 [1.34.0] Database migration 1.34 -> 1.35 fails, because creating an index in this manner is not allowed.
Closed: Fixed by tkopecek. Opened by frank-mdc.

Hi,
the SQL script schema-upgrade-1.34-1.35.sql contains an error.
CREATE INDEX CONCURRENTLY is not allowed to run in an transaction.
Error:
schema-upgrade-1.34-1.35.sql:7: ERROR: CREATE INDEX CONCURRENTLY cannot run inside a transaction block
The documentation:
https://www.postgresql.org/docs/current/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY
says also:
Another difference is that a regular CREATE INDEX command can be performed within a transaction block, but CREATE INDEX CONCURRENTLY cannot.


Metadata Update from @tkopecek:
- Custom field Size adjusted to None
- Issue set to the milestone: 1.35

PR #4081

Thanks

Metadata Update from @tkopecek:
- Issue tagged with: testing-ready

Metadata Update from @tkopecek:
- Issue untagged with: testing-ready
- Issue tagged with: no_qe

Commit 8a6857f5 relates to this ticket

Commit 3fa1b1b2 relates to this ticket

Metadata Update from @tkopecek:
- Issue close_status updated to: Fixed
- Issue status updated to: Closed (was: Open)

This issue has been migrated to Fedora Forge:
https://forge.fedoraproject.org/koji/koji/issues/4080

Please continue any further discussion there.

Metadata
Related Pull Requests