ddlutils tries to drop an index in postgres which is really a unique constraint
-------------------------------------------------------------------------------
Key: DDLUTILS-221
URL: https://issues.apache.org/jira/browse/DDLUTILS-221
Project: DdlUtils
Issue Type: Bug
Components: Core - PostgreSql
Affects Versions: 1.0
Reporter: Chris Hyzer
Assignee: Thomas Dudziak
I have a unique constraint on a col, and ddltuils tries to drop it like its
only an index, which gives an error:
[sql] Failed to execute: DROP INDEX fields_name_type_unq
BUILD FAILED
C:\mchyzer\isc\dev\grouper-qs-1.2.0\grouper\build.xml:769:
org.postgresql.util.PSQLException: ERROR: cannot drop index
fields_name_type_unq because constraint fields_name_type_unq on table
grouper_fields requires it
The solution would be to look at db metadata, see that it is a constraint, drop
the constraint, then drop the index (if it isnt dropped by dropping the
constraint)
Thanks,
chris
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
