Re: How come column is locked?

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: How come column is locked?
Date: 2023-07-04 14:43:15
Message-ID: 079bd687-382f-13a0-e28a-a31fb58e32f7@gmx.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2023-07-04 14:47:47 Re: How come column is locked?
Previous Message William Alves Da Silva 2023-07-04 14:40:23 Re: How come column is locked?