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

Re: [PATCHES] Automatic transactions in psql

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: lockhart(at)fourpalms(dot)org
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>,Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] Automatic transactions in psql
Date: 2002-02-22 16:09:48
Message-ID: 200202221609.g1MG9mT12566@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Thomas Lockhart wrote:
> ...
> > > Secondly, it adds a "begin transaction" option that, when
> > > enabled, ensures that you are always inside a transaction
> > > while in psql, so you can always rollback. It does this
> > > by issuing a BEGIN at the appropriate times. This patch
> > > (if ever accepted) conflicts a bit with LO_RTANSACTION:
> > > psql now *does* have a way to know if it is in a
> > > transaction or not, so that part may need to get rewritten.
> 
> This part of the feature (corresponding to the Ingres "autocommit = off"
> feature) should be implemented in the backend rather than in psql. I've
> had a moderate interest in doing this but haven't gotten to it; if
> someone wants to pick it up I'm sure it would be well received...

Agreed.  I wondered whether we could use the psql status part of this
patch.  We currently cound parens and quotes, and show that in the psql
prompt.  Could we do that for transaction status?  Considering we
already track the parens/quotes, another level of status on the psql
display seems  a bit much, even if we could do it reliably.  Comments?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-02-22 16:12:56
Subject: Re: Automatic transactions in psql
Previous:From: Zeugswetter Andreas SB SDDate: 2002-02-22 16:06:33
Subject: Re: point in time recovery and moving datafiles online

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-02-22 16:12:56
Subject: Re: Automatic transactions in psql
Previous:From: Thomas LockhartDate: 2002-02-22 15:21:51
Subject: Re: [PATCHES] Automatic transactions in psql

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