X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 03059D1B47E for ; Sat, 6 Dec 2003 01:29:05 +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 56778-10 for ; Fri, 5 Dec 2003 21:28:37 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 75907D1B441 for ; Fri, 5 Dec 2003 21:28:34 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id hB61SRbI086988 for ; Sat, 6 Dec 2003 01:28:27 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id hB614Cot084511 for pgsql-php@postgresql.org; Sat, 6 Dec 2003 01:04:12 GMT From: CoL X-Newsgroups: comp.databases.postgresql.interfaces.php Subject: Re: Auto commit Off how will it effect us ? Date: Sat, 06 Dec 2003 02:07:46 +0100 Organization: Hub.Org Networking Services Lines: 32 Message-ID: References: <3FCE1045.6010604@sancharnet.in> Reply-To: col@mportal.hu Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031129 X-Accept-Language: en-us, en In-Reply-To: <3FCE1045.6010604@sancharnet.in> To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/12 X-Sequence-Number: 2458 hi, SaiHertz And Control Systems wrote, On 12/3/2003 5:33 PM: > 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 in pg7.4 AUTOCOMMIT = 'on' try: SET AUTOCOMMIT = off; you will get: ERROR: SET AUTOCOMMIT TO OFF is no longer supported C.