Re: Automatic transactions in psql

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Automatic transactions in psql
Date: 2002-02-22 04:01:42
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-patches

Thread added.

This has been saved for the 7.3 release:


Greg Sabino Mullane wrote:
> Hash: SHA1
> The attached patch actually does two related things. First,
> it keeps track of whether or not you are in a trnasaction
> and modifies the prompt slightly when you are by putting
> an asterick at the very front of it.
> 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.
> Greg Sabino Mullane greg(at)turnstep(dot)com
> PGP Key: 0x14964AC8 200202061602
> Comment:
> iQA/AwUBPGGZ37ybkGcUlkrIEQJhJQCgr2TEKcvPakEIC8Exn09pInLLOywAoL4I
> uGv3TL6hUm/O1oSPrDVdmdc4
> =rmRt

[ Attachment, skipping... ]

> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

Bruce Momjian |
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


Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-02-22 04:07:10 Re: elog() proposals
Previous Message Bruce Momjian 2002-02-22 03:55:55 Re: Array slice subscripts (was Re: [SQL] plpgsql function

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-02-22 04:02:08 Re: [PATCHES] JDBC Connection startup cleaned up
Previous Message Bruce Momjian 2002-02-22 03:59:45 Re: contrib/DBMirror (Replication).