At 06:35 AM 18/07/2006, Thomas Steinmaurer wrote:

> > "Bob Murdoch" <mailgroups@...> wrote:
> >
> >>
> >>What if the index is the primary key? Can I alter inactive/active?
> >
> >
> > -- to deactivate it
> > update rdb$indices
> > set rdb$index_inactive = 3
>
>Anything special with using 3 instead of 1? Or does it need to be a
>value > 0?

Something Dmitry told me recently: an 'inactive' flag of 3 is set by
gbak restore when it can't activate an index for some reason, e.g.
duplications in a unique index.

If the flag is 3, then the engine will permit

alter index MY_PK_INDEX active

./heLen