How can I enable returning(*) for Postgres?

[awanuch]

Hi,

I'm trying to do inserts and updates that return the full record, not just the fields that are passed in the request.
Objection docs say to run either a InsertAndFetch, or to add returning('*') to the query. Is this supported by the Feathers Objection adaptor? Or is there a better pattern to post/patch the record and return the entire resulting record?

Thank you in advance!

[dekelev]

By default create fetches the inserted record/s from DB. You can use $noSelect for increased performance when needed.

[awanuch]

You're correct, thanks for pointing that out. The problem was that I was using a composite ID along with knexSnakeCaseMappers, however in this particular model I had defined the idColumn in snake case instead of camel case. When I ran a create, the only result I was getting back was the composite ID columns instead of the whole record. Changing the idColumns to the correct casing fixed the issue.

My mistake!