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