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 6BBF1D1B561 for ; Sun, 7 Dec 2003 08:54:31 +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 34843-05 for ; Sun, 7 Dec 2003 04:54:01 -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 47703D1B49E for ; Sun, 7 Dec 2003 04:53:59 -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 <0HPI00H01OAUTB@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Sun, 07 Dec 2003 14:23:59 +0530 (IST) Received: from proxyplus.universe ([61.0.95.116]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HPI00MFBOPSGY@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Sun, 07 Dec 2003 14:23:59 +0530 (IST) Received: from sancharnet.in [192.50.200.20] by Proxy+; Sun, 07 Dec 2003 14:24:18 +0530 Date: Sun, 07 Dec 2003 14:24:18 +0530 From: Sai Hertz And Control Systems Subject: Auto commit Off how will it effect us ? To: pgsql-admin@postgresql.org Message-id: <3FD2EABA.1010400@sancharnet.in> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii 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/72 X-Sequence-Number: 11580 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