X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5E71CD1B437; Wed, 3 Dec 2003 16:32:50 +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 54839-06; Wed, 3 Dec 2003 12:32:19 -0400 (AST) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id B6FA2D1D8D1; Wed, 3 Dec 2003 12:32:17 -0400 (AST) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) id <0HPB00301UWNJE@ndl1mr1-a-fixed.sancharnet.in>; Wed, 03 Dec 2003 21:57:21 +0530 (IST) Received: from sancharnet.in ([61.0.95.122]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HPB0045VV0VQ5@ndl1mr1-a-fixed.sancharnet.in>; Wed, 03 Dec 2003 21:57:20 +0530 (IST) Date: Wed, 03 Dec 2003 22:03:09 +0530 From: SaiHertz And Control Systems Subject: Auto commit Off how will it effect us ? To: pgsql-novice@postgresql.org, pgsql-php@postgresql.org Message-id: <3FCE1045.6010604@sancharnet.in> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/18 X-Sequence-Number: 8936 Dear all , Permit me to gain some of your most valuable knowledge ........... Our intrAnet server has the following spec 1. RH 9.0 2. Postgresql 7.3.4 3. PHP 4.3.3 4. GCC 3.2.2 Till date my front end language (PHP) use to simply pass the data to postgresql in case of insert and update we were not using 1 BEGIN COMMIT block in PHP till date thanks to auto-commit-ON in postgreql 2. ROLLBACK script in PHP script And now when our company has decided to switch over to postgresql 7.4 we have some doubt 1. Do we have to include BEGIN and COMMIT block around the insert process . (Because Postgresql 7.4 has auto-commit-OFF) in our PHP scripts 2. Not only this do we also have to port the pgSQL functions which use to do inserts into a third table such that data gets committed on function execution Please provide us any kinda information so that we can happily switch to postgressql 7.4 Regards, V Kashyap