Re: Automatic transactions in psql - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: Automatic transactions in psql
Date
Msg-id GNELIHDDFBOCMGBFGEFOEEEMCBAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Automatic transactions in psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-patches
> 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.

Sweeeet.  I've gone mad trying to get people with access to our production
databases to do _everything_ within a transaction when they start fiddling
around!

Chris


pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Automatic transactions in psql
Next
From: Bruce Momjian
Date:
Subject: Re: contrib/pg_filedump - PostgreSQL File Dump Utility