[Postgres-xl-general] [Postgres-xl-developers] General query

Saurabh Gupta A saurabh.a.gupta at ericsson.com
Fri Sep 12 07:35:36 PDT 2014

Below error is coming when trying to insert the data in a table of postgres-xl:

org.postgresql.util.PSQLException: ERROR: Invalid Datanode number
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363)

Can somebody provide the solution of this?

Saurabh Gupta
Ericsson India Global Service Private Limited, Gurgaon

From: Saurabh Gupta A
Sent: Friday, September 12, 2014 6:35 PM
To: 'Mason Sharp'; postgres-xl-general at lists.sourceforge.net
Subject: RE: [Postgres-xl-developers] General query


One more query:
I have installed postgres-xl.
Now I am using driver “postgresql-9.3-1102.jdbc4” to read/write, but unable to do so.

Can somebody please guide me for the same.

It will be great help if somebody provide me a simple sample java program

Saurabh Gupta
Ericsson India Global Service Private Limited, Gurgaon

From: Mason Sharp [mailto:msharp at translattice.com]
Sent: Wednesday, September 10, 2014 4:17 AM
To: Saurabh Gupta A
Subject: Re: [Postgres-xl-developers] General query

Hi Saurabh,

On Tue, Sep 9, 2014 at 12:07 PM, Saurabh Gupta A <saurabh.a.gupta at ericsson.com<mailto:saurabh.a.gupta at ericsson.com>> wrote:

Hi Mason/All,
Thanks for reply.

One more doubt to clarify:
I have an impression in my mind from some readings that Postgres-xl do not support virtual/cloud deployment. Can you please clarify this?

You can deploy Postgres-XL anywhere.


Mason Sharp

TransLattice - http://www.translattice.com<http://www.translattice.com/>
TransLattice Elastic Database (TED)
Postgres-XL Support

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20140912/1253fa7b/attachment.htm>

More information about the postgres-xl-general mailing list