From: Owen Jacobson <ojacobson@osl.com>
To: Joÿffffffffffe3o Carvalho <joaocarvalho127@yahoo.com.br>
To: PG-SQL lista de mail <pgsql-sql@postgresql.org>
Subject: Re: Turn off auto-commit
Date: Fri, 2 Sep 2005 10:27:06 -0700
Message-ID: <144D12D7DD4EC04F99241498BB4EEDCC08AD20@nelson.osl.com> (raw)
You can turn off autocommit by explicitly starting a transaction (eg. with BEGIN; in psql or by turning off autocommit through ODBC). Statements inside the transaction will not have their own, automatically-commited transactions.
HTH,
Owen
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Joÿffffffffffe3o Carvalho
Sent: Friday, September 02, 2005 10:22 AM
To: PG-SQL lista de mail
Subject: [SQL] Turn off auto-commit
Im working in postgresql 8.0 in windows XP. How can I turn off auto-commit.
I already tried a few things but it didn't worked.
Regards
João Carvalho
_____
Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe! <http://us.rd.yahoo.com/mail/br/taglines/*http://br.yahoo.com/messenger/promocao/;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ojacobson@osl.com, joaocarvalho127@yahoo.com.br
Subject: Re: Turn off auto-commit
In-Reply-To: <144D12D7DD4EC04F99241498BB4EEDCC08AD20@nelson.osl.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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