Jan Kowalski <jk@poczta.srv.pl> writes:
> 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.
Couple of possible ideas:
* something in your app sometimes issues SET ROLE or SET SESSION
AUTHORIZATION.
* you're using a connection pooler and it sometimes reconnects you
to a connection with the wrong user ID.
Neither of these seem terribly likely, but whatever it is has to
be weird ...
regards, tom lane