Re: Default Transaction Mode

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Terry Hampton <thampton(at)limacorp(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Default Transaction Mode
Date: 2004-01-10 01:08:32
Message-ID: m365fkwqy7.fsf@conexa.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Terry Hampton <thampton(at)limacorp(dot)com> writes:

> Is it possible to configure Postgres,
> or to start PG daemons so that it
> operates in a transaction mode by default ?
>
> We do a lot of work at the PG prompt, and I'd
> like to have one additional "safety net" - to manual
> commit all SQL's. Sure - I can "begin work" etc.
> but I'd like that to be automatic.

If you are working with psql type set autocommit to false if using
version 7.3 or \unset AUTOCOMMIT for version 7.4. You can put those
commands in your .psqlrc file and psql will read it each time it's
invoked. See psql(1) for details.

Regards,
Manuel.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Likit Younboon 2004-01-10 12:29:08 pg_dump problem
Previous Message William Yu 2004-01-10 00:48:08 Re: Solaris 9 + 7.4: error in initdb.