On Sun, 5 Nov 2006, Andreas Kostyrka wrote:

> Am Samstag, den 04.11.2006, 13:26 -0800 schrieb Jeff Frost:
>> inking the same, but I was unable to find any table that referenced
>> summary_target.  However, summary_target references a bunch of
>> replicated
> That's what I meant. The replicated tables have their catalog entries
> quite broken, so you need to use EXECUTE SCRIPT to drop the table or
> foreign key constraints. (you can use EXECUTE SCRIPT to execute only on
> one node, for the exact option, read the docs :-P )

Ah hah!  I would have never thought I need to execute script to drop things 
that are not replicated.  For the record, it goes like this:

EXECUTE SCRIPT (
        SET ID = 1,
        FILENAME = '/home/slony/drop-summary_target.sql',
        EVENT NODE = 1,
        EXECUTE ONLY ON = 2
);

Thanks Andreas!

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