Support RETURNING in modification commands #128

Open
digi604 opened this Issue Jul 23, 2015 · 3 comments

Projects

None yet

3 participants

@digi604
digi604 commented Jul 23, 2015

Any query using the RETURNING clause produces the following error:

NotSupportedError: cannot perform distributed planning for the given query
DETAIL:  RETURNING clauses are not supported in distributed queries.

Can you add support for RETURNING clauses?

@jasonmp85 jasonmp85 changed the title from support RETURNING to Support RETURNING in modification commands Jul 27, 2015
@jasonmp85 jasonmp85 added the feature label Jul 27, 2015
@jasonmp85
Member

Hey @digi604: What's your use case? We didn't implement RETURNING to keep the feature profile abbreviated during the initial release, but with sufficient demand we could change that. 😃

@rodo
rodo commented Aug 9, 2015

In ORM (I know it's bad, but sometimes we have to work with people who love them) like Django the SQL query include RETURNING to return the object's id to the ORM, maybe @digi604 uses an ORM.
I vote for RETURNING support in pg_shard 👍

@digi604
digi604 commented Aug 11, 2015

i use peewee (orm) in a rather complex worker queue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment