<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial">Hi,</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial"><br></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial">We setup the Slony replication b/w master and salve. We are trying to drop a column of the replication table.</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial; min-height: 15.0px"><br></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial">We are facing the errors, while executing the execute script to drop a column::</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial; min-height: 15.0px"> </p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial; min-height: 15.0px"><br></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial"><stdin>:6: PGRES_FATAL_ERROR select "_testreplica".ddlScript_prepare(1, -1); - ERROR: Slony-I: alterTableRestore(): Table with id 206 not found</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial">CONTEXT: SQL statement "SELECT "_testreplica".alterTableRestore(tab_id) from "_testreplica".sl_table where tab_set in (select set_id from "_testreplica".sl_set where set_origin = "_testreplica".getLocalNodeId('_testreplica'))"</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial">PL/pgSQL function "ddlscript_prepare" line 34 at perform</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial; min-height: 15.0px"><br></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial">Here,slonik_execute_script referring table id is 206 but where as my table id is different in slony schema. i.e 139 and also we tried for another tables, getting the same error.</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial; min-height: 15.0px"><br></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial">Slony version:: 1.2.11</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial; min-height: 15.0px"><br></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial">Could you please provide suggestions on this issue.</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial"><br></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial">
Regards</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial">Raghu</p>