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 <[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
