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 CABzCKRCEM6wEUVrO2w1+OxWN+DopNWR8TdOdG--WMWxus0twkw@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] As superuser I still can't update a row in one table  (John Scalia <jayknowsunix@gmail.com>)
List pgsql-admin
Thanks for that pointer David. There was, indeed, a trigger on the table which called a function raising an exception. I just have never seen that prior to this database.

On Mon, Apr 24, 2017 at 11:21 AM, John Scalia <jayknowsunix@gmail.com> wrote:
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: John Scalia
Date:
Subject: Re: [ADMIN] As superuser I still can't update a row in one table
Next
From: "Gone, Sajan"
Date:
Subject: [ADMIN] Unable to start postgres instance.