I have got a simple database (using the in-built retool database - postgresql - structure) where I have set the table to have an auto-incrementing ID column (at least, that's what I THOUGHT I did, by creating a new column, selecting the auto-increment ID option and then setting that new column to be my primary key).
The interface for adding new data looks like this:
My submit query looks like this:
I built arrListView like this:
I've checked and the arrListView.value array does not have the UID value defined, so in theory, if I submit this form, the primary key IDs should be auto-generated. However, when I try to submit, I get this error:
What's weird is that the UID column that I set up in my database (which I set up as an auto-incrementing integer ID:
Seems to revert to a regular integer field after I've set it to be my primary key??
Any help would be wildly appreciated!
Cheers
