Feedback-ID: i76984098:Fastmail
Message-ID: <4fb5ab14-80c6-4ca8-b451-df3cbcacd92f@aklaver.com>
Date: Sun, 25 Aug 2024 09:13:42 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: ERROR: could not open relation with OID XXXX
To: Marcelo Zabani <mzabani@gmail.com>, Tomas Vondra <tomas@vondra.me>
Cc: pgsql-general@lists.postgresql.org
References: <CACgY3QYe3mqMkODOzwx=EN4iGoddObUotLL8hGnCg==3vmxd_g@mail.gmail.com>
 <73bc7752-442c-4c67-a263-46017f1948cc@vondra.me>
 <CACgY3QYdsYyZQR0hDYFLrk42OJcNOkbW4nfmrauN7byad=6f0A@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CACgY3QYdsYyZQR0hDYFLrk42OJcNOkbW4nfmrauN7byad=6f0A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/4fb5ab14-80c6-4ca8-b451-df3cbcacd92f%40aklaver.com>
Precedence: bulk

On 8/25/24 08:36, Marcelo Zabani wrote:
>  > we do some special stuff for catalogs
> 
> That is good to know, thanks!
> 
>  > I believe you could actually lock the pg_class rows for update. Just 
> add FOR UPDATE at the end of the query.
> 
> Thanks, but I tried that and got "ERROR:  permission denied for table 
> pg_class", even if I try it only for tables the user owns.
> 

As I understand it this issue came up in:

https://github.com/mzabani/codd

I would think that the queries in that case would be running as a 
superuser in order to do the migrations.

-- 
Adrian Klaver
adrian.klaver@aklaver.com