> sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) constraint "packages_copr_pkgname" of relation "package" does not exist

How old sources do you have? This has been fixed in https://pagure.io/copr/copr/c/e47e6cd41c3e72f58a38a0f25b95b1e5c92b19de?branch=master.

Please upgrade to the latest sources (or downgrade to the latest stable release copr-frontend-1.103-1 :)) and setup your db from scratch (dropdb coprdb; createdb coprdb; ./manage.py create_db --alembic alembic.ini) and then run alembic downgrade ... and alembic upgrade head.

clime