Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

possibility to add alias name for index or possibility to rename index [CORE1960] #2398

Open
firebird-automations opened this issue Jun 25, 2008 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

It would make more sense for you to explicitly name your constraints. In this case indices will get proper stable names that could be used in plans.

@firebird-automations
Copy link
Collaborator Author

Commented by: @livius2

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

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: @livius2

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 :/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant