[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: Re: How come column is locked?
From: Rob Sargent <robjsargent () gmail ! com>
Date: 2023-07-04 23:27:52
Message-ID: 15c890f3-d5fb-c966-c248-0a5e8f03de62 () gmail ! com
[Download RAW message or body]
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@gmx.net
>> <mailto:shammat@gmx.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?
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 7/4/23 12:39, Thomas Kellerer wrote:<br>
</div>
<blockquote type="cite"
cite="mid:0d3f2872-9ee2-5560-3ee9-b0116154d8b5@gmx.net">Shaozhong
SHI schrieb am 04.07.2023 um 16:59:
<br>
<blockquote type="cite">On Tue, 4 Jul 2023 at 15:43, Thomas
Kellerer <<a class="moz-txt-link-abbreviated" \
href="mailto:shammat@gmx.net">shammat@gmx.net</a> <a class="moz-txt-link-rfc2396E" \
href="mailto:shammat@gmx.net"><mailto:shammat@gmx.net></a>> wrote:
<br>
<br>
Shaozhong SHI schrieb am 04.07.2023 um 16:34:
<br>
> I used
<br>
>
<br>
> create table if not exists waternetwork1.walknetwortt3
(fid integer[]);
<br>
>
<br>
> in do statement.
<br>
>
<br>
> When I use
<br>
> insert into waternetwork1.walknetwortt3 select fid
from a function
<br>
>
<br>
> it failed.
<br>
<br>
What exactly is the error message you get?
<br>
<br>
<br>
> The column is locked.
<br>
<br>
There is no column level lock in Postgres.
<br>
<br>
The smallest unit that can be locked is a row.
<br>
<br>
<br>
<br>
<br>
I see a pad lock on the column. That is the only column.
<br>
</blockquote>
<br>
There is no such thing as a "padlock" in Postgres.
<br>
<br>
<br>
<br>
<br>
</blockquote>
<font face="Courier New, Courier, monospace">GUI-speak for primary
key, perhaps?</font><br>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic