Forum OpenACS Q&A: how to drop unique constraint

Collapse
1: how to drop unique constraint
Posted by David Kuczek on 05/28/01 03:49 PM
Can I somehow drop the screen_name unique constraint?

I read through the documentation and they said that I have to move the
table to a temp and then copy it back?!! I hope that I missed
something.

If not how do I manage this with all the other constraints on users???

Collapse
2: Response to how to drop unique constraint (response to 1)
Posted by Don Baccus on 05/28/01 04:55 PM
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.