I'm getting the following error when creating a record on this 'vectors' table
message: 'table [vectors]: record with ID [rec_cq8rnq04vvkm2p5ohj6g] already exists in table [vectors]', even though the table is completely empty, to create the tables i used prisma, only for the regular columns (strings, numbers etc...) and then i the vector one on the UI.
any help will be appreciated, Thanks!!
2 Replies
Hi, can you check from SQL (from the queries view -> PostgreSQL) whether SELECT * from "vectors" shows any records in the table?
In the screenshot it seems you have both an id and a xata_id column. I suspect this might be causing the conflict
The UI does not allow creating a column named "id" because it can clash with xata_id from the REST API. Can you try using another column name instead of id for your own id column and see if that helps?
Hey, sorry for the late response the problem was a unique constraint on the "docId" field in the "vectors", because a multiple vectors can belong to a single document.
it's all good and working now !
Thanks man 🙏