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

[Ashutosh B. <ash...@en...>]

On Tue, Sep 18, 2012 at 2:05 AM, Paulo Pires <pj...@ub...> wrote:

> 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?)?
>
>
The RETURNING clause support will be available in the next release of XC.
We are working on it.


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


-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company