Re: [firebird-support] Rename a key through write to a system table
On 18.7.2013 7:08, Josef Kokeš wrote: Hi! I realize that the official answer to can I rename an index is no, and that directly writing to the system tables is generally a poor idea. But still: How much damage can I cause by UPDATE on RDB$INDEX_NAME in RDB$INDICES and RDB$INDEX_SEGMENTS? I have this itch I would like to scratch, where I created a primary key of a table with a bad name... The target Firebird versions are 2.1 and 2.5. Thanks, Pepak Never mind, I actually *can* drop a primary key and create it again. That solves the problem nicely. Pepak ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Rename a key through write to a system table
I realize that the official answer to can I rename an index is no, and that directly writing to the system tables is generally a poor idea. But still: How much damage can I cause by UPDATE on RDB$INDEX_NAME in RDB$INDICES and RDB$INDEX_SEGMENTS? I have this itch I would like to scratch, where I created a primary key of a table with a bad name... The target Firebird versions are 2.1 and 2.5. Thanks, Pepak Never mind, I actually *can* drop a primary key and create it again. That solves the problem nicely. Right, as long as no FK constraint references the primary key fields in question. You then would first need to drop the FK constraint(s). -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] Rename a key through write to a system table
Hi! I realize that the official answer to can I rename an index is no, and that directly writing to the system tables is generally a poor idea. But still: How much damage can I cause by UPDATE on RDB$INDEX_NAME in RDB$INDICES and RDB$INDEX_SEGMENTS? I have this itch I would like to scratch, where I created a primary key of a table with a bad name... The target Firebird versions are 2.1 and 2.5. Thanks, Pepak ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/