a year 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
a year 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?
a year ago
Hello, the delete and save buttons (after modification) are disabled.
Attachments
a year 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.
a year ago
Thank you!
Status changed to Solved brody • about 1 year ago