<div dir="ltr">Good morning,<div><br></div><div>We run slony 2.2.3 on a postgres 9.2 platform. I am attempting to drop a table from the slony registration:</div><div><br></div><div><div> select * from _replication.sl_table where tab_relname = 'content_viewers';</div><div> <font color="#0000ff">tab_id </font>| tab_reloid | tab_relname | tab_nspname | <font color="#0000ff">tab_set</font> | tab_idxname | tab_altered | tab_comment </div><div>--------+------------+-----------------+-------------+---------+----------------------+-------------+-----------------------------------------------</div><div> <font color="#0000ff"> 140 </font>| 1999743 | content_viewers | public | <font color="#0000ff"> 6 |</font> content_viewers_pkey | f | Table public.content_viewers with primary key</div><div><br></div><div>When I attempt a slonik_drop_table:</div><div><br></div><div><br></div><div><div>./slonik_drop_table -c /postgres_data/prime/PSQL_92/slon_tools.primeprod.conf 140 6 | ./bin/slonik &</div></div><div><br></div><div><br></div><div>I get this error:</div><div><br></div><div><br></div><div><div><div>[pguser@ardbc01 bin]$ <stdin>:6: PGRES_FATAL_ERROR lock table "_replication".sl_event_lock, "_replication".sl_config_lock;select "_replication".setDropTable(140); - ERROR: Slony-I: alterTableDropTriggers(): Table with id 140 not found</div><div>CONTEXT: SQL statement "SELECT "_replication".alterTableDropTriggers(p_tab_id)"</div><div>PL/pgSQL function _replication.setdroptable_int(integer) line 52 at PERFORM</div><div>SQL statement "SELECT "_replication".setDropTable_int(p_tab_id)"</div><div>PL/pgSQL function _replication.setdroptable(integer) line 40 at PERFORM</div><div><stdin>:8: Could not drop table 140 for replication!</div></div></div><div><br></div><div>Please advise. thanks!</div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div><span><font color="#888888"><span style="font-family:Calibri;font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> </span><br> Database Administrator<span style="font-family:"Century Gothic";font-size:8pt"><span style="color:rgb(51,51,51)"></span><br><a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autorevenue.com/" target="_blank">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt">|</span> <a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autobase.net/" target="_blank">Autobase</a> <span style="color:rgb(79,129,189);font-size:10pt"></span> <br> <span style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br><span style="color:gray;font-size:8pt">95D Ashley Ave.<br>West Springfield, MA 01089</span> <br>
<span style="color:gray;font-size:8pt">t: <a value="+14132434800">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt">f: <a value="+14132434800">413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br><a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br><br><a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><span style="color:gray;font-size:8pt"><br></span></span></font></span></p><font color="#888888"></font></div>
</div></div>