X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D2AD49DC9D9 for ; Sun, 26 Feb 2006 01:33:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38252-07 for ; Sun, 26 Feb 2006 01:33:07 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.202]) by postgresql.org (Postfix) with ESMTP id 130A89DC884 for ; Sun, 26 Feb 2006 01:33:05 -0400 (AST) Received: by zproxy.gmail.com with SMTP id z3so640554nzf for ; Sat, 25 Feb 2006 21:33:05 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=P2bAGQd1ZldCSAWAQwasdA1LMpROeuHv7k9XH8kSJEoYq1FT8hqVedObbnn1bL0//tUJiIqEzMTKsOqN8VUXrwPnrBYvNHSNWrwCNHIC3zID+cimZwaj5UpOVx6jcYWQEUCP5PpNSUxKrvZoxriF/+wUsGDEBS6cAeqbPK+IKyM= Received: by 10.36.227.73 with SMTP id z73mr180072nzg; Sat, 25 Feb 2006 21:33:05 -0800 (PST) Received: by 10.36.23.18 with HTTP; Sat, 25 Feb 2006 21:33:05 -0800 (PST) Message-ID: <3c1395330602252133u3af0fb27pdc64af7f3e4df4b3@mail.gmail.com> Date: Sun, 26 Feb 2006 16:33:05 +1100 From: "chris smith" To: "enediel gonzalez" Subject: Re: postgresql 7.3 php transaction problem Cc: pgsql-php@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20060226023451.D83171B8089@mx1.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.107 required=5 tests=[AWL=0.107] X-Spam-Score: 0.107 X-Spam-Level: X-Archive-Number: 200602/28 X-Sequence-Number: 3444 > launching the script from the php page fails, but taking the same script = and > using phppgadmin, the same script sucess. Then they're probably not the same. Enable logging on your postgresql server and see the exact queries that are being run when you use the php script. > Another question about transactions in postgresql > ?Is it possible inside the transaction to see the changes ocurred into th= e > database ,resulting of the previous statements executed on the same > transaction? Any statements executed INSIDE a transaction are visible. To another outside transaction, nothing is visible.