[Pgpool-general] prepared statements

[Simone Tregnago]

There isn't anyone who have an idea about the trouble that I've
reported in my last email?
Thanks,
Simone
-------------------------
Hi,
yesterday I've written a function that produce the following error:

Oct 27 16:03:45 pgmirror1 pgpool: 2008-10-27 16:03:45 ERROR: pid 5529:
pool_read_kind: kind does not match between master(73) slot[1] (84)
Oct 27 16:03:45 pgmirror1 pgpool: 2008-10-27 16:03:45 ERROR: pid 5529:
pool_read_kind: kind does not match between master(73) slot[1] (84)

The error appears when I execute prepared statements. If I change the
method, executing new statements each time without preparing them
before, then pgpool works well without errors.

For example, one statement that raise the error is:
update presenze.boldaydet set "IDCAUSALE"=
	(select "IDCAUSALE" from presenze.causali
	 where "CODCAUSALE"=:codcausale)
	where"IDBOLDAYDET"=:idboldaydet

It's possible that using a prepared statement with a select inside an
update confuses pgpool?
The function is written in .net, with the Npgsql connector. Pgpool-II is
version 2.1, and Postgresql backend is 8.1.11

Thanks,
Simone Tregnago
_______________________________________________
Pgpool-general mailing list
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general