On Sat, 4 Nov 2006, Andreas Kostyrka wrote: > Am Samstag, den 04.11.2006, 12:03 -0800 schrieb Jeff Frost: >> On Sat, 4 Nov 2006, Andreas Kostyrka wrote: >> >>> 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. >>> >> >> Interesting. This table has never been part of the subscription set, would >> it >> have added these catalog manipulations anyway? > > No, but I'm almost tempted to bet that you have a foreign key constraint > to a table that is replicated on that table.
I was thinking the same, but I was unable to find any table that referenced summary_target. However, summary_target references a bunch of replicated tables. Unfortunately, it won't let me drop any of those references as that yields the same error. -- Jeff Frost, Owner <[EMAIL PROTECTED]> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
