Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1icI6Q-0003MB-7g for psycopg@arkaria.postgresql.org; Wed, 04 Dec 2019 00:01:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1icI6N-0002yG-Sz for psycopg@arkaria.postgresql.org; Wed, 04 Dec 2019 00:01:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1icI6N-0002y9-Ff for psycopg@lists.postgresql.org; Wed, 04 Dec 2019 00:01:07 +0000 Received: from mail-vk1-xa43.google.com ([2607:f8b0:4864:20::a43]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1icI6I-0002Og-93 for psycopg@lists.postgresql.org; Wed, 04 Dec 2019 00:01:06 +0000 Received: by mail-vk1-xa43.google.com with SMTP id p191so1620553vkf.8 for ; Tue, 03 Dec 2019 16:01:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=+5RwAQnpfBar0Gb8n84ozHRjoK/NnXEY9fkSwC0N99I=; b=czv6y2VxVFz6dzJFrr529LpfHetScHIPpmTLbKKtQIhdSqK37G6XtWp5426eF9dQKJ wK+a+OlRYW+5HHynFYp0y9vpYOMDUabgzfhPU1YVnIRmJJREww3o0CITvPvLCqSxP40j KdcvW82/mfaQeOkhRXLoMFlrL2KITRI1v3Cw5EwiPYPjxJJdjDXdWPuGMVZKwhfXQVE5 Y10pFAv8F88GnPT2E2bB8jUFqKdXR1ExVp9XPpJhV3Alzl1ndmLAK7WpbSeg6Haf1imb ls+y9AixMf4kC6r96BrCZC08uHqbEjOCq5dCfau+rOOe2c1VVu7PsC+1NmoGz1nLBy87 h10w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=+5RwAQnpfBar0Gb8n84ozHRjoK/NnXEY9fkSwC0N99I=; b=CZGEyBc7/oajCtyVF4JYFxWZYJJRX+ujjK/RL9nUHzvHaLiP4UIs3iJQc8O39QNqY8 shft0CBec0z//ZXnqr8nWURmeuDE9uXDZiP+GNvLu90aFb1/8Yyx58d+824lN4PZaEvE H/QZoTBoDSvmNNY1UiM1YxAxH8fw6dlqd4+fgMiNFxSa8f7s1sin2nw8ismfyTlE1eBO n4p2yPzmORXQGi/NVj66mEaRiE+rA9bVrVhVZEZ8/VfcdduOwugn9i0B4Ls9fOz66RU3 RE8skQAgUosL/Af1uuYeN0sLnf5Zq+3rRTmCsda9vyYgeKS9vE7MZfyVDBXHWiYBxXMC ghQg== X-Gm-Message-State: APjAAAW5NaIn67OHg3bfPjGJyOZwNIMV0fitMidHLbz/rMxWOugxIErn ualuoFPVhMdJEmbh+ujmIePJ0g6UTFl+//pc5PA= X-Google-Smtp-Source: APXvYqx4zlgQ1csUJt9ZfwSqOUEn3v11snQgFzWoINOapt6108LZh9mwuBW9d7ufuxODhk503AE6DclF3tCzzhJSsn0= X-Received: by 2002:a1f:fe45:: with SMTP id l66mr301288vki.9.1575417661014; Tue, 03 Dec 2019 16:01:01 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Vladimir Ryabtsev Date: Tue, 3 Dec 2019 16:00:50 -0800 Message-ID: Subject: Re: Array of tuples as a parameter, with type casts To: Adrian Klaver Cc: psycopg@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000000ec8ea0598d582e1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000000ec8ea0598d582e1 Content-Type: text/plain; charset="UTF-8" It does not change much, the error message just says it now expects 'character varying'. Anyway bigint problem is the next in the line. -- Regards, Vladimir --0000000000000ec8ea0598d582e1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
It does not change much, the error messag= e just says it now expects 'character varying'.
Anyway bigint problem is the next in the line.

=
--
Regards,
Vladimir
--0000000000000ec8ea0598d582e1--