--- On Mon, 19/10/09, Glyn Astill <[email protected]> wrote: > > --- On Mon, 19/10/09, Glyn Astill <[email protected]> > wrote: > > Hi chaps, > > > > Is anyone else seeing this when doing UPGRADE > > FUNCTIONS? I'm guessing it's the recent int / > bigint > > changes? > > > > And I'm getting: > > > > g...@way5d:/pgsql/slony$ slonik upgrade_functions.scr > > upgrade_functions.scr:9: Possible unsupported > PostgreSQL > > version 8.3, defaulting to 8.1 support > > upgrade_functions.scr:9: loading of file > > /usr/local/pgsql/share//slony1_funcs.sql: > PGRES_FATAL_ERROR > > ERROR: cannot change return type of existing > function > > HINT: Use DROP FUNCTION first. > > ERROR: cannot change return type of existing > > function > > HINT: Use DROP FUNCTION first. > > > I bumbled around it with the following on each node: > > psql -U slony -d SEE -c 'drop function > _main_replication_test.ddlscript_complete(integer, text, > integer)' > psql -U slony -d SEE -c 'drop function > _main_replication_test.updatereloid(integer, integer)' > sed -e > 's/@NAMESPACE@/_main_replication_test/g;s/@MODULEVERSION@/1.2.17/g' > slony1_funcs.sql | psql -U slony -d SEE >
Actually : sed -e 's/@NAMESPACE@/_main_replication_test/g;s/@MODULEVERSION@/1.2.17/g;s/@CLUSTERNAME@/main_replication_test/g' slony1_funcs.sql | psql -U slony -d SEE Glyn _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
