Re: [ADMIN] As superuser I still can't update a row in one table

Поиск
Список
Период
Сортировка
От John Scalia
Тема Re: [ADMIN] As superuser I still can't update a row in one table
Дата
Msg-id CABzCKRCEM6wEUVrO2w1+OxWN+DopNWR8TdOdG--WMWxus0twkw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] As superuser I still can't update a row in one table  (John Scalia <jayknowsunix@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: [ADMIN] As superuser I still can't update a row in one table
Следующее
От: "Gone, Sajan"
Дата:
Сообщение: [ADMIN] Unable to start postgres instance.