2 months ago
When I try to update a record in my Postgres UI, I get an error that says:
'ERROR: column "id" can only be updated to DEFAULT DETAIL: Column "id" is an identity column defined as GENERATED ALWAYS.'
5 Replies
2 months ago
That's standard PostgreSQL behavior. Your id column is set to GENERATED ALWAYS AS IDENTITY, which prevents any direct updates to it. When you're editing records in the database UI, just leave the id field as-is and modify the other columns you need to change.
Status changed to Awaiting User Response Railway • 2 months ago
ray-chen
That's standard PostgreSQL behavior. Your id column is set to GENERATED ALWAYS AS IDENTITY, which prevents any direct updates to it. When you're editing records in the database UI, just leave the id field as-is and modify the other columns you need to change.
2 months ago
Hey Ray, in this case, I didn’t touch the ID column in the UI. I was trying to update a completely different field and when I click save that error is what I get. I’ve tried on several different records, and it gives the same error.
Status changed to Awaiting Railway Response Railway • 2 months ago
2 months ago
Hello!
We're acknowledging your issue and attaching a ticket to this thread.
We don't have an ETA for it, but, our engineering team will take a look and you will be updated as we update the ticket.
Please reply to this thread if you have any questions!
2 months ago
🛠️ The ticket Cannot edit database rows with auto-generated ID columns has been marked as in progress.
2 months ago
✅ The ticket Cannot edit database rows with auto-generated ID columns has been marked as completed.