All geek questions in one place

PG: InsufficientPrivilege: ERROR while trying to make an INSERT in a stage database

I use hero and postgres. Local works fine, but whenever a user (any user) performs an INSERT at the stage, it fails. This is the message I get:

PG:InsufficientPrivilege: ERROR: permission denied for relation .. INSERT INTO..

I have granted privileges to the public in the necessary tables, but that does not matter. Any insight would be helpful. Thanks.

+4
source share
1 answer

I know this waaaaay late, but I just ran into this problem, and I believe that the problem is that you exceeded the number of rows allowed for your database. In my case, I used the Hobby-dev plan, and the limit is 10 thousand lines. If you run heroku pg:info , you will see something like:

 === HEROKU_POSTGRESQL_BRONZE_URL (DATABASE_URL) Plan: Hobby-dev Status: Available Connections: 4/20 PG Version: 9.3.3 Created: 2014-05-27 15:07 UTC Data Size: 175.5 MB Tables: 47 Rows: 409300/10000 (Write access revoked) Fork/Follow: Unsupported Rollback: Unsupported

If Write access revoked is a key piece of information. Upgrading your database (or deleting some data) should solve this problem.

+9
source

Source: https://habr.com/ru/post/1499167/

More articles:


All Articles