Marc,

I wrote a little utility a while back that breaks up the Slony setup 
process into its three default component parts: tables with unique 
constraints, tables with no unique constraints, and sequences.

The utility creates a slonik script broken into these three sections 
and automatically adds the table add key statements for tables for 
which it doesn't find a primary key.

If the developers see any use in this, I'd be happy to contribute it to 
altperl. I'd also like suggestions for improvements!

You can see the current version at:

http://www.sitening.com/meta-slonik

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Dec 6, 2004, at 7:51 PM, Marc G. Fournier wrote:

> after the problems with my install on the dns table, and learning 
> of/using slony_setup.pl, I'm curious as to how ppl are dealing with a 
> database that contains tables with no primary keys?
>
> when I did my original 'manual' config, I had to add:
>
> table add key ( node id = 1, fully qualified name = 
> 'public.dns_records' );
>
> so that the table had a key that slony could work on ...
>
> when I tried to do my first install after using setup_slony.pl, I had 
> to uninstall and go in and manually add the above line so that it 
> would get added, since the setup doesn't even seeem to try and 
> detect/add accordingly ...
>
> if I had run setup_slony.pl to replicate the complete database, I 
> would have had to go through and search through and add a whack of 
> these ...
>
> If there a way of 'adding' a table such that it will auto-add a serial 
> if one doesn't exist that slony can use?
>
> ----
> Marc G. Fournier           Hub.Org Networking Services 
> (http://www.hub.org)
> Email: scrappy at hub.org           Yahoo!: yscrappy              ICQ: 
> 7615664
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general