Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8BECB475828 for ; Thu, 8 Aug 2002 15:46:39 -0400 (EDT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by postgresql.org (Postfix) with ESMTP id D8E0F47546C for ; Thu, 8 Aug 2002 15:46:38 -0400 (EDT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.4/8.12.4) with ESMTP id g78JkDOt025003; Thu, 8 Aug 2002 13:46:13 -0600 (MDT) Date: Thu, 8 Aug 2002 13:31:02 -0600 (MDT) From: "scott.marlowe" To: Cc: Subject: Re: off topic rollback In-Reply-To: <3D3EEC5F0004A36D@riosf05.globoi.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-MailBodyFilter: Message body has not been filtered X-MailScanner: Found to be clean X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/31 X-Sequence-Number: 1376 On Thu, 8 Aug 2002 angelo.rigo@globo.com wrote: > sorry for this off topic > > but someone ask me: if i do a invalid query in the middle of a transaction > i need to do a rollback . Basically, in PHP, just about any error will cause the current transaction to fail and rollback automatically and completely. You don't have to clean up the mess, as it's already cleaned up for you. Then you can just try running the transaction again and see if it goes through.