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.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to