Skip site navigation (1) Skip section navigation (2)

Re: PL/pgSQL equivalent to PQtransactionStatus?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Christophe <xof(at)thebuild(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: PL/pgSQL equivalent to PQtransactionStatus?
Date: 2008-07-31 19:38:08
Message-ID: (view raw or whole thread)
Lists: pgsql-general
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?

Alvaro Herrera                      
The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-general by date

Next:From: pglistsDate: 2008-07-31 19:40:17
Subject: Re: How do I set up automatic backups?
Previous:From: Mike GouldDate: 2008-07-31 19:28:14
Subject: Using PostGres general distribution

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group