You can't drop a PSQL Constraint using db_drop_unique_key() because Drupal appends _key to the constraint name

Updated: Comment #0

Problem/Motivation

- Create any random constraint (e.g. using the SchemaAPI)
- Create a method to execute $result = db_drop_unique_key('tablename', 'constraintName');
- Check the $result variable

This has been tested and verified using PostgreSQL v8.4.4 and PostgreSQL v9.1.9
If I do execute SELECT * FROM pg_constraint on any of my PostgreSQL machines I do find only *very few* constraints with a _key suffix.

Proposed resolution

- Open \includes\database\pgsql\schema.inc line 468
- Replace $name . '_key' by $name

Remaining tasks

??

User interface changes

- None?

API changes

- None?

Related Issues

- None?