X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B7F81D7CA5 for ; Fri, 2 Sep 2005 14:27:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52813-01 for ; Fri, 2 Sep 2005 17:27:12 +0000 (GMT) Received: from nelson.osl.com (216-21-133-120.ip.van.radiant.net [216.21.133.120]) by svr1.postgresql.org (Postfix) with ESMTP id 54941D7A64 for ; Fri, 2 Sep 2005 14:27:09 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5AFE3.8B476F59" Subject: Re: Turn off auto-commit X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Date: Fri, 2 Sep 2005 10:27:06 -0700 Message-ID: <144D12D7DD4EC04F99241498BB4EEDCC08AD20@nelson.osl.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] Turn off auto-commit Thread-Index: AcWv4zs/RwlCsf5HTl+4UzE5DCg6wAAABBFw From: "Owen Jacobson" To: =?iso-8859-1?Q?Jo=FFffffffffffe3o_Carvalho?= , "PG-SQL lista de mail" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.099 required=5 tests=[AWL=0.020, FORGED_RCVD_HELO=0.05, HTML_60_70=0.027, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/16 X-Sequence-Number: 22563 This is a multi-part message in MIME format. ------_=_NextPart_001_01C5AFE3.8B476F59 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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. =20 HTH, Owen -----Original Message----- From: pgsql-sql-owner@postgresql.org = [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Jo=FFffffffffffe3o = 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=E3o Carvalho _____ =20 Yahoo! Messenger com voz: PROMO=C7=C3O VOC=CA PODE LEVAR UMA VIAGEM NA = CONVERSA. Participe! = =20 ------_=_NextPart_001_01C5AFE3.8B476F59 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
You=20 can turn off autocommit by explicitly starting a transaction (eg. with = BEGIN; in=20 psql or by turning off autocommit through ODBC).  Statements inside = the=20 transaction will not have their own, automatically-commited=20 transactions.
 
HTH,
Owen
-----Original Message-----
From:=20 pgsql-sql-owner@postgresql.org = [mailto:pgsql-sql-owner@postgresql.org]On=20 Behalf Of Jo=FFffffffffffe3o Carvalho
Sent: Friday, = September 02,=20 2005 10:22 AM
To: PG-SQL lista de mail
Subject: = [SQL] Turn=20 off auto-commit

Im working in postgresql 8.0 in windows XP. How can I turn off=20 auto-commit.
I already tried a few things but it didn't = worked.

Regards
Jo=E3o Carvalho

Yahoo! Messenger com voz: PROMO=C7=C3O VOC=CA PODE LEVAR UMA VIAGEM NA = CONVERSA. Participe! ------_=_NextPart_001_01C5AFE3.8B476F59--