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@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>
_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
