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?
Thanks, Khoa On 1/11/07, Jeroen T. Vermeulen <[EMAIL PROTECTED]> wrote: > On Thu, January 11, 2007 03:13, Khoa Nguyen wrote: > > > I have problems creating prepared statement. It came back with this > > error message: > > SQL error: ERROR: prepared statement "InsertMSISDN" does not exist. > > What server version are you talking to, and which libpq version are you > using? > > The reason I'm asking is that this area of libpqxx contains some code to > work around older versions of libpq and of the server that didn't have > today's support for prepared statements. As testing recently revealed, > that code did not take into account the fact that libpq's support for > prepared statements also requires a third factor: an up-to-date version of > the client-server communications protocol. It gets complicated sometimes. > > The upshot of all this is that prepared statements broke when using a 7.3 > server with a 7.4 or newer libpq. Is that the case with you? > > If so, the current development version of libpqxx should fix the problem. > You can get the source from here: > > http://thaiopensource.org/~jtv/tmp/libpqxx-2.6.9-pre1.tar.gz > > The download is likely to be slow at the moment, due to the broken > undersea cables near Taiwan. OTOH your name is not uncommon on this side > of the break, and if that's where you are, the download may be unusually > fast. :-) > > > Jeroen > > > _______________________________________________ Libpqxx-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/libpqxx-general
