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