The constraints basically disabled any query that tried to delete a job because the cascaded delete was terribly slow without an index. This drops the constraint completely because it was not needed in the first place (proposals/candidates can only be deleted together with their jobs).
The constraints basically disabled any query that tried to delete a job because the cascaded delete was terribly slow without an index. This drops the constraint completely because it was not needed in the first place (proposals/candidates can only be deleted together with their jobs).
This is similar to https://github.com/biigle/maia/commit/5cb27dcc46aa07aa96cf69328c736add1b60ea1d