[NETBEANS-1483] Cannot delete constraint indexes

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: db - DB schema
• Assignee: Unassigned
• Reporter: Alexander Romanenko
• Created: 21/Oct/18 15:03
• Updated: 21/Oct/18 15:03

Description

http://netbeans-vm.apache.org/synergy/client/app/#/specification/389/v/2

Step 4.3 using PostgreSQL

If follow previous steps to create unique constraints, they show up as indexes. Trying to delete that constraint causes error:
ERROR: index "index_name" does not exist.

Probably because some database engines have different syntax for dropping index vs constraint (which in itself is a form of index)