kevin kempter <kevin at kevinkempterllc.com> 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 @NAMESPACE at .sl_subscribe
 			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.