Insert a record - via a form - PKEY error showing up across multiple reports

[MiguelOrtiz]

Hi @RA_SYD,

I believe this may be because of your db's sequence. I found this link that may be useful to reset it and try if that is causing the error:

Postgres Retool DB auto increment ID

Hey Matei, I believe I figured it out. Head to the Query Library in retool. then follow these steps: Create a sequence if one doesn't already exist (copy and past and run the query): CREATE SEQUENCE candidates_entry_id_seq; Alter the id column to use the sequence (copy and past and run the query): ALTER TABLE candidates_entry ALTER COLUMN id SET DEFAULT nextval('candidates_entry_id_seq'); (Optional) Ensure the sequence starts with a value higher than the current maximum id in the tab…