X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0CB7BD1B465; Wed, 10 Dec 2003 02:16:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 62908-10; Tue, 9 Dec 2003 22:16:25 -0400 (AST) Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241]) by svr1.postgresql.org (Postfix) with ESMTP id 7564BD1B439; Tue, 9 Dec 2003 22:16:21 -0400 (AST) Received: from [192.168.0.13] ([68.105.165.106]) by lakemtao04.cox.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20031210021624.LDCS19895.lakemtao04.cox.net@[192.168.0.13]>; Tue, 9 Dec 2003 21:16:24 -0500 From: Robert Treat To: Sai Hertz And Control Systems Subject: Re: Auto commit Off how will it effect us ? Date: Tue, 9 Dec 2003 21:16:23 -0500 User-Agent: KMail/1.5 Cc: pgsql-admin@postgresql.org, pgsql-php@postgresql.org References: <3FD2EABA.1010400@sancharnet.in> <1070918150.16407.4406.camel@camel> <3FD58B38.1030300@sancharnet.in> In-Reply-To: <3FD58B38.1030300@sancharnet.in> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200312092116.23628.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/127 X-Sequence-Number: 11635 On Tuesday 09 December 2003 03:43, Sai Hertz And Control Systems wrote: > Dear Robert Treat , > > First of all accept gratitude for answering the question > > >phppgadmin=# set autocommit = off; > >ERROR: SET AUTOCOMMIT TO OFF is no longer supported > >phppgadmin=# > > Now does this mean that their must exist some PHP.INI file option that > will make client side auto commit on > But as such till now PHP version 4.3.4 their exist no such option till now > and defiantly we are testing our application for PostgreSQL 7.4 . > We would never like to miss the options provided by 7.4 > Autocommit On is the default, you don't need any special options for it. If you wanted autocommit off you would need a special option for that (which php doesnt seem to have). Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL