Bug 152426 - Add unique constraint on rhnPackageNEVRA for name_id, evr_id, package_arch_id
Summary: Add unique constraint on rhnPackageNEVRA for name_id, evr_id, package_arch_id
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Other
Version: unspecified
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: James Slagle
QA Contact: Mike McCune
URL:
Whiteboard:
Depends On:
Blocks: 147875
TreeView+ depends on / blocked
 
Reported: 2005-03-29 14:05 UTC by James Slagle
Modified: 2007-10-24 02:15 UTC (History)
1 user (show)

Fixed In Version: RHN 4.0.0
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2005-09-01 02:53:05 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)

Description James Slagle 2005-03-29 14:05:18 UTC 
Add unique constraint on rhnPackageNEVRA for name_id, evr_id, package_arch_id. 
This will resolve a few customer issues that have come up (bz #151797).
Comment 1 James Slagle 2005-06-23 20:13:07 UTC 
unique constraint added to satellite schema and hosted.

No testplan.
Comment 2 Vlady Zlatkin 2005-07-08 21:42:46 UTC 
how can this be tested?
Comment 3 James Slagle 2005-07-11 21:02:31 UTC 
Registering a system to a satellite would make use of the table where this
constraint has been added.

There isn't really a good way to test this, we opened this bug b/c we saw a
customer come up with an issue where this constraint would have prevented the
issue, but we never could reproduce the customer's problem.
Comment 4 Mike McCune 2005-08-02 00:34:25 UTC 
will qa this.
Comment 5 Mike McCune 2005-08-03 21:53:33 UTC 
I registered a few systems successfully using the latest ISO against a sat.

This is prod_ready then :-)
Note You need to log in before you can comment on or make changes to this bug.