| Subject | Re: RES: [firebird-support] problem with restore |
|---|---|
| Author | Lucas Franzen |
| Post date | 2012-09-12T14:44:16Z |
Am 12.09.2012 16:35, schrieb Sergio:
I think all indexes named RDB$INDEX_nnn are on system tables.
(Unless you create one with that naming convention which I never did and
never will do)
You can examine that in the system tables.
SELECT
RDB$RELATION_NAME
FROM RDB$INDICES
WHERE
RDB$INDEX_NAME = 'RDB$INDEX_39'
> Thanks Fabiano!RDB$INDEX_39 is an index on RDB$ROLES.
>
> By mistake, I was using an old gbak with a 2.5 databse. With the correct gbak the problem in gone!!!
>
> By the way... How can seek that index? I did a metadata search with FlameRobin, but it returned nothing...
I think all indexes named RDB$INDEX_nnn are on system tables.
(Unless you create one with that naming convention which I never did and
never will do)
You can examine that in the system tables.
SELECT
RDB$RELATION_NAME
FROM RDB$INDICES
WHERE
RDB$INDEX_NAME = 'RDB$INDEX_39'