Re: 8 and 8i default constraint behavior

On Wed, 9 May 2001, howardjr_at_www.com wrote:

> Possibly. My real problem is with unique indexes used to
> enforce primary and unique key constraints taking it upon
> themselves to be dropped whenever I disable a constraint.

How would a primary constraint be disabled if the unique index weren't dropped?

> As a DBA I'd prefer to be in charge of what gets dropped and
> when, thanks very much. The point being that primary and
> unique keys that are created deferrable get NON-unique indexes
> to enforce them,

So these non-unique indexes get used by the primary constraint to quickly figure out uniqueness but they don't actually enforce uniqueness?

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.