Re: Reset?

On Thu, Mar 14, 2002 at 10:04:40AM -0800, Joep deVocht wrote:
> 
> I know it's possible to "reset" the connection or something similar,
> so that after an invalid query, new queries can be sent 
> without problems. I know this because "psql" is able to.
> Problem is that I can't seem to figure out how they do it.

There is a function in libpq (which libpq++ is built on top of), called
PQreset().  Unless I'm mistaken, libpq++ doesn't currently expose this 
in its API (the alternative libpqxx currently makes it a private method, 
see my home page below).

There's a brief description of PQreset() at:

http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/libpq-connect.html

I have no idea whether resetting the connection will solve your problem
though.  Going by the docs, the function is there mainly to let you
recover broken connections.


Jeroen

http://members.ams.chello.nl/j.vermeulen31/