On 7/4/23 12:39, Thomas Kellerer wrote:
> 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.
>
>
>
>
GUI-speak for primary key, perhaps?