> 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?
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
In response to
pgsql-general by date
|Next:||From: pglists||Date: 2008-07-31 19:40:17|
|Subject: Re: How do I set up automatic backups?|
|Previous:||From: Mike Gould||Date: 2008-07-31 19:28:14|
|Subject: Using PostGres general distribution |