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

[Raymond K. <pr...@ch...>]

Dmitry Yemanov wrote:
> 
> 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

Wrong! I just tried it with FB1.0:

gbak: ERROR: index RDB$FOREIGN66 cannot be used in the specified plan
gbak: ERROR:     index RDB$FOREIGN66 cannot be used in the specified plan
gbak: ERROR: Exiting before completion due to errors.
-- 
Raymond Kennington
Programming Solutions
W2W Team B