Skip site navigation (1) Skip section navigation (2)

BUG #1178: PQexecPrepared - PostgreSQL 7.4.1

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1178: PQexecPrepared - PostgreSQL 7.4.1
Date: 2004-06-22 15:34:19
Message-ID: 20040622153419.010B2CF4C1D@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1178
Logged by:          Theo Kramer

Email address:      theo(at)flame(dot)co(dot)za

PostgreSQL version: 7.4

Operating system:   Redhat Linux 9

Description:        PQexecPrepared - PostgreSQL 7.4.1

Details: 

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


Responses

pgsql-bugs by date

Next:From: Joe CarlsonDate: 2004-06-22 16:31:46
Subject: Re: BUG #1175: insert rule action with defaults
Previous:From: Bruno Wolff IIIDate: 2004-06-22 13:57:20
Subject: Re: BUG #1176: PHP connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group