[Pgpool-general] prepared statements
Simone Tregnago
simonetregnago at grivaonline.com
Tue Oct 28 09:33:27 UTC 2008
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
More information about the Pgpool-general
mailing list