> I get the following error on our indexes for firebird. Does anyone
> know why?
>
> Dynamic SQL Error
> SQL error code = -204
> Ambiguous field name between table RDB$INDICES and table
> RDB$INDEX_SEGMENTS
> RDB$INDEX_NAME

Firebird does not allow ambigous names in database queries anymore (IB
6.0 allowed them). You have to correct your queries to avoid ambiguity:

If your query was

select rdb$index_name from rdb$indices a, rdb$index_segments b where...

you have to change it to

select a.rdb$index_name from ...
or
select b.rdb$index_name from ...

Best regards,
Roman Rokytskyy