Hello,

Has anyone tried Slony-I on a partitioned table?

I'm working on some tests per a question from a local user. He says that
he cannot add child tables to replication set, because child the table
does not have primary keys. Because of DO INSTEAD, no data is inserted
to master table, so there is no replication :(

Any solution on this?

I thought of adding a trivial serial column to each child table, which
will act as a primary key;  so that I can add them into replication
set. 

Does it sound good?

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

Attachment: signature.asc
Description: This is a digitally signed message part

_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to