2 years ago
I have created a Postgres database and I can not change the data in the tables and delete the records themselves, in another project on Railway I can do it, what could be the reason?
5 Replies
2 years ago
Hello,
There's nothing that shows the database being read only, what makes you say that?
brody
Hello, There's nothing that shows the database being read only, what makes you say that?
2 years ago
Hello, the delete and save buttons (after modification) are disabled.
Attachments
2 years ago
Ah gotcha, its not read only, you just don't have a primary key set for those tables.
In the _prisma_migrations table there is a primary key and you do have the option to save or delete.
The Data UI uses the primary key to know what row to delete / update, without a primary key you lose that functionality.
brody
Ah gotcha, its not read only, you just don't have a primary key set for those tables. In the `_prisma_migrations` table there is a primary key and you do have the option to save or delete. The Data UI uses the primary key to know what row to delete / update, without a primary key you lose that functionality.
2 years ago
Thank you!
Status changed to Solved brody • over 1 year ago