Re: 'WARNING: you don't own a lock of type ExclusiveLock' is printed during the GRANT command on PostgreSQL16.5

From: Noah Misch <noah(at)leadboat(dot)com>
To: "Aya Iwata (Fujitsu)" <iwata(dot)aya(at)fujitsu(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: 'WARNING: you don't own a lock of type ExclusiveLock' is printed during the GRANT command on PostgreSQL16.5
Date: 2024-11-26 02:17:13
Message-ID: 20241126021713.71.nmisch@google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Nov 25, 2024 at 05:54:50AM +0000, Aya Iwata (Fujitsu) wrote:
> >Did you ever see the WARNING with a DATABASE command, or just with a
> >TABLESPACE command?
>
> We tried this, but there is no WARNING on GRANT xxx ON DATABASE command.
>
> But I did notice a warning while REVOKE xxx ON TABLESPACE.
>
> $ psql -x -p 5432 -d postgres -c "REVOKE CREATE ON TABLESPACE test_tbl_spc FROM nmluser1;"
> WARNING: you don't own a lock of type ExclusiveLock
> REVOKE
>
> So both GRANT and REVOKE command on TABLESPACE seems to throw an WARNING.

That makes sense. I've pushed postgr.es/c/4ba84de for this.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2024-11-26 02:25:40 Re: Build failure with GCC 15 (defaults to -std=gnu23)
Previous Message Tom Lane 2024-11-26 02:13:11 Re: Build failure with GCC 15 (defaults to -std=gnu23)