On Mon, 10 Nov 2008, Geoffrey wrote:
I've received the message:
NOTICE: truncate of "public"."foo" failed - doing delete
When first initializing slony on a slave where all the tables are empty. Why
would the truncate fail on an empty table?
Because of foreign key references from other tables. From the docs:
TRUNCATE cannot be used on a table that has foreign-key references from other
tables, unless all such tables are also truncated in the same command.
Checking validity in such cases would require table scans, and the whole point
is not to do one.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
