| From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
|---|---|
| To: | Shaozhong SHI <shishaozhong(at)gmail(dot)com>, pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | Re: How come column is locked? |
| Date: | 2023-07-04 18:39:09 |
| Message-ID: | 0d3f2872-9ee2-5560-3ee9-b0116154d8b5@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Shaozhong SHI schrieb am 04.07.2023 um 16:59:
> On Tue, 4 Jul 2023 at 15:43, Thomas Kellerer <shammat(at)gmx(dot)net <mailto:shammat(at)gmx(dot)net>> wrote:
>
> 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.
>
>
>
>
> I see a pad lock on the column. That is the only column.
There is no such thing as a "padlock" in Postgres.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2023-07-04 23:27:52 | Re: How come column is locked? |
| Previous Message | Karsten Hilbert | 2023-07-04 17:09:43 | Aw: Working around insert into a_table from select things from a_function |