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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to