Re: Automatic transactions in psql

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Automatic transactions in psql
Date: 2002-02-07 00:51:14
Message-ID: GNELIHDDFBOCMGBFGEFOEEEMCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rich Shepard 2002-02-07 01:13:44 Re: [HACKERS] PostgreSQL v7.2 Final Release
Previous Message Lamar Owen 2002-02-07 00:48:13 Re: [HACKERS] PostgreSQL v7.2 Final Release

Browse pgsql-patches by date

  From Date Subject
Next Message Barry Lind 2002-02-07 02:20:08 Re: contrib/pg_filedump - PostgreSQL File Dump Utility
Previous Message Peter Eisentraut 2002-02-07 00:17:25 Re: Automatic transactions in psql