Обсуждение: Default Transaction Mode

Поиск
Список
Период
Сортировка

Default Transaction Mode

От
Terry Hampton
Дата:
    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.

                Thanks,
                Terry




--
Terry L. Hampton
Program Manager
LimaCorp, LLC.  www.limacorp.com
513.587.1874

Re: Default Transaction Mode

От
Manuel Sugawara
Дата:
Terry Hampton <thampton@limacorp.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.