Re: Insert Documentation - Returning Clause and Order - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Insert Documentation - Returning Clause and Order
Date
Msg-id CAKFQuwbVUBehwAejNrBMwiPDJ61p3Rnjgr42pXkuGrYJ8JRz3A@mail.gmail.com
Whole thread Raw
In response to Re: Insert Documentation - Returning Clause and Order  (James Coleman <jtc331@gmail.com>)
Responses Re: Insert Documentation - Returning Clause and Order
Re: Insert Documentation - Returning Clause and Order
List pgsql-hackers
On Sat, Dec 12, 2020 at 7:02 AM James Coleman <jtc331@gmail.com> wrote:

Certainly almost every ORM, and maybe even other forms of application
code, need to be able to associate the serial column value returned
with what it inserted.

Yet most ORM would perform single inserts at a time, not in bulk, making such a feature irrelevant to them.

I don't think having such a feature is all that important personally, but the question comes every so often and it would be nice to be able to point at the documentation for a definitive answer - not just one inferred from a lack of documentation - especially since the observed behavior is that order is preserved today.

David J.

pgsql-hackers by date:

Previous
From: James Coleman
Date:
Subject: Re: Insert Documentation - Returning Clause and Order
Next
From: Andrey Borodin
Date:
Subject: Re: pglz compression performance, take two