Learn more about these different git repos.
Other Git URLs
When trying to update schema, with the provided /usr/share/doc/koji/docs/schema-update-1.30-1.31.sql file :
/usr/share/doc/koji/docs/schema-update-1.30-1.31.sql
psql koji < /usr/share/doc/koji/docs/schema-update-1.30-1.31.sql BEGIN ERROR: syntax error at or near "INCLUDE" LINE 1: ...sion || '-' || release || '.' || arch || '.rpm')) INCLUDE (i... ^ ROLLBACK
FWIW, it's on a RHEL 8 machine, running postgresql-server-10.19-1.module_el8.6.0+1047+4202cf9a.x86_64
(copied from #3595 duplicate) Update https://docs.pagure.org/koji/supported_platforms/ with minimum postgres version. Last sql update used CREATE INDEX INCLUDE option which is present there from PG11, so older dbs can't be updated. We should be aware of such problems.
Metadata Update from @tkopecek: - Custom field Size adjusted to None
Metadata Update from @tkopecek: - Issue set to the milestone: 1.31.1
Just FYI - it is safe to drop INCLUDE part as a workaround.
PR #3615
Metadata Update from @tkopecek: - Issue tagged with: testing-ready
Metadata Update from @mfilip: - Issue tagged with: testing-done
Commit 369d929 fixes this issue
Commit c110569 relates to this ticket
Log in to comment on this ticket.