Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.500.231\))
Subject: Re: How come column is locked?
From: William Alves Da Silva <william_silva@unochapeco.edu.br>
In-Reply-To: 
 <CA+i5JwaZ5T1VSQ1GNPmx4DgYJcZpFwpfoAd0d+pG0XZgRuVi9w@mail.gmail.com>
Date: Tue, 4 Jul 2023 11:40:23 -0300
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <0883BDDF-C31D-405E-91A3-DAD456A89773@unochapeco.edu.br>
References: 
 <CA+i5JwaZ5T1VSQ1GNPmx4DgYJcZpFwpfoAd0d+pG0XZgRuVi9w@mail.gmail.com>
To: Shaozhong SHI <shishaozhong@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/0883BDDF-C31D-405E-91A3-DAD456A89773%40unochapeco.edu.br>
Precedence: bulk

Hello,

In PostgreSQL, DDL statements will get lock, if you don=E2=80=99t 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:
>=20
> Hi,=20
>=20
> I used
>=20
> create table if not exists waternetwork1.walknetwortt3 (fid =
integer[]);
>=20
> in do statement.
>=20
> When I use
> insert into waternetwork1.walknetwortt3 select fid from a function
>=20
> it failed.
>=20
> The column is locked.
>=20
> Regards,
>=20
> David