Solved: Desync issue using RDS Postgres DB - Page 2

andresjgc · 04-26-2022 07:54 AM

Hi, it has happened multiple times that the user updates some data through the app and performs some actions and suddenly the app goes back to the same state as it was initially. We are using a Postgres DB hosted in AWS. We recently switched from Google Sheets to Postgres and we started noticing this sync issue.

What are the common reason that will make this happen? How can I monitor the app and see what's causing this issue?

Thanks

Jonathon

FYI; this is a case sensitivity issue.

Appsheets UNIQUEID("UUID") formula generates a uuid like the one you posted (531B2ABA-C263-4433-A61E-AD14FCC1031C)

Postgres will accept that UUID, but cast it to lowercase.

This will cause issues with workflows that create a record and then within a short timeframe attempt to interact or perform another data action against the row.

Try using LOWER(UNIQUEID("UUID")) and see if the issue goes away.

View solution in original post