Syntax error on drop constraint in Postgres

[expired user #10655]'s profile image [expired user #10655] posted 7 years ago in General Permalink

Hi.

Dropping a constraint in Postgres on any table produces this error.

To replicate: remove any constraint in the Indexes tab on the table view. Switch to another table. Click yes when prompted to save the changes in current table. Dropping PRIMARY KEY:

ERROR: syntax error at or near "PRIMARY" LINE 2: DROP PRIMARY KEY

Dropping UNIQUE constraint:

ERROR: syntax error at or near ""UNIQUE"" LINE 2: DROP INDEX "UNIQUE"

:)

Please login to leave a reply, or register at first.