From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jan Kowalski <jk(at)poczta(dot)srv(dot)pl> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Lost permission |
Date: | 2018-09-27 22:40:47 |
Message-ID: | 20795.1538088047@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jan Kowalski <jk(at)poczta(dot)srv(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2018-09-28 00:05:20 | Re: Out of Memory |
Previous Message | Jan Kowalski | 2018-09-27 22:00:06 | Lost permission |