I want to start using slony for replication, and have a question about
setting table IDs when creating replication sets. The docs say that
you have to be careful in what IDs you assign to the tables - if
there's a relationship between two tables, the parent needs to have a
lower ID.
So let's take two tables, users and articles.
Users:
id serial primary key
name varchar(80)
Articles:
id serial primary key
title varchar(80)
body text
user_id (foreign key on users.id)
If I'm using slony to replicate this db, then I need to give the users
table an id of 1, and articles should be 2, right?
What happens when I add a table that's higher up on the heirarchy?
For example now I want to add a companies table.
Companis:
id serial primary key
name varchar(80)
Users:
company_id (fkey on companies.id)
Now would I have to reassign IDs for the tables? companies->1,
users->2, articles->3?
Thanks for any help.
Pat
