On Tue, 14 Nov 2006, Bruce Momjian wrote:
"In clustering, each server can accept write requests, and these write
requests are broadcast from the original server to all other servers before
each transaction commits."
Unfortunately, I can't seem to come up with anything more clever.
Basically, when you are broadcasting outside the server, you are
broadcasting SQL queries, and those queries do not have information
about non-deterministic functions and have issues with universal commits
on all node.
Ahh..I like this explanation, because the inter-server communication in
clustering is not necessarily SQL queries.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
