Good morning,

We run slony 2.2.3 on a postgres 9.2 platform. I am attempting to drop a
table from the slony registration:

 select * from _replication.sl_table where tab_relname = 'content_viewers';
 tab_id | tab_reloid |   tab_relname   | tab_nspname | tab_set |
tab_idxname      | tab_altered |                  tab_comment

--------+------------+-----------------+-------------+---------+----------------------+-------------+-----------------------------------------------
    140 |    1999743 | content_viewers | public      |       6 |
content_viewers_pkey | f           | Table public.content_viewers with
primary key

When I attempt a slonik_drop_table:


./slonik_drop_table -c
/postgres_data/prime/PSQL_92/slon_tools.primeprod.conf  140 6 |
./bin/slonik &


I get this error:


[pguser at 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
CONTEXT:  SQL statement "SELECT
"_replication".alterTableDropTriggers(p_tab_id)"
PL/pgSQL function _replication.setdroptable_int(integer) line 52 at PERFORM
SQL statement "SELECT "_replication".setDropTable_int(p_tab_id)"
PL/pgSQL function _replication.setdroptable(integer) line 40 at PERFORM
<stdin>:8: Could not drop table 140 for replication!

Please advise.  thanks!
-- 
*Mark Steben*
 Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
  CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20160623/1f6fe5c9/attachment.htm