I wrote:
> Tom Lane wrote:
>
>>Basically, the subordinate must be willing to hold its breath *forever*.
>
>
> Yep. And if the cohort crashes while waiting for the coordinator to
> come back on-line, if I understand the world correctly, it must be
> capable of committing the database changes associated with the
> COMMIT-VOTE response it supplied to the coordinator's PREPARE. It
> seems this would require REDO? And yet there are thousands of
> installed distributed databases running enterprises every day.
Please ignore the REDO remark. It's late where I am...
Mike Mascari
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
