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

[Abbas B. <abb...@en...>]

Hi,
PFA patch to fix an XC limitation that update of a replicated table
created with oids cannot be based on oids.
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.

--
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