Subject | Primary key names change from FB1.0 to FB1.5 |
---|---|
Author | sboydlns |
Post date | 2003-08-08T19:33:41Z |
In their infinite wisdom the FB developers seem to have decided to
change the way the indices generated for primary key constraints are
named. It used to be that they were named RDB$PRIMARYnn which was a
pain in the butt, but if you were careful about the way you generated
the database each constraint always got the same index name. It now
appears that the index name of the primary key constraint is the same
as the name of the constraint. This is arguably the way it should
have been all along but it breaks my application. I use the primary
key names in PLAN clauses in my stored procedures. Obviously, these
SPs will no longer compile under FB1.5.
Before I start tearing my hair out building a way to massage the DDL
to allow it to work for Interbase, Firebird < 1.5 and Firebird >= 1.5;
Is there some compatibility option that will suppress this new behaviour?
change the way the indices generated for primary key constraints are
named. It used to be that they were named RDB$PRIMARYnn which was a
pain in the butt, but if you were careful about the way you generated
the database each constraint always got the same index name. It now
appears that the index name of the primary key constraint is the same
as the name of the constraint. This is arguably the way it should
have been all along but it breaks my application. I use the primary
key names in PLAN clauses in my stored procedures. Obviously, these
SPs will no longer compile under FB1.5.
Before I start tearing my hair out building a way to massage the DDL
to allow it to work for Interbase, Firebird < 1.5 and Firebird >= 1.5;
Is there some compatibility option that will suppress this new behaviour?