Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qGhFR-00041u-M6 for pgsql-sql@arkaria.postgresql.org; Tue, 04 Jul 2023 14:43:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qGhFQ-0007JH-GE for pgsql-sql@arkaria.postgresql.org; Tue, 04 Jul 2023 14:43:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qGhFQ-0007J8-73 for pgsql-sql@lists.postgresql.org; Tue, 04 Jul 2023 14:43:20 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qGhFN-002AON-Lz for pgsql-sql@lists.postgresql.org; Tue, 04 Jul 2023 14:43:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1688481796; x=1689086596; i=shammat@gmx.net; bh=x2L2vTIqTReC6p+BbOVEo2WgUUGDifbkU3xHxr1TMSU=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=WLoJ9SFVYz7IMH64jQHOLJ81JOWT85fuWj1c2ZfojTCnuxV3eCu5B7BYFQ5Wl40D0vZ8L3g +I5jyaecG0vQpPZ0EEwI9qKShoEKU3h4TmpOEpZS3mqBfb6qbI0/NoDBD79RWZrONmvDhHRGV c4IyrfeeOMHZa8p/k5vwaDMCj+WC3a8w7KqRfv+o0MLMOhNkmp9ne0K1J3xbXOhrhgOhi01Yr Q64luZwCcRU1c0i5tVHhUsh/cj2EIgFkZti7ZG9ZDzgcegbXOqge4oOPp9NKlTqvOftJ7G4Ek TM3cGZ4Wo436NofgddeXejcW6A6bitQwtrT7G3Y2dSwCvMrrQxMA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.19] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MMGNC-1qXoxO0kdS-00JHFz for ; Tue, 04 Jul 2023 16:43:16 +0200 Subject: Re: How come column is locked? To: pgsql-sql@lists.postgresql.org References: From: Thomas Kellerer Message-ID: <079bd687-382f-13a0-e28a-a31fb58e32f7@gmx.net> Date: Tue, 4 Jul 2023 16:43:15 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:M0daoGxfpDupuk1wYJ0Ah+qWovGcwnJTMRZOPYGscDZH+PTSNTz YYqPkq0Qzu7OWdc2s+UbE6HujZiCqRVKSkrLcFqqLpcg13X59LLrR80At5UaDEUhs+c/Tn1 /O8fF7N8a9o6lAHe2lv3GCXVlE1OU1iK6DNl/ofNo4nfhDiXsH1GqrWgiICIU10VGUu/mH+ 6bEi6Le28yfW53UVINi6Q== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:6aQ2qQS+jZ4=;0RW6HVY9hzWRKs+jHoSpIm7cSF+ ZlxGmtGizPtzNUgoanwe5aej0tqQ8N/JSWqqMJpBLpYvOJPSiFUdorvlrQxlyEny+sEBiFHiK cH1kBGyu8z6FgyEE09b+8p4DLMisRH+DPDHUknfuuZ8Zbf5JX//99WIMw5pKIJZOb1VYPosMT Yc2CJCFOWsStzbmIpAabI0D/uwcuOqfh4lRlEZvvYuIWb2SDQ296uuPpxzJZrVEd0WeZygcOW ly6UV9h4RfKfW+hjtr48U9G2wGV51mvezQjyxv288A+fmW5wyBwIYkGmVpriRv+9WI6e36THn IPwz5PIZm3GyYieM02WZP9FvonZRUJlJiow5cKCA9h34VO/tdF8weEckGruSzPqG7OaaefmLA DxUV6mYUyqf9A0YPbCjdqARAJgQRctZctyO8lBrZE2GLRI7RIM9MX4Ba3zb+alcVPXws1TUHW ebSu3mhhLM+RVyatBvPkF9XyP7q5+AF8kxdhksFO/ov4Y3TsVrcndNcnSi+nX0i5mQVR2iRvN H5gUcNHsCIzw0Zey+Dyjz1zH/Bcw5GdKSsY4va13UDl22crNidax9Clvu6ISGSSKY68TqNUgw YVt5A1XGgTBOgQxnCJxyjM1NNw7mxr0G5URK/lXF0P0/62y5f3qFkh5snRoh4WtE8dpAJ0seb Z1oI6lNUBPWfQFWmoM1S8nLg2qtQyGwWRQVGGdpG3YoTlOyrdliqgE7z1X+GxGvlAYNPe0PNC Ow4a6pcW508rdsA2Jc8FfTzjFVd/s/KhTs1mU2ZfqiEn+3QV4Ifewoy3W+lr5DxbW/3S/UlNZ xU9pWpjSuZvhK97xWBqWjpHRenctAGOFcNDZqJfbikhFo2ZMLu5ANgX4CVQLT3L3YV/hOR683 3vo+380U5Rlzt5KRZ1TMu/ltsFF56IyReZovKMRyE6N6/VCOjWjh6LjZVY428WgaKzprrmjAS j6LSyw== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.