Seems like the easiest thing to do would be to 'COPY foo TO ..' foo being a table with unique constraints, truncate that table (with execute script), then 'COPY foo FROM...'. If everything happens in the correct order, the COPY <table> FROM will succeed, if not, replication will get hung up.
On Thu, 28 Sep 2006, David Fetter wrote: > Folks, > > I noticed that people mention EXECUTE SCRIPT when the issue of > TRUNCATE comes up. Any ideas for what kind of tests we might run to > see that this would actually work as advertised? > > Cheers, > D > -- 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
