PQexecPrepared - PostgreSQL 7.4.1

From: Theo Kramer <theo(at)flame(dot)co(dot)za>
To: psql-bugs(at)postgresql(dot)org
Subject: PQexecPrepared - PostgreSQL 7.4.1
Date: 2004-04-20 15:45:41
Message-ID: 1082475941.4357.118.camel@dhcp0.coza.net.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Rodrigo Moreno 2004-04-20 20:29:22 Problem when truncate table and get the OID from PQftable
Previous Message Tom Lane 2004-04-20 12:42:17 Re: Record type and ROW type in pl/pgsql functions