Tue Apr 24 04:39:09 PDT 2007
- Previous message: [Slony1-general] Too much listening?
- Next message: [Slony1-general] Settings table IDs
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Too much listening?
- Next message: [Slony1-general] Settings table IDs
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list