Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d2g9M-00034W-VK for pgsql-admin@arkaria.postgresql.org; Mon, 24 Apr 2017 15:43:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d2g9L-0005jc-UX for pgsql-admin@arkaria.postgresql.org; Mon, 24 Apr 2017 15:43:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d2g7W-0008Ny-Tr for pgsql-admin@postgresql.org; Mon, 24 Apr 2017 15:41:47 +0000 Received: from mail-ua0-x22b.google.com ([2607:f8b0:400c:c08::22b]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1d2g7P-0005Oz-A3 for pgsql-admin@postgresql.org; Mon, 24 Apr 2017 15:41:46 +0000 Received: by mail-ua0-x22b.google.com with SMTP id 110so16882091uas.3 for ; Mon, 24 Apr 2017 08:41:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=+YHO8tllqhE3zZEibhkFJzFL4bwce6SonpYoFRaE6uA=; b=pGy66FFzqle00UoTkaDqxCv5Cuty/ikPm27RWgi49ANCzQ3aURRCTXVKq0pdIvTqsa wGxbSmmDJLhVgFW2UHCqyCpwA3MYrNY/+MdmanYQF+ocfZKbxF7qJjuSJZgmjmVnVAAu HODI+c0q+iXgExQxFBcwEaOnd2kKyWjUxWVXnfVVUHhVYVb5BUD/rOdVn4wa94RCPdRw 7iXbM3EoX3IjUHkGwJcVa9NX3KrEuL9r8tcP8Vp1zB676KIJDqbeXPzus3Iss1egVoqB CuuNuyvFzTwhWDr6tNNSOAIXH3lenaBN7ynE+kXwnq/y50hSTMOuc8780yrOhzaGiQjC 6G+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=+YHO8tllqhE3zZEibhkFJzFL4bwce6SonpYoFRaE6uA=; b=D6DEp8fydGe5MUJrvas5HVBL7djoWvHXDwwWQPSJosiZy54RsKKP2vpn/h8EMX5kDm 0nY4555zYSZgAtgSsbO9226IvOUP4ldnr99sbQ/MY4+0RpjmMnVHb6m98XRLPvIESsqG 5d9A3pB47u8c1RrsJOa+Fu+0H+URcWQfVxUf3Mm15wLPi/+LQPsEwT2nmtD79loCvda+ MpZYT1ZKXxatTHM3O97oIB3+Emv9o8s6mCcBxzupmD0A8hTP7zUBj7S4MihG4e0JOaQn ApMe/K9kcsOSjnFLpAfP3aY/McNL89q3t5AxCC+Nh6kmoM3kyfEPDD1emOhjrRL4ZK1M 98/A== X-Gm-Message-State: AN3rC/7n2J4Luspo+gNznqpdz0Z1U1HhdHfrA4T/WOQwaGFeqelfCUaX cy0vjTXRLL8MgdsBUipMx77M++Vfy4JR X-Received: by 10.176.2.80 with SMTP id 74mr13726913uas.23.1493048497395; Mon, 24 Apr 2017 08:41:37 -0700 (PDT) MIME-Version: 1.0 Received: by 10.103.119.11 with HTTP; Mon, 24 Apr 2017 08:41:17 -0700 (PDT) In-Reply-To: References: From: John Scalia Date: Mon, 24 Apr 2017 11:41:17 -0400 Message-ID: Subject: Re: As superuser I still can't update a row in one table To: "David G. Johnston" Cc: "pgsql-admin@postgresql.org" Content-Type: multipart/alternative; boundary=001a113d0e9851e07c054deb7169 X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --001a113d0e9851e07c054deb7169 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 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 >> wrote: >> >>> ERROR: Permission denied: UPDATE is not allowed on rhnpackageevr >>> >>> >> =E2=80=8BThat 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. >> >> > --001a113d0e9851e07c054deb7169 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks for that pointer David. There was, indeed, a trigge= r on the table which called a function raising an exception. I just have ne= ver seen that prior to this database.
<= br>
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.joh= nston@gmail.com> wrote:
On Mon,= Apr 24, 2017 at 8:02 AM, John Scalia <jayknowsunix@gmail.com> wrote:
ERROR:=C2=A0 Permission denied: UPDATE is not allowed on rhnp= ackageevr


=E2=80= =8BThat doesn't look like a system generated message (and grep on the s= ource tree turns up no results) - which means you should be looking for a t= rigger that is blocking you.

David J.



--001a113d0e9851e07c054deb7169--