Re: [Postgres-xc-general] INSERT.. RETURNING not supported?

[Paulo P. <pj...@ub...>]

OK, I've tried this with plain PostgreSQL and it works. I've executed
the query by hand and the ID of the user returns properly.
In postgres-xc the RETURNING clause is not yet supported.

Any idea on when could this get to postgres-xc or at least could anyone
please explain why it has not been yet included (any technical issues?)?

Cheers,
PP

On 9/17/12 10:47 PM, Paulo Pires wrote:
> Dear all,
> 
> I'm testing postgres-xc with an existing Java EE solution of mine and
> right now I'm facing the following issue when reading from an entity
> I've just persisted:
> 
> org.postgresql.util.PSQLException: ERROR: RETURNING clause not yet supported
> 
> Here's what I'm doing:
> 1) I have a JDBC Connection Pool configured in my application server
> pointing to one of my coordinators;
> 2) In my application, I'm using Hibernate (Java ORM implementation) to
> persist my dat-model;
> 3) I insert a new entity to my database;
> 4) I get the ID of the object, that usually is available after inserting
> the new entity (I don't force RETURNING clause, but I believe the ORM
> may be doing it or something similar, if any);
> 5) I get the aforementioned exception.
> 
> Is this a known issue?
> 
> Cheers,
> 
> 
> 
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and 
> threat landscape has changed and how IT managers can respond. Discussions 
> will include endpoint security, mobile security and the latest in malware 
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> 
> 
> 
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
> 

-- 
Paulo Pires
Ubiwhere