RE: [Firebird-devel] Syntax and use of named PK & FK for use in PLANs in FB1.5?

[Dmitry Y. <di...@us...>]

Ann,

> >Sorry, but it DOES. Every RDB$PRIMARY34 or RDB$FOREIGN56
> will have exactly
> >the same name after restore and will correspond to the same
> tables/fields.
> >Only recreating a database from script will rename these indices.
>
> Yes, that was a fix in V5 time I think.  At first the numbers
> were generated on creation but that broke nearly every PLAN
> created.  Now the index names are stable across backup/restore.

Integrity index names are assigned by either DDL or DYN layer (depending of
a couple of conditions). Autogeneration of system names is always done by
DYN. Both of them have nothing to do with the gbak processing, because it
operates with system tables directly via GDML. The current gbak restores
exactly the same records as it read during the backup, so I believe we don't
have any problems, neither in the engine, nor in gbak.


Dmitry