pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDefault Transaction Mode
2+ messages / 2 participants
[nested] [flat]
* Default Transaction Mode
@ 2004-01-09 21:31 Terry Hampton <thampton@limacorp.com>
2004-01-10 01:08 ` Re: Default Transaction Mode Manuel Sugawara <masm@fciencias.unam.mx>
0 siblings, 1 reply; 2+ messages in thread
From: Terry Hampton @ 2004-01-09 21:31 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Default Transaction Mode
2004-01-09 21:31 Default Transaction Mode Terry Hampton <thampton@limacorp.com>
@ 2004-01-10 01:08 ` Manuel Sugawara <masm@fciencias.unam.mx>
0 siblings, 0 replies; 2+ messages in thread
From: Manuel Sugawara @ 2004-01-10 01:08 UTC (permalink / raw)
To: Terry Hampton <thampton@limacorp.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-01-10 01:08 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-09 21:31 Default Transaction Mode Terry Hampton <thampton@limacorp.com>
2004-01-10 01:08 ` Manuel Sugawara <masm@fciencias.unam.mx>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox