Re: Guidance on INSERT RETURNING order

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Federico <cfederico87(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Guidance on INSERT RETURNING order
Date: 2023-04-11 21:45:59
Message-ID: 961adda9-4eb1-79f6-ee8f-9440a520ac15@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>> Can your client retain a hashmap of md5,data pairings, allowing the
>> lookup on the way back using the returned data and supplied id?
>>
> When using unique columns or similar, that's something that is done,
> but if there are no unique columns in the value no match can be done
> reliably with the source data, since sqlalchemy is a library that
> allows arbitrary schemas to be generated.
>
> Thanks for the reply,
> Federico
So you're returned data is not what was sent to the server? Otherwise it
should generate the same md5, as I understand it. Identical data would
of course be a problem.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Federico 2023-04-11 21:55:28 Re: Guidance on INSERT RETURNING order
Previous Message Thorsten Glaser 2023-04-11 21:39:04 Re: Guidance on INSERT RETURNING order