Re: [Postgres-xc-developers] [JDBC Regression] In XC update of a replicated table cannot be based on OID

[Masataka S. <pg...@gm...>]

On Thu, Aug 8, 2013 at 9:41 PM, Abbas Butt <abb...@en...> wrote:
> Hi,
> PFA patch to fix an XC limitation that update of a replicated table
> created with oids cannot be based on oids.

When did you change distribution rule to REPLICATION from ROUNDROBIN?
I lost your patch.

> i.e. this update supposed to fail
> update rep_table_with_oids set colum = $1 where oid=$2
> saying
> ERROR : Write to replicated table returned different results from the Datanodes
>
> The reason is that we would select oid from the primary datanode and
> that particular oid will not be there on the rest of the datanodes.
> The patch comments explain the complete scenario in detail.
>
> With this patch the JDBC regression runs without any failures or
> errors on my machine.
> Strangely I did not have to change any thing on the server side.

What do you experience the strangeness of?
Your patch eliminated "oid" column from the selection, therefore,
UPDATE query does not contain "oid" anymore. I think it is
straightforward.

Regards.

>
> --
> Abbas
> Architect
>
> Ph: 92.334.5100153
> Skype ID: gabbasb
> www.enterprisedb.com
>
> Follow us on Twitter
> @EnterpriseDB
>
> Visit EnterpriseDB for tutorials, webinars, whitepapers and more
>
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>