Brad Nicholson wrote:
> On Tue, 2009-04-28 at 19:27 -0400, Geoffrey wrote:
>> Quick question.  If I merge set 3 into set 1, I assume the tables in set 
>> 3 that are merged into set 1 will receive the next table id available in 
>> set 1?
> 
> Table ID will remain unchanged when you merge sets.

I guess I don't understand this.  If I add it to a new set, then I 
assume the id will be set to 1 for the first table.

If I merge it to an existing set where a table id of 1 already exists, 
then the table id of that table will have to be different.  For example:

set 1:

table foo has id 1
table bar has id 2
table foobar has id 3

drop table bar
create set 2
add table bar to set 1 (assuming it will get table id 1)

merge set 2 to set 1

What will table id for bar be in set 1 now?


-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin