Horton

Re: How come column is locked?

William Alves Da Silva <william_silva@unochapeco.edu.br>

View thread View on postgr.es
From: William Alves Da Silva <william_silva@unochapeco.edu.br>
To: Shaozhong SHI <shishaozhong@gmail.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Date: 2023-07-04T14:40:23Z
Lists: pgsql-sql 
Hello,

In PostgreSQL, DDL statements will get lock, if you don’t commit the change, all futures queries will be put on hold.

Reggards,
WIlliam Alves

> On 4 Jul 2023, at 11:34, Shaozhong SHI <shishaozhong@gmail.com> wrote:
> 
> Hi, 
> 
> 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.
> 
> The column is locked.
> 
> Regards,
> 
> David