Am Samstag, den 04.11.2006, 08:11 -0800 schrieb Jeff Frost:
> Andreas,
> 
> The node is definitely still subscribed, and I'd like to keep it that way. 
> The particular table I want to drop is not part of the subscription set.

I meant, that the table is not subscribed.

Basically, use EXECUTE SCRIPT then, as this removes the $#%!! catalog
manipulations slony does on slaves.

Andreas

> 
> 
> On Sat, 4 Nov 2006, Andreas Kostyrka wrote:
> 
> > Well, the simplest thing is to use EXECUTE SCRIPT that runs only on that
> > one node. As it runs only on the slave, problems with getting the locks
> > seems to be way easier to get then on master.
> >
> > Just make sure that it's really not subscribed anymore.
> >
> > Andreas
> >
> > Am Freitag, den 03.11.2006, 17:21 -0800 schrieb Jeff Frost:
> >> I am using slony to replicate 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:
> >>
> >> Foreign-key constraints:
> >>      "markets_summary_target_fk" FOREIGN KEY (market_id) REFERENCES
> >> markets(market_id) ON UPDATE CASCADE ON DELETE CASCADE
> >>      "occasions_summary_target_fk" FOREIGN KEY (occasion_id) REFERENCES
> >> occasions(occasion_id) ON UPDATE CASCADE ON DELETE CASCADE
> >>      "questions_summary_target_fk" FOREIGN KEY (question_id) REFERENCES
> >> questions(question_id) ON UPDATE CASCADE ON DELETE CASCADE
> >>      "targets_summary_target_fk" FOREIGN KEY (target_id) REFERENCES
> >> targets(target_id) ON UPDATE CASCADE ON DELETE CASCADE
> >>      "types_summary_target_fk" FOREIGN KEY (type_id) REFERENCES types(type_id)
> >> ON UPDATE CASCADE ON DELETE CASCADE
> >>
> >>
> >> 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?
> >>
> >
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20061104/5f1424c6/attachment.bin