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

From Thomas Kellerer
Subject Re: How come column is locked?
Date
Msg-id 079bd687-382f-13a0-e28a-a31fb58e32f7@gmx.net
Whole thread Raw
In response to How come column is locked?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
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.




pgsql-sql by date:

Previous
From: William Alves Da Silva
Date:
Subject: Re: How come column is locked?
Next
From: Tom Lane
Date:
Subject: Re: How come column is locked?