Updates cannot be edited in staging due to BDR

[bowlofeggs]

BDR doesn't allow writes to tables that don't have primary keys. I got an error message from staging when trying to edit an update:

Cannot run UPDATE or DELETE on table update_bug_table because it does not have a PRIMARY KEY.

This table is defined in a block of association tables, and none of them seem to have primary keys.

We will need to fix this before BDR is deployed to production.

[bowlofeggs]

Today I found that I also cannot log in to staging Bodhi, also due to BDR from a different block of association tables:

https://github.com/fedora-infra/bodhi/blob/2.5.0/bodhi/server/models.py#L2242-L2252

Cannot run UPDATE or DELETE on table user_group_table because it does not have a PRIMARY KEY.

So we'll need to fix those as well.

[bowlofeggs]

This prevents the staging server from being useful for testing because I cannot log in to staging. Thus, I am raising it to critical priority and setting a goal to include it in bodhi 2.7.0.

[bowlofeggs]

@puiterwijk sent me this link, which might be useful for solving the duplicates: https://wiki.postgresql.org/wiki/Deleting_duplicates