Re: [Postgres-xc-developers] Replicated update and delete

[Koichi S. <koi...@gm...>]

Mason;

Thanks for this big patch.    I understand the intention and would like
other members to look at this patch too.

I'd like to know your idea if this can be a part of the TRIGGER improvement?

Regards;

---
Koichi Suzuki


2013/11/2 Mason Sharp <ms...@tr...>

> Please see attached patch that tries to address the issue of XC using CTID
> for replicated updates and deletes when it is evaluated at a coordinator
> instead of being pushed down.
>
> The problem here is that CTID could be referring to a different tuple
> altogether on a different data node, which is what happened for one of our
> Postgres-XC support customers, leading to data issues.
>
> Instead, the patch looks for a primary key or unique index (with the
> primary key preferred) and uses those values instead of CTID.
>
> The patch could be improved further.  Extra parameters are set even if not
> used in the execution of the prepared statement sent down to the data nodes.
>
> Regards,
>
>
> --
> Mason Sharp
>
> TransLattice - http://www.translattice.com
> Distributed and Clustered Database Solutions
>
>
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models.
> Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and
> register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>