"Please add a primary key column to your table to update or delete rows"
I'm getting the post title as an error message in the Neon web view when trying to edit or delete rows from the "Tables" view. I've never had an issue with this before today. The DB is created from an Elixir Phoenix project. I haven't not changed my DB. Has something in the Neon web view changed that is now causing this error?
7 Replies
wise-whiteOP•6mo ago
Appears to be happening across all my DB instances that have been created from Phoenix projects (using Ecto).
wise-whiteOP•6mo ago
fascinating-indigo•6mo ago
I'm getting the same issue, using Prisma + Vercel
my schema has
@id marked on the id column
and it Neon it has the index, but it's not specified as a primary key on the column?
national-gold•6mo ago
I recently started getting the same error. Its happening across Neon instances I have setup for work and my side project, so inclined to think a bug
extended-salmon•6mo ago
Been getting the same issue, using Neon's own UI
rare-sapphire•6mo ago
Also getting the same issue when using the UI
metropolitan-bronze•6mo ago
Hi, This is a bug in the console it seems. It should work with SQL directly. Sorry for the inconvenience. WIll look into getting it fixed