Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id DF265650136
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat, 19 Jul 2008 08:06:03 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 60710-06 for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat, 19 Jul 2008 08:05:55 -0300 (ADT)
X-Greylist: delayed 00:06:56.271758 by SQLgrey-1.7.6
Received: from fk-out-0910.google.com (fk-out-0910.google.com
 [209.85.128.186])
	by postgresql.org (Postfix) with ESMTP id 78A3C650129
	for <pgsql-admin@postgresql.org>; Sat, 19 Jul 2008 08:05:59 -0300 (ADT)
Received: by fk-out-0910.google.com with SMTP id e30so532203fke.3
	for <pgsql-admin@postgresql.org>; Sat, 19 Jul 2008 04:05:57 -0700 (PDT)
Received: by 10.125.16.5 with SMTP id t5mr103339mki.50.1216465140621;
	Sat, 19 Jul 2008 03:59:00 -0700 (PDT)
Received: by 10.125.121.8 with HTTP; Sat, 19 Jul 2008 03:59:00 -0700 (PDT)
Message-ID: <ee5ed96b0807190359w5ed01c4am5c8ff3df98951a50@mail.gmail.com>
Date: Sat, 19 Jul 2008 16:29:00 +0530
From: Kartik <kartik@v2technocrats.com>
To: pgsql-admin@postgresql.org
Subject: Query
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_40970_5531257.1216465140613"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200807/169
X-Sequence-Number: 29779

------=_Part_40970_5531257.1216465140613
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

hello there,i am new to postgresql
i am using postgresql 8.3.3 and i am writing one whole transaction. i want
to know how to set auto commit off
because if any error occours i want the whole transaction to be rolled back.
when i tried alter database dbname set autocommit = off
then it gives me error saying autocommit not available
so can anyone suggest how to set autocommit as off so that i can rollback
the transaction..
thank you
waiting for your reply
regards
kartik

------=_Part_40970_5531257.1216465140613
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">hello there,<div>i am new to postgresql</div><div>i am using postgresql 8.3.3 and i am writing one whole transaction. i want to know how to set auto commit off</div><div>because if any error occours i want the whole transaction to be rolled back.</div>
<div>when i tried alter database dbname set autocommit = off</div><div>then it gives me error saying autocommit not available</div><div>so can anyone suggest how to set autocommit as off so that i can rollback the transaction..</div>
<div>thank you</div><div>waiting for your reply</div><div>regards&nbsp;</div><div>kartik</div></div>

------=_Part_40970_5531257.1216465140613--