ITADN

Historical migrations missing `CREATE INDEX procrastinate_jobs_queue_name_idx`

#1461Openindrat 创建于 2025-09-20
I
indratcommented
`procrastinate/sql/migrations/03.00.00_50_post_cancel_notification.sql` renames `procrastinate_jobs_queue_name_idx` -> `procrastinate_jobs_queue_name_idx_v1` however if soley using `procrastinate/sql/migrations` to transition the database that index won't have been created and the migration will fail. It appears that the `procrastinate_jobs_queue_name_idx` index was added to `procrastinate/sql/schema.sql` in procrastinate==0.11.0 but never added as a migration in `procrastinate/sql/migrations`.
2 条评论