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@xxxxxxxxxxx
