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
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
