Christophe wrote:
>
> On Jul 31, 2008, at 11:49 AM, Alvaro Herrera wrote:
>> Why does it matter?
>
> I'm attempting to "clean out" a connection that is in an unknown state
> (along the lines of what pgpool does when reusing an open connection).
> Of course, I could just fire an ABORT down, but it seems nicer to avoid
> doing so if no transaction block is open.
Maybe DISCARD ALL does what you want?
http://www.postgresql.org/docs/8.3/static/sql-discard.html
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.