| From: | William Alves Da Silva <william_silva(at)unochapeco(dot)edu(dot)br> |
|---|---|
| To: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
| Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How come column is locked? |
| Date: | 2023-07-04 14:40:23 |
| Message-ID: | 0883BDDF-C31D-405E-91A3-DAD456A89773@unochapeco.edu.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2023-07-04 14:43:15 | Re: How come column is locked? |
| Previous Message | Shaozhong SHI | 2023-07-04 14:34:40 | How come column is locked? |