Tim

I have no idea how I've achieved this but I managed to create two tables with the same name in one database!

Roy Lambert

Roy,

<< I have no idea how I've achieved this but I managed to create two tables
with the same name in one database! >>

Are you sure about this ?  I can't think of any way in which that would be
possible short of a bug in the alteration that was renaming the tables
incorrectly.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


I'm guessing that's what it was, which one I have no idea I've managed to screw up so many times this afternoon!

Roy Lambert

Roy,

<< I'm guessing that's what it was, which one I have no idea I've managed to
screw up so many times this afternoon! >>

Is it possible that what you saw was a duplicate table name in the left
treeview ?  IOW, did you try to create the same table twice ?  In such a
case it may be possible due to an interface refresh that the duplicate name
was picked up in the treeview after the create failed with an error that the
table already exists.

I've gone through the code thoroughly today and it's just basically
impossible to have a duplicate table name in a database catalog.  Any time
you tried to load such a database catalog, EDB would give you an error
saying that there was a duplicate table name present.  It's an intrinsic
part of the catalog load and validation process, all of which is done to
prevent anyone from using an invalid or corrupted catalog.  Any addition of
a table object goes through the same check, so even if EDB wanted to it
couldn't bypass this check.  It's in a separate part of the code base from
the creation and alteration and neither of these operations can override it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


The duplicate was definitely on the right hand side (might have been on the left side as well but can't swear to that) and memory (fallible) says that the two of them were there even after closing and starting EBDMan.

If I ever manage to replicate it I'l try harder to remember what I did.

Roy Lambert

Roy,

<< The duplicate was definitely on the right hand side (might have been on
the left side as well but can't swear to that) and memory (fallible) says
that the two of them were there even after closing and starting EBDMan. >>

That's what is hard to understand.  As I said before, there's really no way
that EDB will load a catalog with duplicate table names.  You can't even
have a view and a table with the same name.

Do you remember after which operation the duplicate table showed up ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Sorry no. The best I can say is some sort of table alteration / error combo or a sequence of such.

I'll probably never see it again either

Roy Lambert

Roy,

<< I'll probably never see it again either >>

Well, I hope that's the case.

--
Tim Young
Elevate Software
www.elevatesoft.com