Launchpad itself

deleting a poll fails "foreign key constraint"

Bug #279473 reported by Steve McInerney
This bug report is a duplicate of:  Bug #251770: we should be able to delete poll. Edit Remove
6
Affects Status Importance Assigned to Milestone
Launchpad itself
New
Undecided
Unassigned

Bug Description

Attempting to complete question: https://answers.edge.launchpad.net/launchpad/+question/47103

Manual deletion fails with:

ERROR: update or delete on table "poll" violates foreign key constraint "$1" on table "polloption"
DETAIL: Key (id)=(240) is still referenced from table "polloption".

Revision history for this message
Guilherme Salgado (salgado) wrote :

Steve, I could give you the SQL to delete that poll, but I think the real bug here is that we can't delete a poll through the UI: bug 251770

Revision history for this message
Steve McInerney (spm) wrote :

Thanks Guilherme.

If you could PM me said SQL or update the LOSA HOWTO page with said SQL, I'll complete the question for Ricardo?
Not an ideal situation, but at least gives us a workaround for the nonce.

Cheers!
- Steve

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Related questions

Remote bug watches

Bug watches keep track of this bug in other bug trackers.