Re: How come column is locked? - Mailing list pgsql-sql

Shaozhong SHI schrieb am 04.07.2023 um 16:59:

On Tue, 4 Jul 2023 at 15:43, Thomas Kellerer <shammat@gmx.net <mailto:shammat@gmx.net>> wrote:

    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.




I see a pad lock on the column.  That is the only column.

There is no such thing as a "padlock" in Postgres.