Subject: Re: How come column is locked?
To: Shaozhong SHI <shishaozhong@gmail.com>, pgsql-sql@lists.postgresql.org
References: 
 <CA+i5JwaZ5T1VSQ1GNPmx4DgYJcZpFwpfoAd0d+pG0XZgRuVi9w@mail.gmail.com>
 <079bd687-382f-13a0-e28a-a31fb58e32f7@gmx.net>
 <CA+i5JwZvyabamZhCPaE+64NLJeKYD59Ftw+Qd6HPSFjftFMoig@mail.gmail.com>
From: Thomas Kellerer <shammat@gmx.net>
Message-ID: <0d3f2872-9ee2-5560-3ee9-b0116154d8b5@gmx.net>
Date: Tue, 4 Jul 2023 20:39:09 +0200
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21)
 Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
MIME-Version: 1.0
In-Reply-To: 
 <CA+i5JwZvyabamZhCPaE+64NLJeKYD59Ftw+Qd6HPSFjftFMoig@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: de-DE
Content-Transfer-Encoding: quoted-printable
UI-OutboundReport: notjunk:1;M01:P0:1JG+HI9UYTI=;DnFp5tIg69hbSx/owSxdALFaxO0
 71gUw0JOtlg8K21d8KqNAFIobJOA4ZGeCvSow03xQhtTwtyVQHKx+Cfc6Z+u6C6Y/UWPdGmoZ
 fd1luUQR1dTpupK/EldGP/cqXn3KNHOhdPt8YMVSKZb2U8yHjCWaFTEEbjhSaCnTckMyVTgTw
 7uo0Tw0MX7t9MAt4U2Hrf5pegMXzgfH0shbqRffkn7C+kyxGHHV1cZZBy2s4O9HYD8TfCoxyq
 ZAG51J4e2jHafdcdd8gjxlAYhjx3yPhS48KKlUT/wGO6MoB1xo9eUSjR6glmh1p6MUKDxLv/Y
 eMxHlqb/WbVpaqMxxCgl+t739LBBR3GVsSIETAhV0buRH7uTk2coOyKlSZPC09EWKG8ppmQIT
 U6FV+xeQtDYqXveXGtwk+IqeL26mTH/9xEnaYdsEZiYlOSN5yj+IYXZWP7wmcLalW+HRUKOc0
 hOzMwRjAN+Wp0y66yByTIJgByCYBYmW1YBnasHDv7aMMUkmO7qiYeLxwFXcczoGLGuK/X9Bnc
 Xb4df57poB1kEsYkwW+RjV6VUVzm4gIzdowwFPihrfuKJqQ3b5UlggQZui/urVcSJLypy1uYx
 X44wJ4XE8EnfGI9zcu1h6gRTG8Gd/HD7I19WGWDw4neX/3yk7zpZ8vEo8B5pGmca+NcpUGd0w
 vKxbu3dmNOyPQUEQ/5r3iCKnxMAIpLvNOweX8B0/tXd0w9WsdmzQfVhKPUhx67D5h9sqmdpbA
 6MJ4ZqYkdOXGI/QBsZSy+8m2agyZnPY/wH93xnPhExXwE3uUsm07hGa8rjrnz0Xm+6xD131Qz
 0/4Sr840Ufwe+VL6A7p/viXgcAm7r02U/Hp+avOsBQP957p8wtJ3QM1EdtNsMcsZ0CiB44fD7
 SjBwrbMhRcmBJggloWJH4qAmfWPiQz5YMK8S1KRW00d+XVhbMsnl1V2saglUDI/hcLLexothv
 zTua/+3f3Q78o6gvtIZ4p9qiRg0=
Archived-At: 
 <https://www.postgresql.org/message-id/0d3f2872-9ee2-5560-3ee9-b0116154d8b5%40gmx.net>
Precedence: bulk

Shaozhong SHI schrieb am 04.07.2023 um 16:59:
> On Tue, 4 Jul 2023 at 15:43, Thomas Kellerer <shammat@gmx.net <mailto:sh=
ammat@gmx.net>> wrote:
>
>     Shaozhong SHI schrieb am 04.07.2023 um 16:34:
>      > I used
>      >
>      > create table if not exists waternetwork1.walknetwortt3 (fid integ=
er[]);
>      >
>      > in do statement.
>      >
>      > When I use
>      > insert into waternetwork1.walknetwortt3 select fid from a functio=
n
>      >
>      > 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.=C2=A0 That is the only column.

There is no such thing as a "padlock" in Postgres.