Forum OpenACS Q&A: Response to how to drop unique constraint

The unique constraint should be droppable by simply dropping the associated unique index.

Many other constraints can only be removed by the copy-to-temp-table technique.  More complete add/drop functionality is on the todo list, but I don't remember offhand if it's up for PG 7.2 or not.  With the improvements we've seen in PG, add/drop improvements increase in relative priority with each release.