Tue Dec 7 01:51:15 PST 2004
- Previous message: [Slony1-general] Adding tables to an existing set in Slony1?
- Next message: [Slony1-general] slony on database with no primary keys ...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Adding tables to an existing set in Slony1?
- Next message: [Slony1-general] slony on database with no primary keys ...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list