| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: POprepare fails |
| Date: | 2026-03-12 20:16:07 |
| Message-ID: | CA+FnnTwh2U4Lo-Uf2pn-i=FeVgU8dd6RDZE5n8WPzEPySgvCnA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thx, Lauren’s.
On Thu, Mar 12, 2026 at 1:04 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Goodson | 2026-03-12 21:02:59 | (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' |
| Previous Message | Laurenz Albe | 2026-03-12 20:04:24 | Re: POprepare fails |