Hello! I've strange problem with Pyramid application working with postgresql over psycopg2. After some period of operation, my application insert new row to one of tables with the message: ERROR: permission denied for relation ... After restart of application, it starts to work properly again. I've carefully checked that there are no GRANT/REVOKE statements related to this table. Application connects to PostreSQL from dedicated account using peer authentication. Restart of application doesn't change any permissions. The problem is related only to this one table (but this table has biggest number of inserts). How to diagnose this problem ? debian stretch, PostgreSQL 9.6.10, all packages updated. best regards J.
