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 1w0mGl-002CSe-0P for pgsql-general@arkaria.postgresql.org; Thu, 12 Mar 2026 20:04:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0mGj-00HLV7-1f for pgsql-general@arkaria.postgresql.org; Thu, 12 Mar 2026 20:04:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w0mGj-00HLUz-0Y for pgsql-general@lists.postgresql.org; Thu, 12 Mar 2026 20:04:29 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w0mGh-00000002Lse-0dUW for pgsql-general@lists.postgresql.org; Thu, 12 Mar 2026 20:04:29 +0000 Received: by mail-ed1-x52a.google.com with SMTP id 4fb4d7f45d1cf-6638ce09a31so1625721a12.0 for ; Thu, 12 Mar 2026 13:04:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1773345866; x=1773950666; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=FYINuiUuPKWPFceXjH7SJ9ZluWce1pN/6APi5poJFjU=; b=hJeclpAFWEaczcTJVblAmYa8XwZ29ejjNB9Y7gzL/ySuL7Cyxg0XyVyqrw95javir/ 0yTFdIZDDRFSbHhEdGWBaFRoW92xuwlXZDZONbjVXFqHjbo8CCtb7kZswg4oUPuEUwRW Zn+m1tm9VB+o0qU9IqOwsejVpzorymmMw7WdEN/M+zRnZuixRdHqHqnbHileCZOZqxVT TsPIho9q09uavOcBv42e4C4Wq5noQfrTFtw70flBXDjFxnNX0CrO9jQKFGvSMPkDJ7k2 x28pWvOiLXZ812AHNVtySyaRfY/5y5jeyWTJWPuV3RM29V5z5n/GDR/9+I1rE0oAhYPB WtSw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773345866; x=1773950666; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=FYINuiUuPKWPFceXjH7SJ9ZluWce1pN/6APi5poJFjU=; b=sUgrZZngpkYGmTw6R9AbOVERY1zhYVXEnk7t/TUNhuQyZBSc5AzPs9zEv9kWhKfW4O rSetLZm8G4uU5oiNZIywadncazI9psAuZtTH/uPWIaFO2leCJJm+bpBcXhpAb3FyVyv4 Xm4Oz1GXFW4BVi0cg8AQ9PrSnmoxnvbdROVE4r33B4xoTTd9UWIYXHsHyK8DsEbaQkmF Zc58/T7ZHJAMFbOGt9sZPL2YC4TKKkfhko0kKoztuf6/QefDhido2rXCNQOX/N7k+Zrc fzMA0uGNGozn4Pw6OF7naOBlXboZn9bt9C3MnCc4VJo47q2h4LLuT9MGmRNLLxTOgk8G n6Yw== X-Forwarded-Encrypted: i=1; AJvYcCWaG6nDkAc4WaBz8WDi7hXQSMV2+J8wcvrpwZ0at8vfJXbFwL6cmX7SPjaeUIQEoPXuf+6XaDZMzCtJmOpG@lists.postgresql.org X-Gm-Message-State: AOJu0Yxal2Om4nGi5xeVg6gDCT3Fad3qakp9InWhBJcGR/TLS+ibHDV8 svcFUCW9vQ3wLRMsWSZK/41gWTD/BVlmHB3bg4TgD/dzY2VziimUUd8y5ydiBCK5TWv+kDSl4MI +KUsEduk= X-Gm-Gg: ATEYQzyBsQCmqry92sjFpd/tCncwf2GeaQPrbDBeYxbBaDXRZbRGqlpR68Olzi6nW9r 7YB3aPp39FgPduPYxLe9KSJpwARP8YohPslHKiqTUa91txsY+lHKFn6Pzi3WmMJ5Y+Lg8v5RKIU YjKDBdpYzmCyrd8UYUTcym+sBzUQOItxfTyixDEzQLs0KstWjPbDGI2IhKr1D5fHCb47jPS46tI /9oKXl7vmXY45WO9ixEIQ/oIMISx27WBh0XRY77l2qXF9pBSJgllGDbKScsJkfZWlWfhG3nckd8 3eD66Ac1GdKe2TEhrMDyytCbWgCoCG0PRBG1Ac7HiZkb0WQv+3zBJ9wanOvlEUaeGXTT+tTyUFt JhUmd76CiDNkgfxDNml7lbjm8jE5AxNZKmnScp9SWk2cUEOgGrf8Zu6P1+9AJRwDuHHW0l1KM1u wBkFSjNxqin+N7ifb/9oG8TwWP+Zs5vtPcyRq5YJKN3SNCPF6peYO/QQiINEg94+a3ydZLQQx/U b4NjykNucFtm4hOZLJU+zNple1aSDnKBwRHYt1JmSqi0tE= X-Received: by 2002:a17:907:6d24:b0:b96:ef9a:7432 with SMTP id a640c23a62f3a-b97651e9ed3mr43471266b.56.1773345865747; Thu, 12 Mar 2026 13:04:25 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D (dynamic-046-114-168-089.46.114.pool.telefonica.de. [46.114.168.89]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b9767a42f40sm5040566b.66.2026.03.12.13.04.24 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Mar 2026 13:04:25 -0700 (PDT) Message-ID: <1ef446b1b7c8e4e147f65ce0309802a03f8ca5a6.camel@cybertec.at> Subject: Re: POprepare fails From: Laurenz Albe To: Igor Korot , "pgsql-generallists.postgresql.org" Date: Thu, 12 Mar 2026 21:04:24 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2026-03-12 at 20:16 -0500, Igor Korot wrote: > ERROR: syntax error at or near \"AND\"\n > LINE 1: ...lnamespace AND idx.indisprimary AND n.nspname =3D ? AND t.reln= ... >=20 > What is going on? You used the question mark as a parameter placeholder, but you are using the C API, not JDBC. The placeholders are $1, $2 and so on. Yours, Laurenz Albe