--- 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
Glyn
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
