error: markets_pk is an index

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: error: markets_pk is an index
Date: 2006-11-03 20:40:24
Message-ID: Pine.LNX.4.64.0611031239530.6160@discord.home.frostconsultingllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I tried to post this to the slony1-general list, but it bounced. :-(

Setup:

slony replication of some tables in a DB, but not all. When I try to drop one
of the non-replicated tables on the slave, I receive the following:

DROP TABLE summary_target ;
ERROR: "markets_pk" is an index

The summary_target table is not replicated, but the markets table is
replicated. The summary_target table has the following fkeys:

mps=# begin;
BEGIN
mps=# drop trigger _mpscluster_denyaccess_29 ON markets;
DROP TRIGGER
mps=# ALTER TABLE summary_target DROP CONSTRAINT markets_summary_target_fk;
ERROR: "markets_pk" is an index

I grepped through the source and it looks like this is a problem with a grant.
So I thought maybe it's a problem with the foreign key that relates to the
markets table, since the markets table is replicated and has a no access
trigger on it...so I tried deleting it.

drop trigger _mpscluster_denyaccess_29 ON markets;
DROP TRIGGER
DROP TABLE summary_target ;
ERROR: "markets_pk" is an index

Still the same problem. Also the same problem if I attempt to drop any of the
foreign key constraints on summary_target:

drop trigger _mpscluster_denyaccess_29 ON markets;
DROP TRIGGER
ALTER TABLE summary_target DROP CONSTRAINT markets_summary_target_fk; ERROR:
"markets_pk" is an index

Suggestions as to what I can do to remove this non subscribed table from the
slave?

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

Browse pgsql-admin by date

  From Date Subject
Next Message steven.cardinal 2006-11-05 16:35:54 createlang on Mac OS X
Previous Message Tomeh, Husam 2006-11-03 19:40:11 Re: New to PostgreSQL