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 	<jeff at frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954