[BUGS] update on unique constraint

2000-11-22 Thread Theo Kramer
postgresql 7.0.3 on RedHat 7.0 -- create table whois (domain text, version integer); CREATE theo=# create unique index whois_idx on whois (domain,version); CREATE theo=# insert into whois values ('mydomain.co.za', 0); INSERT 18829 1 theo=# insert into whois values ('my

[BUGS] PQexecPrepared - PostgreSQL 7.4.1

2004-04-20 Thread Theo Kramer
Hi I am having a problem with PQexecPrepared() as follows (derived from testlibpq3.c) PQexec(conn, "PREPARE S123_000 (text) AS SELECT * from test1 WHERE t = $1"); When invoking PQexecPrepared() I get the following message from the backend ERROR: prepared statement "S123_" does

Re: [BUGS] BUG #1178: PQexecPrepared - PostgreSQL 7.4.1

2004-06-24 Thread Theo Kramer
On Tue, 2004-06-22 at 19:23, Tom Lane wrote: > "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > > PQexec(conn, > >"PREPARE S123_000 (text) AS SELECT * from test1 WHERE t = $1"); > > When invoking PQexecPrepared() I get the following message from the backend > > ERROR: prepared stateme