Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wNFna-000g9S-1J for pgsql-admin@arkaria.postgresql.org; Wed, 13 May 2026 20:03:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wNFnZ-00A91o-0b for pgsql-admin@arkaria.postgresql.org; Wed, 13 May 2026 20:03:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wNFnY-00A91g-2X for pgsql-admin@lists.postgresql.org; Wed, 13 May 2026 20:03:16 +0000 Received: from sm-r-004-dus.org-dns.com ([89.107.70.13]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wNFnV-00000000QQm-2hph for pgsql-admin@lists.postgresql.org; Wed, 13 May 2026 20:03:16 +0000 Received: from smarthost-dus.org-dns.com (localhost [127.0.0.1]) by smarthost-dus.org-dns.com (Postfix) with ESMTP id A4D44A3075 for ; Wed, 13 May 2026 22:03:11 +0200 (CEST) X-Spam-Status: No, score=0.9 required=5.0 tests=AWL,BAYES_50,DKIM_INVALID, DKIM_SIGNED,DMARC_NONE,HTML_MESSAGE,KAM_INFOUSMEBIZ, MIME_HEADER_CTYPE_ONLY,SPF_HELO_PASS autolearn=no autolearn_force=no version=4.0.1 X-Spam-Tests: AWL=-1.024,BAYES_50=0.8,DKIM_INVALID=0.1,DKIM_SIGNED=0.1, DMARC_NONE=0.1,HTML_MESSAGE=0.001,KAM_INFOUSMEBIZ=0.75, MIME_HEADER_CTYPE_ONLY=0.1,SPF_HELO_PASS=-0.001 Received: from ha01s018.org-dns.com (ha01s018.org-dns.com [62.108.32.138]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by smarthost-dus.org-dns.com (Postfix) with ESMTPS id 2B85AA3071 for ; Wed, 13 May 2026 22:03:11 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gelassene-pferde.biz; s=default; t=1778702592; bh=2aAklgKxtcDU7y/QSyBhKDJ3b5ddGl54Iwk7x/nqbDk=; h=From:To:Subject; b=F6WotjfJZ4I7prkPqA5L9kt+BFlqOlPjNeMSbA6bzMEMYED4oxwBQ0H9I6xoDEIMU KqgTNthjXlDgHVny2S2vJifq4CIpp33cFDfwuWXr1n7YGJnmLqD9R/TIR7Qliq3hu3 le/iWW8YhgcFbo52aEq6M7CSISuyJG2gVz+vn/A4= Authentication-Results: ha01s018.org-dns.com; spf=pass (sender IP is 146.185.68.202) smtp.mailfrom=thiemo@gelassene-pferde.biz smtp.helo=dummy.faircode.eu Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated) Date: Wed, 13 May 2026 22:03:10 +0200 From: Thiemo Kellner To: pgsql-admin@lists.postgresql.org Message-ID: <41fcedd6-179c-440f-8e4b-b3032db25839@gelassene-pferde.biz> In-Reply-To: References: Subject: Puzzling "INSERT has more expressions than target columns" error Content-Type: multipart/alternative; boundary="----=_Part_31_170809593.1778702590263" X-Correlation-ID: <41fcedd6-179c-440f-8e4b-b3032db25839@gelassene-pferde.biz> X-PPP-Message-ID: <177870259241.1387715.11053558051568990402@ha01s018.org-dns.com> X-PPP-Vhost: gelassene-pferde.biz X-Virus-Scanned: clamav-milter 1.4.3 at smarthost-dus X-Virus-Status: Clean List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_31_170809593.1778702590263 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi Did you make sure, the order of the columns is identical? Well, maybe that should result in a different error. My two dimes Thiemo ------=_Part_31_170809593.1778702590263 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi

Did you make sure, the order of the columns is identical? Well, maybe that should result in a different error.

My two dimes

Thiemo
------=_Part_31_170809593.1778702590263--