Search Postgresql Archives

Re: Guidance on INSERT RETURNING order

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Apr 14, 2023 at 2:44 PM John Howroyd <jdhowroyd@xxxxxxxxxxxxxx> wrote:
A patch for what?  All my testing gives me the same output order as the declaration order.  Does anyone have an example where this is not the case?

The problem is that SQLAlchemy is an ORM and they need to be sure to match records from the insert to the relevant code side objects.  This needs to be efficient as the majority of the python world will use this ORM for their database needs.  There is no PostgreSQL documentation upon which to give this assertion.

So what is really needed is for PostgreSQL to commit to this behaviour, or give guidance on how this might be achieved.


We aren't committing to it though.  It will require newly introduced syntax that tells the system to behave in the manner so desired.  It makes sense to attach such syntax to the RETURNING clause itself.  Whether someone can achieve that in a manner that the project is willing to commit remains to be seen.

In short, lots of people complain about PostgreSQL's lack of this feature.  None of them are stepping up to fill in the gap and there isn't enough interest, for many reasons, for the people being complained to to go ahead and design and implement it themselves.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux