MIME-Version: 1.0
References: <CA+FnnTyFmj-dTMDO108_WowHMS479-OFBT71oNC=NY98Vg01Nw@mail.gmail.com>
 <1ef446b1b7c8e4e147f65ce0309802a03f8ca5a6.camel@cybertec.at>
In-Reply-To: <1ef446b1b7c8e4e147f65ce0309802a03f8ca5a6.camel@cybertec.at>
From: Igor Korot <ikorot01@gmail.com>
Date: Thu, 12 Mar 2026 13:16:07 -0700
Message-ID: <CA+FnnTwh2U4Lo-Uf2pn-i=FeVgU8dd6RDZE5n8WPzEPySgvCnA@mail.gmail.com>
Subject: Re: POprepare fails
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000da0941064cd96c05"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTwh2U4Lo-Uf2pn-i%3DFeVgU8dd6RDZE5n8WPzEPySgvCnA%40mail.gmail.com>
Precedence: bulk

--000000000000da0941064cd96c05
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thx, Lauren=E2=80=99s.


On Thu, Mar 12, 2026 at 1:04=E2=80=AFPM Laurenz Albe <laurenz.albe@cybertec=
.at>
wrote:

> 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...
> >
> > 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
>

--000000000000da0941064cd96c05
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Thx, Lauren=E2=80=99s.</div><div dir=3D"auto"><br></div><=
div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" c=
lass=3D"gmail_attr">On Thu, Mar 12, 2026 at 1:04=E2=80=AFPM Laurenz Albe &l=
t;<a href=3D"mailto:laurenz.albe@cybertec.at">laurenz.albe@cybertec.at</a>&=
gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0=
 .8ex;border-left:1px #ccc solid;padding-left:1ex">On Thu, 2026-03-12 at 20=
:16 -0500, Igor Korot wrote:<br>
&gt; ERROR:=C2=A0 syntax error at or near \&quot;AND\&quot;\n<br>
&gt; LINE 1: ...lnamespace AND idx.indisprimary AND n.nspname =3D ? AND t.r=
eln...<br>
&gt; <br>
&gt; What is going on?<br>
<br>
You used the question mark as a parameter placeholder, but you are using<br=
>
the C API, not JDBC.=C2=A0 The placeholders are $1, $2 and so on.<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div></div>

--000000000000da0941064cd96c05--