hi,Jeroen T. Vermeulen >On Mon, January 23, 2006 10:57, [EMAIL PROTECTED] wrote: > >> when i use copy command(tablewriter in pqxx),after performing serveral >> copys, my program used to get SIGPIPE signal. > >Did you call the tablewriter's complete() function? One explanation that yes,I have used complete() after doing the inserts.I check the source and find that both of complete() and ~tablewrite call the function writer_close().
so i dismiss complete() first, it has the same effect then i erase the writer_close() in ~tablewriter(). Now i get an info: Closing nontransaction with p�ransact '?ow' still open after that no data can be inserted into db again. so i wonder whether 2.5.5 can work normal or not, but when linking 2.5.5 i got a message 'undefined reference to pqxx::tablewriter::Escape(...)' but i only find pqxx::internal::Esacpe in the source code and pqxx::internal::Escape call in the code so are there any problem? >springs to mind is that the COPY command may not be properly terminated >for some reason. If that happens, I could imagine libpq and the backend >finding that the states of their protocol implementation are out of sync, >and one of them closing the socket. That would give you a SIGPIPE. > > >Jeroen > > >.
_______________________________________________ Libpqxx-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/libpqxx-general
