Automatic transactions in psql - Mailing list pgsql-patches

From Greg Sabino Mullane
Subject Automatic transactions in psql
Date
Msg-id E16YZ9U-0001vx-00@granger.mail.mindspring.net
Whole thread Raw
Responses Re: Automatic transactions in psql  (Peter Eisentraut <peter_e@gmx.net>)
Re: Automatic transactions in psql  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Re: Automatic transactions in psql  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
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@turnstep.com
PGP Key: 0x14964AC8 200202061602

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iQA/AwUBPGGZ37ybkGcUlkrIEQJhJQCgr2TEKcvPakEIC8Exn09pInLLOywAoL4I
uGv3TL6hUm/O1oSPrDVdmdc4
=rmRt
-----END PGP SIGNATURE-----


Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: contrib/pg_filedump - PostgreSQL File Dump Utility
Next
From: Patrick Macdonald
Date:
Subject: Re: contrib/pg_filedump - PostgreSQL File Dump Utility