For the creation of slony-I clusters, pgadmin-III has the following code
src/slony/dlgRepCluster.cpp: if (!AddScript(createScript,
wxT("xxid.v74.sql")) ||
src/slony/dlgRepCluster.cpp: !AddScript(createScript,
wxT("slony1_base.sql")) ||
src/slony/dlgRepCluster.cpp: !AddScript(createScript,
wxT("slony1_funcs.sql")) ||
src/slony/dlgRepCluster.cpp: !AddScript(createScript,
wxT("slony1_funcs.v74.sql")))
However, for postgresql 8.x the file slony1_funcs.v74.sql should be replaced
by slony1_funcs.v80.sql
The same should probably be the case for xxid.v74.sql but in that case the
files are identical anyway. However slony1_funcs does have changes between
74 and 80
Because the change appears to just be a delete replaced with a truncate and
some error checking this may not be serious but should probably be adjusted
in the future to support both.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
