Tam McLaughlin wrote:
>
> slony: 2.0.3 rc3
> Postgresql: 8.3.3
> Centos: 5.2
>
> When I add a new table using "excute script" I get the following error:
>
> Submit DDL Event to subscribers...
> <stdin>:6: PGRES_FATAL_ERROR select "_mesrep".ddlScript_complete(1, 
> $1::text, -1);  - ERROR:  value "5000012320" is out of range for type 
> integer
> CONTEXT:  PL/pgSQL function "ddlscript_complete" while casting return 
> value to function's return type
This is almost certainly related to the following fix:

http://main.slony.info/viewcvs/viewvc.cgi/slony1-engine/src/backend/slony1_funcs.sql?r1=1.145.2.16&r2=1.145.2.17


The trouble here is that the event number has gone past 2^31, with 
consequence that ddlScript_complete() can't return the event number 
because it is out of range.

As shown, the change is very simple, just a matter of changing the 
return type for this function from integer to bigint.

That was in 2.0.3 rc2, so you should surely have the right code available.

Perhaps you initialized using some earlier version, and need to run 
UPDATE FUNCTIONS to get it to reload the functions?