On 10/18/2004 8:29 PM, Ed L. wrote:

> I'm following the basic master-slave example from the docs and using latest 
> slony from CVS to replicate between 7.3.4 clusters on separate hosts.  
> While doing so, slonik fails because it can't find getLocalNodeId during 
> load of slony1_base.sql.  This patch loads slony1_funcs.sql before 
> slony1_base.sql, and fixes that problem.  Does this break something else??

This problem was introduced by Chris' attempt to move all views into 
slony1_base.sql. THAT view was in slony1_funcs.sql on purpose. I moved 
it back to there.


Jan

> 
> Ed
> 
> 
> 
> ------------------------------------------------------------------------
> 
> Index: src/slonik/slonik.c
> ===================================================================
> RCS file: /usr/local/cvsroot/slony1/slony1-engine/src/slonik/slonik.c,v
> retrieving revision 1.32
> diff -C2 -r1.32 slonik.c
> *** src/slonik/slonik.c	8 Oct 2004 16:30:59 -0000	1.32
> --- src/slonik/slonik.c	19 Oct 2004 00:21:08 -0000
> ***************
> *** 1804,1813 ****
>   			"%s/xxid.v%d%d.sql", PGSHARE, use_major, use_minor) < 0
>   		|| load_sql_script(stmt, adminfo,
>   			"%s/slony1_base.sql", PGSHARE) < 0 
>   		|| load_sql_script(stmt, adminfo,
>   			"%s/slony1_base.v%d%d.sql", PGSHARE, use_major, use_minor) < 0
>   		|| load_sql_script(stmt, adminfo,
> - 			"%s/slony1_funcs.sql", PGSHARE) < 0 
> - 		|| load_sql_script(stmt, adminfo,
>   			"%s/slony1_funcs.v%d%d.sql", PGSHARE, use_major, use_minor) < 0)
>   	{
> --- 1804,1813 ----
>   			"%s/xxid.v%d%d.sql", PGSHARE, use_major, use_minor) < 0
>   		|| load_sql_script(stmt, adminfo,
> + 			"%s/slony1_funcs.sql", PGSHARE) < 0 
> + 		|| load_sql_script(stmt, adminfo,
>   			"%s/slony1_base.sql", PGSHARE) < 0 
>   		|| load_sql_script(stmt, adminfo,
>   			"%s/slony1_base.v%d%d.sql", PGSHARE, use_major, use_minor) < 0
>   		|| load_sql_script(stmt, adminfo,
>   			"%s/slony1_funcs.v%d%d.sql", PGSHARE, use_major, use_minor) < 0)
>   	{
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #