Re: POprepare fails - Mailing list pgsql-general

From Igor Korot
Subject Re: POprepare fails
Date
Msg-id CA+FnnTwh2U4Lo-Uf2pn-i=FeVgU8dd6RDZE5n8WPzEPySgvCnA@mail.gmail.com
Whole thread
In response to Re: POprepare fails  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Thx, Lauren’s.


On Thu, Mar 12, 2026 at 1:04 PM 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 = ? 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

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: POprepare fails
Next
From: Martin Goodson
Date:
Subject: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'