kevin kempter <[EMAIL PROTECTED]> writes:
> However, when I run the above script I get this:
>
> <stdin>:7: PGRES_FATAL_ERROR select "_dg_cluster".setAddTable(1, 2,
> 'paneon0.database_version', 'database_version_pk',
> 'paneon0.database_version');  - ERROR:  Slony-I: cannot add table to
> currently subscribed set 1
>
>
> Any thoughts ?

Evidently the error message is not specific enough; I thought it was.

I'll be committing the following patch momentarily.  Hopefully the
elaboration gives you some idea of what you must do.

Index: slony1_funcs.sql
===================================================================
RCS file: /home/cvsd/slony1/slony1-engine/src/backend/slony1_funcs.sql,v
retrieving revision 1.139
diff -c -u -r1.139 slony1_funcs.sql
cvs diff: conflicting specifications of output style
--- slony1_funcs.sql    28 May 2008 18:09:47 -0000      1.139
+++ slony1_funcs.sql    6 Jun 2008 20:54:27 -0000
@@ -2700,7 +2700,7 @@
        if exists (select true from @[EMAIL PROTECTED]
                        where sub_set = p_set_id)
        then
-               raise exception ''Slony-I: cannot add table to currently 
subscribed set %'',
+               raise exception ''Slony-I: cannot add table to currently 
subscribed set % - must attach to an unsubscribed set'',
                                p_set_id;
        end if;
-- 
let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/x.html
We'll know that rock is dead when you have  to have a  degree to get a
job in it.
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to