Re: How come column is locked?

Shaozhong SHI schrieb am 04.07.2023 um 16:34:
> I used
>
> create table if not exists waternetwork1.walknetwortt3 (fid integer[]);
>
> in do statement.
>
> When I use
> insert into waternetwork1.walknetwortt3 select fid from a function
>
> it failed.

What exactly is the error message you get?


> The column is locked.

There is no column level lock in Postgres.

The smallest unit that can be locked is a row.