You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
many indexes are named like RDB$INTEG_XXX RDB$PRIMARY_XXX
and can not be used in plans (in client enviroment this index can have diferent number like RDB$INTEG_123 RDB$INDEX_72)
now only posibility is to drop any dependet object and recreate index or create new index (duplicate)
2. another way different of first - is to add possibility to create alias for index name
- i suppose this is esiest to implement then index renaming
The text was updated successfully, but these errors were encountered:
but this is possible only in newer version of firebird
if you port database from ealier version e.g 1.5 you have all indexes like primary and foreign
like RDB$... automaticaly named
If it matters, then you can extract the metadata, correctly name the contraints, create a new empty database and then pump the data to the new database.
Yes but this is possible in local enviroment and really with new database
but with project relesed to many clients with no empty database - this is impossible :/
Submitted by: @livius2
Votes: 1
1. Add possibility to rename index
many indexes are named like RDB$INTEG_XXX RDB$PRIMARY_XXX
and can not be used in plans (in client enviroment this index can have diferent number like RDB$INTEG_123 RDB$INDEX_72)
now only posibility is to drop any dependet object and recreate index or create new index (duplicate)
2. another way different of first - is to add possibility to create alias for index name
- i suppose this is esiest to implement then index renaming
The text was updated successfully, but these errors were encountered: