Record Create failed - Ley ID already exists (but I was creating a new key

[MiguelOrtiz]

Hi @jhubs,

I believe this may be because of your db's sequence. Here's a solution.

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…

Or in alternative, a non conventional solution is to keep clicking until you will reach the sequence that the database will accept.