From: | "Pat Maddox" <pergesu(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Setting table ids in slony |
Date: | 2007-04-23 17:49:59 |
Message-ID: | 810a540e0704231049s3f0b7aabsa8fab0cf91bbb814@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2007-04-23 18:08:02 | Re: ERROR: Failed to build any 5-way joins |
Previous Message | Tom Lane | 2007-04-23 17:23:09 | Re: Help debugging a hung postgresql client connection |