<br>slony: 2.0.3 rc3<br>Postgresql: 8.3.3<br>Centos: 5.2<br><br>When I add a new table using "excute script" I get the following error:<br><br>Submit DDL Event to subscribers...<br><stdin>:6: PGRES_FATAL_ERROR select "_mesrep".ddlScript_complete(1, $1::text, -1); - ERROR: value "5000012320" is out of range for type integer<br>
CONTEXT: PL/pgSQL function "ddlscript_complete" while casting return value to function's return type<br><br><br>The scipts are:<br><br>test.sh<br>=================<br>echo "Creating new table"<br>
slonik <<_EOF_<br>cluster name = mesrep;<br>node 1 admin conninfo = 'dbname=MES host=localhost user=***** password=******* port=5432';<br>node 2 admin conninfo = 'dbname=MES host=uklnxdisp1 user=**** password=****** port=5432';<br>
node 3 admin conninfo = 'dbname=MES host=uklnxdisp2 user=***** password=******** port=5432';<br><br>execute script ( SET ID = 1, FILENAME = 'test.sql', EVENT NODE = 1);<br>_EOF_<br><br><br>test.sql<br>=========<br>
SET client_encoding = 'LATIN1';<br>SET standard_conforming_strings = off;<br>SET check_function_bodies = false;<br>SET client_min_messages = warning;<br>SET escape_string_warning = off;<br>SET search_path = uk7501, pg_catalog;<br>
SET default_tablespace = '';<br>SET default_with_oids = false;<br><br>CREATE TABLE "uk7501".tam_test1 (<br>operation integer NOT NULL,<br>spec_id character varying(20)<br>);<br><br>ALTER TABLE uk7501.tam_test1 OWNER TO mes;<br>
ALTER TABLE ONLY tam_test1 ADD CONSTRAINT tam_test1_pk PRIMARY KEY (operation, spec_id);<br><br>REVOKE ALL ON TABLE tam_test1 FROM PUBLIC;<br>REVOKE ALL ON TABLE tam_test1 FROM mes;<br>GRANT ALL ON TABLE tam_test1 TO mes;<br>
<br><br>This is a copy of an sql script that previously worked - I just changed the table name.<br>The execute script worked fine until I stopped slony, updated the slony_tools.conf file adding more tables to my set<br>and reinitialized. Replication looked ok.<br>
<br>I was running slony 1.0.3 but upgraded today to 1.0.3rc3 with the same error.<br><br>Any ideas?<br><br>Tam<br>