On Thu, January 11, 2007 21:04, Khoa Nguyen wrote: > Thanks for your response. I have postgresql 7.4 on the client side, > and the server side is running 8.0.3. The libpqxx version is 2.6.8 on > the client side. Will this combination break prepared statement?
Oh, I think I get it... As I said, this stuff gets complicated sometimes. There is a *fourth* factor influencing this: libpq 7.4 doesn't support querying of the server version, so libpqxx can't determine whether the server supports prepared statements. That in itself is no problem: libpqxx will simulate them. Preparation will be skipped, and execution will just issue a copy of your SQL statement with parameters substituted. But IIRC it was possible in 2.6.8 for these two bits of logic to disagree on which course should be followed. That 2.6.9 pre-release I posted earlier also fixes this problem (and in any case knows how to guess the server version if libpq doesn't support querying it). You could either try that, or try building against an 8.x version of libpq. Jeroen _______________________________________________ Libpqxx-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/libpqxx-general
