Thanks Alex, This bug fix is here: https://reviews.apache.org/r/5839/
Cheers, Hugo -----Original Message----- From: Alex Huang [mailto:[email protected]] Sent: Monday, July 09, 2012 6:09 PM To: [email protected] Subject: RE: unique key and removed field It's a bug. Please file it. --Alex > -----Original Message----- > From: Hugo Trippaers [mailto:[email protected]] > Sent: Monday, July 09, 2012 1:00 AM > To: [email protected] > Subject: unique key and removed field > > Hey guys, > > While running some test scripts I noticed that the table > 'physical_network_service_providers' has a unique key on the > combination of physical_network_id and provider_name, this is > potentially a problem when we also use the removed field to indicate a device > is removed. > > In my case I added a new device, deleted it and immediately added a > new device using the same provider. This resulted in a database > exception because of a unique key violation. I think this is a bug, we > should either immediately remove the device or remove the unique > constraint and take care of this in the code using the removed field. > > Any opinions on this? > > Cheers, > > Hugo
