Unable to perform INSERT or UPDATE operations into my PostgreSQL via PostgREST. I’m using an HTTP URL call to the web service via a web browser. SELECTs work but INSERTs do not, even when using the adm user as credentials on the service API. Response: cannot execute INSERT in a read-only transact…

Never mind. I fixed it. I now realise using a URL in a web browser is not a good test for an update/insert function. I’ve adapted the app to use POST and we are all good to go. Thank you for your feedback earlier.

Hey @Mark_Howell is it still happening? Some fixes were pushed, but I’m not sure if they’re related to your issue.

Hi Lukasz. Yes it’s still happening. I can share the URL with you but I would rather not post it here. Thanks, Mark

For information, there was a redeployment of my database on Saturday 7th february at 16h55 (CET). I assume this was as a result of the weekend maintenance. It failed. There was another redeployment of my database on Sunday 8th february at 20h35 (CET). This also failed.

Hi Mark, The database should be back up now. There was an issue with your DB service which caused the deployment to timeout. We’re still investigating exactly how it happened. Sorry for the inconvenience.

Hi Alexis, I finally managed to get an option to delete the database via the control panel a few hours ago, so I did. I then rebuilt it again. Thankfully it is not live yet. I would appreciate any advice you have on backups, as once it is live I won’t be able to wait 4 days like I did this time. I …

In fact, I still have the problem where I cannot perform INSERT transactions via an API function using a URL. Fin has suggested various solutions but none of them have worked. If you could help point me in the right direction that would be great, as a database is a bit redundant if you cannot INSERT…

Unable to perform INSERT or UPDATE operations into my PostgreSQL via PostgREST

Troubleshooting and help

Mark_Howell February 9, 2026, 2:34pm 4

Hi Lukasz. For info, this morning I find that my database is marked as degraded and there is a blank page displayed when i try to open the database page online. This wasn’t the case when I left it on friday night. This sounds similar to the following previous community post:

Topic		Replies	Views
Database "Degraded" and no settings available Troubleshooting and help database	2	43	March 23, 2025
Healthy deploy but doesnt work Troubleshooting and help help	1	18	March 17, 2025
Error connecting to postgres database Troubleshooting and help help , deployments	0	58	February 16, 2026
What did you change with Postgres Deployments? Troubleshooting and help help , changelog , database , deployments , postgres	4	167	February 11, 2025
Error connecting to postgresql serverless service Troubleshooting and help starter , database , serverless-postgres	15	148	March 11, 2026

Unable to perform INSERT or UPDATE operations into my PostgreSQL via PostgREST

Related topics