Bug 534386 (RHQ-1188) - dbutils should have a way to create named constraints
Summary: dbutils should have a way to create named constraints
Keywords:
Status: NEW
Alias: RHQ-1188
Product: RHQ Project
Classification: Other
Component: Database
Version: unspecified
Hardware: All
OS: All
low
medium
Target Milestone: ---
: ---
Assignee: Nobody
QA Contact:
URL: http://jira.rhq-project.org/browse/RH...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2008-11-26 17:29 UTC by John Mazzitelli
Modified: 2023-01-20 05:19 UTC (History)
0 users

Fixed In Version:
Clone Of:
Environment:
Last Closed:
Embargoed:


Attachments (Terms of Use)

Description John Mazzitelli 2008-11-26 17:29:00 UTC
we need a way for dbutils -schema.xml files to generate named constraints.  On Oracle, we rely on it generating names - but that makes it hard to db-upgrade them later.

Comment 1 John Mazzitelli 2008-11-26 17:32:42 UTC
this may or may not already be supported by dbutils - we need to look to see if there is any XML that supports the naming of constraints. If not, we need to add it.  Either way, we then need to alter our -schema.xml files to create new constraint names (perhaps have db-upgrade to rename them too so error messages for constr. vios are easier to understand?)

Comment 2 Red Hat Bugzilla 2009-11-10 20:27:39 UTC
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-1188


Comment 3 wes hayutin 2010-02-16 17:10:12 UTC
mass add of key word FutureFeature to help track

Comment 4 Corey Welton 2010-08-18 15:22:02 UTC
mazz, is this still an issue?

Comment 5 John Mazzitelli 2010-08-24 17:41:28 UTC
if we plan on moving to Liquibase, we should close this as obsolete.

if we do not plan on that, but we continue to use dbsetup/dbupgrade, we need to address this.


Note You need to log in before you can comment on or make changes to this bug.