Forum OpenACS Development: Re: Re: acs_objects_context_object_un

Collapse
Posted by Malte Sussdorff on
The problem is described in https://openacs.org/forums/message-view?message%5fid=447214.

What I would change is to create the index and drop the unique constraint, as this seems to me to be the propper thing to do. But Dave explained that an index on (object_id,context_id) will create a unique constraint.

Now my question would be, why is that the case. But maybe I should ask over at postgresql. Any way how this could be detected? I mean if the database is creating a unique constraint, shouldn't this show up in \d ?