| 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: | Whole Thread | Raw Message | 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 |