Pat Maddox pergesu at gmail.com
Tue Apr 24 04:39:09 PDT 2007
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


More information about the Slony1-general mailing list