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/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060808/052b1573/attachment.bin