Re: [Postgres-xc-developers] how to fix EXECUTE DIRECT?

[Michael P. <mic...@gm...>]

Hi all,

I extended the patch so as to be able to launch utilities on targeted nodes
(datanodes and Coordinators).
EXECUTE DIRECT is still restricted for UPDATE and DELETE.
And it is still not possible to launch a query on the local Coordinator
without spreading it to the other nodes.

With this patch, in the case of a 2PC transaction that is partially
committed or partially aborted in the cluster,
EXECUTE DIRECT can be used to target specific nodes where to send a COMMIT
PREPARED or ABORT PREPARED.

This is definitely useful for HA features and recovery also.

Thanks,

-- 
Michael Paquier
http://michaelpq.users.sourceforge.net