PQexecPrepared - PostgreSQL 7.4.1 - Mailing list pgsql-bugs

From Theo Kramer
Subject PQexecPrepared - PostgreSQL 7.4.1
Date
Msg-id 1082475941.4357.118.camel@dhcp0.coza.net.za
Whole thread Raw
List pgsql-bugs
Hi

I am having a problem with PQexecPrepared() as follows (derived from
testlibpq3.c)

PQexec(conn,
   "PREPARE S0000123_000 (text) AS SELECT * from test1 WHERE t = $1");

When invoking PQexecPrepared() I get the following message from the
backend

ERROR:  prepared statement "S0000123_0000" does not exist


Yet if I use

PQexec(conn, "EXECUTE S0000123_0000 ('ho there')");

instead of PQexecPrepared() then all works perfectly.

Sounds like a bug to me...?

Regards
Theo

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Record type and ROW type in pl/pgsql functions
Next
From: "Donald Fraser"
Date:
Subject: Permissions on Views