> -----Original Message-----
> From: firebird-devel-admin@...
> [mailto:firebird-devel-admin@...]On Behalf Of Ann W.
> Harrison
> Sent: Domingo 8 de Julio de 2001 18:01
>
> In the course of chasing down a bug, I realized that a number
> of indexes in the system tables which should be unique are not.
> I've changed that. The indexes affected are

[snip]

> index RDB$INDEX_36 for RDB$FIELD_DIMENSIONS on RDB$FIELD_NAME

Mom,
respectfully, either you had a typo here or you nuked rdb$field_dimensions.
The index should be unique on
rdb$field_name + rdb$dimension

If you make it unique only on rdb$field_name, it means I only can define
one-dimensional arrays and this declaration will fail
...field3 integer[4,5,7]

Hence, in this case, either you make the index span rdb$dimension, too or
you let it non-unique as it was until now.

C.
---------
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://www.cvalde.com - http://firebird.sf.net