I have upgraded the pg_dump safe patch found at: 
http://www.dbitech.ca/slony/slonypg_dumpsafe.diff.gz

based on the work committed below.

Log Message:
Added new function upgradeSchema(old_version). Slonik now determines
the currently loaded slony1_funcs.sql version by calling slonyVersion()
before updating the functions. It then calls upgradeSchema(old_version)
so that this function can perform all the required modifications to the
slony1_base schema depending on the old version.

Jan

Modified Files:
--------------
    slony1-engine/src/backend:
        slony1_base.sql (r1.23 -> r1.24)
        slony1_funcs.sql (r1.46 -> r1.47)
    slony1-engine/src/ducttape:
        test_1_update_functions (r1.1 -> r1.2)
    slony1-engine/src/slonik:
        slonik.c (r1.33 -> r1.34)

Once again I'd like to get peoples comments on this idea (and bugs) as well as 
if REINIT looks like a good slonik command for this, or if someone has a 
better name idea for it.

On a side note, in doing this I have found a potentail hassle point.  The 
upgrade process as it stands provides no clean way to upgrade -HEAD to -HEAD.  


-- 
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com