On Dec 12, 2007 12:06 PM, Alan Hodgson <ahodgson at simkin.ca> wrote:

> On Wednesday 12 December 2007, "Josh Harrison" <joshques at gmail.com> wrote:
> > And when i run this script I get this error...
> > PGRES_FATAL_ERROR select "_slony_example".subscribeSet(1, 1, 2, 'f');  -
> > sERROR:  Slony-I: subscribeSet(): set 1 not found
>
> It appears you haven't created set 1.
>

You are right...
I got it to work now. This is the link that Im trying now
http://slony.info/adminguide/slony1-1.2.6/doc/adminguide/firstdb.html

It replicates the tables that have their own primary key.
But for those ones that donot have their own PK(table 'history' in the above
given link) and needs a serial key to be generated by Slony, it doesnt
replicate the data. Why?

Also when it has to generate its own PK, does it add an extra column to the
table ? For example it has added an extra_column called
_Slony-I_slony_example_rowID to the master and slave database's 'history'
table.  Can you avoid this?

Thanks
josh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20071212/=
2d48f482/attachment-0001.htm