Content-Type: multipart/alternative;
 boundary="------------kEJ9NqxecIwGDPRlZMKiCtSp"
Message-ID: <15c890f3-d5fb-c966-c248-0a5e8f03de62@gmail.com>
Date: Tue, 4 Jul 2023 17:27:52 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.0
Subject: Re: How come column is locked?
Content-Language: en-CA
To: 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>
 <0d3f2872-9ee2-5560-3ee9-b0116154d8b5@gmx.net>
From: Rob Sargent <robjsargent@gmail.com>
In-Reply-To: <0d3f2872-9ee2-5560-3ee9-b0116154d8b5@gmx.net>
Archived-At: 
 <https://www.postgresql.org/message-id/15c890f3-d5fb-c966-c248-0a5e8f03de62%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------kEJ9NqxecIwGDPRlZMKiCtSp
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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?
--------------kEJ9NqxecIwGDPRlZMKiCtSp
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<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 &lt;<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">&lt;mailto:shammat@gmx.net&gt;</a>&gt;
        wrote:
        <br>
        <br>
            Shaozhong SHI schrieb am 04.07.2023 um 16:34:
        <br>
             &gt; I used
        <br>
             &gt;
        <br>
             &gt; create table if not exists waternetwork1.walknetwortt3
        (fid integer[]);
        <br>
             &gt;
        <br>
             &gt; in do statement.
        <br>
             &gt;
        <br>
             &gt; When I use
        <br>
             &gt; insert into waternetwork1.walknetwortt3 select fid
        from a function
        <br>
             &gt;
        <br>
             &gt; it failed.
        <br>
        <br>
            What exactly is the error message you get?
        <br>
        <br>
        <br>
             &gt; 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>

--------------kEJ9NqxecIwGDPRlZMKiCtSp--