From joaocarvalho127@yahoo.com.br Fri Sep  2 17:21:47 2005
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 326AFD89CD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  2 Sep 2005 14:21:47 -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 80429-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  2 Sep 2005 17:21:43 +0000 (GMT)
Received: from web50606.mail.yahoo.com (web50606.mail.yahoo.com
	[206.190.38.93])
	by svr1.postgresql.org (Postfix) with SMTP id 4DD79D89BB
	for <pgsql-sql@postgresql.org>; Fri,  2 Sep 2005 14:21:42 -0300 (ADT)
Received: (qmail 21646 invoked by uid 60001); 2 Sep 2005 17:21:42 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=Ry0mUPTEToVNDHHaNvJn+KdD7Xs0xp+Jbzl5eg4PBL14mv7yueqoTV1Y0px31TX18N40ndNbMxZSis4GeJ93f5sX4czqyhbB1gxc9Rr9tEgjYmwhFsYjCjZVkGh2Vm2N0nVvXY7cZQ9FHH0tODydOhlN3FbIwVrFwgKKX2vXIHk=
	;
Message-ID: <20050902172141.21644.qmail@web50606.mail.yahoo.com>
Received: from [83.240.144.78] by web50606.mail.yahoo.com via HTTP;
	Fri, 02 Sep 2005 14:21:41 ART
Date: Fri, 2 Sep 2005 14:21:41 -0300 (ART)
From: =?iso-8859-1?q?Jo=FFffffffffffe3o=20Carvalho?=
	<joaocarvalho127@yahoo.com.br>
Subject: Turn off auto-commit
To: PG-SQL lista de mail <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-376246755-1125681701=:21079"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.077 required=5 tests=[AWL=-0.077,
	DNS_FROM_RFC_ABUSE=0.374, FROM_ENDS_IN_NUMS=0.516, HTML_30_40=0.056,
	HTML_MESSAGE=0.001, UPPERCASE_25_50=0.207]
X-Spam-Level: *
X-Archive-Number: 200509/15
X-Sequence-Number: 22562

--0-376246755-1125681701=:21079
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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!
--0-376246755-1125681701=:21079
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>
<DIV>Im working in postgresql 8.0 in windows XP. How can I turn off auto-commit.</DIV>
<DIV>I already tried a few things but it didn't worked.<BR><BR>Regards</DIV>
<DIV>João Carvalho</DIV></DIV><p>
		<hr size=1> 
Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. <a href="http://us.rd.yahoo.com/mail/br/taglines/*http://br.yahoo.com/messenger/promocao/">Participe!</a>
--0-376246755-1125681701=:21079--



From ojacobson@osl.com Fri Sep  2 17:27:15 2005
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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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" <ojacobson@osl.com>
To: =?iso-8859-1?Q?Jo=FFffffffffffe3o_Carvalho?=
	<joaocarvalho127@yahoo.com.br>,
	"PG-SQL lista de mail" <pgsql-sql@postgresql.org>
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! =
<http://us.rd.yahoo.com/mail/br/taglines/*http://br.yahoo.com/messenger/p=
romocao/>=20


------_=_NextPart_001_01C5AFE3.8B476F59
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">


<META content=3D"MSHTML 6.00.2800.1515" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D981202517-02092005><FONT face=3DArial color=3D#0000ff =
size=3D2>You=20
can turn off autocommit by explicitly starting a transaction (eg. with =
BEGIN; in=20
psql or by turning off autocommit through ODBC).&nbsp; Statements inside =
the=20
transaction will not have their own, automatically-commited=20
transactions.</FONT></SPAN></DIV>
<DIV><SPAN class=3D981202517-02092005></SPAN><SPAN=20
class=3D981202517-02092005></SPAN><SPAN class=3D981202517-02092005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D981202517-02092005><FONT face=3DArial color=3D#0000ff =

size=3D2>HTH,</FONT></SPAN></DIV>
<DIV><SPAN class=3D981202517-02092005><FONT face=3DArial color=3D#0000ff =

size=3D2>Owen</FONT></SPAN></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid">
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B>=20
  pgsql-sql-owner@postgresql.org =
[mailto:pgsql-sql-owner@postgresql.org]<B>On=20
  Behalf Of </B>Jo=FFffffffffffe3o Carvalho<BR><B>Sent:</B> Friday, =
September 02,=20
  2005 10:22 AM<BR><B>To:</B> PG-SQL lista de mail<BR><B>Subject:</B> =
[SQL] Turn=20
  off auto-commit<BR><BR></FONT></DIV>
  <DIV>
  <DIV>Im working in postgresql 8.0 in windows XP. How can I turn off=20
  auto-commit.</DIV>
  <DIV>I already tried a few things but it didn't =
worked.<BR><BR>Regards</DIV>
  <DIV>Jo=E3o Carvalho</DIV></DIV>
  <P>
  <HR SIZE=3D1>
  Yahoo! Messenger com voz: PROMO=C7=C3O VOC=CA PODE LEVAR UMA VIAGEM NA =
CONVERSA. <A=20
  =
href=3D"http://us.rd.yahoo.com/mail/br/taglines/*http://br.yahoo.com/mess=
enger/promocao/">Participe!</A></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C5AFE3.8B476F59--