Subject Re: [firebird-support] Constraints and indexes automagically renamed
Author Ann W. Harrison
lysander_fb wrote:
> I try to give meaningful names to everything in a database, and have
> my own nomenclatura-system. This applies not only to field-names, but
> of course also to index-names and constraints.
> Now, somehow, after some time, my identifiers get exchanged.
> Constraint "PI_3044A" (for the first primary key in schema 3044) would
> suddenly become "INTEG_28" and the corresponding index will be renamed
> from "IxP_3044A" to something like "RDB$Primary_12".
> Right now I do suspect it happens with backing up and restoring the
> database, but couldn't nail it down just now.

What version of Firebird are you using? Over time we've allowed more
and more stable, user defined names for "system indexes" - those that
support foreign and primary keys. There's a lot of inertia in the
system though that tries to reimpose the old system generated names.