[Pgpool-general] Bug when using Pgpool and PQprepare

[denis at edistar.com]

Hi to all.

I think there is a very odd behaviour of pgpool when using PQprepare,
PQexecPrepare during a transaction.

When calling in transaction PQexecPrepare errors are not trapped.
Postgres executes the prepared statement terminating with an error but
pgpool does not send the error to the client.

The problem does not occur when the call to PQexecPrepare is done
outside of a transaction block.

I attached sample code test.c that reproduces the bug.

In order to test it, you must create a sample table in a database named
"test" like this:

create table test_table(
    a integer not null
);

I'm using pgpool II 2.2.4 in connection pooling mode (no replication or
load balance) with postgres 8.2.12.
The connections are made to pgpool via socket (dir /var/run, port 11271).

Thank you in advance,

Doct. Eng. Denis Gasparin
---
Edistar SRL

-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.c
Type: text/x-csrc
Size: 1624 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090826/1ca9b731/attachment.bin>