Subject Re: Primary key names change from FB1.0 to FB1.5
Author sboydlns
--- In, "Alexander V.Nevsky"


> I'm with you on this point. But, knowing that to use IB system
> indices in plans is risky, I went another way long ago - created
> general indices I need for plans. Some of them were duplicates of PKs,
> some - composites from FKs and other columns, useful for my typical
> queries. Now, having opportunity to name system indices, I can drop
> part of such an indices, this is one-time additional work when
> migrating which in general make life easier for me and my server.

I can see where that would work, but the more indices you have the
slower inserts & updates are. So I try to keep the number of indices
to a minimum.

> It's Open Source :) If you are interested in this ports, why not to
> make it youself or hire somebody?

I don't have the time or the patience to try to do the port myself and
I don't have the budget to hire someone else to do it. :-) Believe it
or not it is simpler to keep adding version specific stuff to the
installation scripts.