Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] As superuser I still can't update a row in one table - Mailing list pgsql-admin

From John Scalia
Subject Re: [ADMIN] As superuser I still can't update a row in one table
Date
Msg-id CABzCKRBiaV1HwunfObReCGTxMybQ-=jp-+1jj=Y7OOo39HLuBQ@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] As superuser I still can't update a row in one table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [ADMIN] As superuser I still can't update a row in one table  (John Scalia <jayknowsunix@gmail.com>)
List pgsql-admin
Tree view
Ah,, I hadn't considered a trigger that could be blocking it. I'll look for it.

On Mon, Apr 24, 2017 at 11:13 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Apr 24, 2017 at 8:02 AM, John Scalia <jayknowsunix@gmail.com> wrote:
ERROR:  Permission denied: UPDATE is not allowed on rhnpackageevr


​That doesn't look like a system generated message (and grep on the source tree turns up no results) - which means you should be looking for a trigger that is blocking you.

David J.


pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [ADMIN] As superuser I still can't update a row in one table
Next
From: John Scalia
Date:
Subject: Re: [ADMIN] As superuser I still can't update a row in one table