I think there is a bug with upserting into a retool db. Self-hosting. The issue occurs when using the GUI mode. I am using a UUID field in the Filter by section. If the UUID does not exist, Retool is assigning the UUID field to null, and then trying to insert that field as null as part of the Chang…

Bug when upserting to retool DB using GUI mode

joeBumbaca April 9, 2024, 3:32pm 4

Hey @drewski, this seems similar to an issue we are tracking here. When you created this table, was the primary key set to GENERATED ALWAYS?

Topic		Replies	Views
Retool DB: UUID type is no longer nullable 💬 App Building retooldb	9	187	May 14, 2025
Retool Database - Editing a field, Unique: false reverts to true after save 💬 Queries and Resources resource-connection , bug , sql	2	83	October 24, 2024
Update and if not exists, insert a row 💬 Queries and Resources	4	296	August 11, 2025
Retool Database - Insert From Form - Primary Key Errors 💬 Queries and Resources	6	1500	November 14, 2024
Retool Database Schema Migration detects unnecessary changes for auto incrementing integers 💬 Queries and Resources bug	8	328	August 23, 2024