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 1qGh7L-0003eC-0G for pgsql-sql@arkaria.postgresql.org; Tue, 04 Jul 2023 14:34:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qGh7I-0008WT-KS for pgsql-sql@arkaria.postgresql.org; Tue, 04 Jul 2023 14:34:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qGh7I-0008WJ-Bn for pgsql-sql@lists.postgresql.org; Tue, 04 Jul 2023 14:34:56 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qGh7F-0020II-PD for pgsql-sql@lists.postgresql.org; Tue, 04 Jul 2023 14:34:54 +0000 Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-51de9c2bc77so4832812a12.3 for ; Tue, 04 Jul 2023 07:34:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688481291; x=1691073291; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=2TnNlsSTMHWnIZIIdMYgBp2sCUGTh7BiyMpTORMs/vA=; b=a0Cekw/boH23Y++R4ezSqOnjY0C0/CVKp1EDpe4Wl8azemZDWl7hGN69CbR1FF8soJ kI6ifc3fDhoqdKsOcAywv/gPo4ixMQBosyn2BFNACoWvTUlcNkqpa5NLKQ59staGHFGt n59JjvRm7K71SKUhpaoibWRLpdmXqpP+p1zZBhsWTAoAZPSq43w5h/kJgFw52ND9MGRG q/oYjXPff6WWpgIv/K2TQto+dcHllrrz8YzAXVj1fWjdCjeGb6w5oRP+6z0D0/QGrDLL bMe1hS7do1gyzUfUR8860bAZPtldKVUSaabNGONUhjx8bda6xyes/OYWwVguMQPSsQEr qiig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688481291; x=1691073291; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=2TnNlsSTMHWnIZIIdMYgBp2sCUGTh7BiyMpTORMs/vA=; b=hMXkZwjxa2JsGmqZe+PyL43cnDQOGltQQk5wH1gtH3RLAc0+U06c1ys2fbXEhGk+n8 N+84WT2X+zfWeg32r9ib4HUakgYdH+HbxA7yn2dTElT1fAr7vgxXqQb0mB4aNwo1mrSU evIh6FbTMWZmHIj2L6C98TAse5A3HRNlGcAOcCCeBFBfxa65Xyinc8GLeym4Qz+VCqOw ae7RDa51RWVRpckDbRaaLW27bG1qPrOrqIDtNcJc8AU98olCH8cw/+AeGnViK8xGRRQD lKSaUKj9LVhHSn1ECQznlmh5zcjRI+fyQ9laUP+PIrHERkIy0lAoPlHSZUy8+LIYCusP AP9g== X-Gm-Message-State: ABy/qLbBsV0Dqqt+KZZJdmWG6VwPObah7Aj0EzZhss1ZQBhOPjYwYxS5 qs7m/zVGEE3aGuEQCe8P7zExPtdUdjo5iD69LhozMrX2DuE= X-Google-Smtp-Source: APBJJlHWrezaQgySHz3wgb0ZO3mcparnX0FRnNmj98Pwn2rvFR9CMJ+3y7uiyL6lcWgDeESyjGKmUNJiYPnFOazrifY= X-Received: by 2002:a17:906:4691:b0:992:7594:e6aa with SMTP id a17-20020a170906469100b009927594e6aamr10446884ejr.40.1688481291214; Tue, 04 Jul 2023 07:34:51 -0700 (PDT) MIME-Version: 1.0 From: Shaozhong SHI Date: Tue, 4 Jul 2023 15:34:40 +0100 Message-ID: Subject: How come column is locked? To: pgsql-sql Content-Type: multipart/alternative; boundary="00000000000092be0b05ffaa2f36" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000092be0b05ffaa2f36 Content-Type: text/plain; charset="UTF-8" Hi, 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. The column is locked. Regards, David --00000000000092be0b05ffaa2f36 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,=C2=A0

=
I used

create table if not exists waternetwor= k1.walknetwortt3 (fid integer[]);

in do statem= ent.

When I use
insert into waternetwork= 1.walknetwortt3 select fid from a function

it fail= ed.

The column is locked.

Regards,

David
--00000000000092be0b05ffaa2f36--