X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 783288B9F06 for ; Tue, 8 Feb 2005 19:19:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46480-06 for ; Tue, 8 Feb 2005 19:19:43 +0000 (GMT) Received: from mail.stefansturm.de (p15166448.pureserver.info [212.227.21.35]) by svr1.postgresql.org (Postfix) with ESMTP id 8343F8B9F57 for ; Tue, 8 Feb 2005 19:19:42 +0000 (GMT) Received: (qmail 4077 invoked by uid 1008); 8 Feb 2005 19:19:40 -0000 Received: from unknown (HELO ?127.0.0.1?) (info@stefansturm.de@217.228.45.86) by 0 with SMTP; 8 Feb 2005 19:19:40 -0000 Message-ID: <420910DB.4010508@anrath.info> Date: Tue, 08 Feb 2005 20:19:55 +0100 From: Stefan Sturm User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: Transactions and Savepoints References: <20050208143339.31402.qmail@web53509.mail.yahoo.com> In-Reply-To: <20050208143339.31402.qmail@web53509.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.531 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, INFO_TLD X-Spam-Level: X-Archive-Number: 200502/13 X-Sequence-Number: 2987 Oh Sorry, my fault. PostgreSQL 8.0 php 5.0.3 Hope this helps. Thanks, Stefan Sturm Tommy Phillips schrieb: > Stefan- > > We will need more information: > > What DBMS are you using, what version and what version > of PHP, for starters. > > --- Stefan Sturm wrote: > > >>Hello, >> >>I have a problem with savepoints. >> >>I have a function which does some DB changed. This >>changes have to be in >> a single Transaction. This function is now called >>in two different >>ways. Once within a transaction and once not in a >>transaction. But how >>can i check if I am within a transaction, so I can >>start a new >>transaction or set a savepoint. >> >>Is there a way to check this? >> >>Thanks and Greetings, >> >>Stefan Sturm >> >> >>---------------------------(end of >>broadcast)--------------------------- >>TIP 5: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faq >> > > > > ===== > --------------------------- > Tommy Phillips > 303-427-8456 (Home) > 303-981-4310 (Cell) > tommyp@acm.org > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > > >