How to unlock columns in PostgreSQL?

Question

PostgreSQL

There was a server, there was a database in it, there were several tables in the database itself, everything went well, but after the migration, for some reason, all the columns in one of the tables began to be blocked. I went through pgAdmin and saw something like this:

And other tables have normal columns:

After digging in Google, I tried many ways to get PID queries that lock the table, but all to no avail. I tried to prescribe a trite commit , but he also said that nothing is being done

I then deleted the table, created a new one with a different name, but the columns were blocked there too, I created another database and a new table there, but the columns were blocked there too. That is, at the moment there is such a situation that in any case, whatever I would not create, it all has some kind of lock by default, how to get rid of this problem?

A few obvious answers in advance:
Logged in: As administrator
Restart: For certain reasons, it is better not to do this, maybe only if nothing happens at all

select * from pg_locks;

Я пробовал и pg_cancel_backend, и pg_terminate_backend, но результата ноль. Выводят true, а если снова запросить блокировки, то тоже самое, но PID другой. Есть предположение, что это мой же процесс, но я в этих знаниях слаб

select * from pg_prepared_xacts;

Answer 1

Try adding a primary key to the table