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 775ECD1B1CF for ; Fri, 30 Jul 2004 13:31:01 -0300 (ADT) 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 11100-10 for ; Fri, 30 Jul 2004 16:30:56 +0000 (GMT) Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [204.127.202.55]) by svr1.postgresql.org (Postfix) with ESMTP id 6D217D1B1E0 for ; Fri, 30 Jul 2004 13:30:54 -0300 (ADT) Received: from sys2 (c-24-5-249-240.client.comcast.net[24.5.249.240]) by comcast.net (sccrmhc11) with SMTP id <2004073016305301100t1cuje>; Fri, 30 Jul 2004 16:30:53 +0000 Reply-To: From: "bruce" To: "'reiner peterke'" , "'Rod K'" Cc: Subject: Re: [0.0] Re: [0.2] getting transactions to work Date: Fri, 30 Jul 2004 09:35:14 -0700 Message-ID: <019201c47653$31ce8e00$0301a8c0@Mesa.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 9.0, Build 9.0.2910.0 In-Reply-To: <3C941D97-E245-11D8-8EE0-000A95984CA6@drizzle.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/57 X-Sequence-Number: 2882 the idea behind persistent connections is to simply allow you to open a connection, that is persistent, ie, it's there for other db functions to use and that the app doesn't go through the process of opening up a new connection. with a persistent connection, the app essentially looks to see if an existing connection has already been open that's available for use. -bruce -----Original Message----- From: reiner peterke [mailto:zedaardv@drizzle.com] Sent: Friday, July 30, 2004 9:27 AM To: Rod K Cc: pgsql-php@postgresql.org; bedouglas@earthlink.net Subject: Re: [0.0] Re: [0.2] [PHP] getting transactions to work ok, thanks On 30 jul 2004, at 18.13, Rod K wrote: > No, persistent connections will not work either. > > reiner peterke wrote: > >> well i've read about this thing called persistent connection, >> i think it is supposed to exist in mysql also. the idea sound like >> what i want. i've tried it but i didn't get any different results. >> but then i'm not convinced i did it right either. >> >> r >> >> On 30 jul 2004, at 17.21, bruce wrote: >> >>> if psgres works as mysql.... you should be able to do it... >>> >>> but the issue appears to be that the connection you establish with >>> the db in >>> one page, is not available once you shut the page down. >>> >>> within mysql, there appears to be a mysqli group of functions that >>> are setup >>> to accommodate transactions across multiple pages... i would >>> imagine/hope >>> that the same sort of functionality is available for posgres.... >>> >>> i'm getting close to needing the same functionality with mysql, and >>> i'm >>> betting/hoping like hell that what i've just described is how >>> mysql/php >>> works... >>> >>> -bruce >>> >>> >>> -----Original Message----- >>> From: pgsql-php-owner@postgresql.org >>> [mailto:pgsql-php-owner@postgresql.org]On Behalf Of reiner peterke >>> Sent: Friday, July 30, 2004 8:04 AM >>> To: Rod K >>> Cc: pgsql-php@postgresql.org >>> Subject: Re: [0.2] [PHP] getting transactions to work >>> >>> >>> this is meant in all honesty, >>> >>> then whats the point?! >>> >>> ok, let me put it this way. is there no way to implement pages using >>> transactions? >>> otherwise it seems to kind of defeat the purpose of them. >>> >>> r >>> On 30 jul 2004, at 16.57, Rod K wrote: >>> >>>> You are correct. You cannot have a transaction span multiple >>>> pages/scripts. >>>> >>>> reiner peterke wrote: >>>> >>>>> there seems to be very little info around on actually using >>>>> transactions with postgres. i've tried to create a page that will >>>>> take input from a form and insert it into my database. it works >>>>> if i >>>>> just do it without transactions but when i try to use with the >>>>> begin >>>>> and commit sections of code, it doesn't update the data base. i'm >>>>> guessing it is doing a rollback when my page loads itself again. >>>>> can >>>>> anyone help me out here ? >>>>> >>>>> thanks >>>>> >>>>> r >>>>> >>>>> code below >>>>> >>>>> >>>>> >>>>> those eyes >>>>> >>>>> >>>>> >>>> $conn = pg_connect("dbname=entish user=postgres"); >>>>> if(!$conn) >>>>> { >>>>> print "not for the chocolate"; >>>>> exit; >>>>> } >>>>> if ($_POST[submit]) { >>>>> >>>>> $begin = pg_query("begin"); >>>>> $isql = "insert into diety(diety,culture,gender) >>>>> values >>>>> ('$_POST[diety]','$_POST[culture]','$_POST[gender]')"; >>>>> printf("-- %s --\n",$isql); >>>>> $results = pg_query($isql); >>>>> ?> >>>>>
>>>>> >>>>> >>>>>
>>>>> >>>> } >>>>> else if(!$_POST[action]) { >>>>> ?> >>>>>
>>>>> Diety:
>>>>> Culture:
>>>>> Gender:
>>>>> >>>>>
>>>>> >>>> } >>>>> else { >>>>> if($_POST[action] == 'commit') { >>>>> echo "let me see"; >>>>> $act = pg_query("commit"); >>>>> } >>>>> else { >>>>> $act = pg_query("rollback"); >>>>> } >>>>> } //end if $_POST[submit] >>>>> ?> >>>>> >>>>> >>>>> ---------------------------(end of >>>>> broadcast)--------------------------- >>>>> TIP 8: explain analyze is your friend >>>> >>>> >>>> >>> >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 7: don't forget to increase your free space map settings >>> >>> >>> ---------------------------(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 >>> >> > > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >