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

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

Helen,

> I might be mistaken, but I think he was talking about a SP
> containing a
> PLAN which had a reference to an integrity index (RDB$PRIMARYnnn,
> etc.).  If so, he got the wrong answer about current gbak
> behaviour, which does NOT maintain the original identifiers for
> integrity indexes when restoring.

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.


Dmitry