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 A137FD1B33D for ; Fri, 30 Jul 2004 13:13:53 -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 04223-05 for ; Fri, 30 Jul 2004 16:13:47 +0000 (GMT) Received: from gold.idxwebpro.com (host-64-65-211-224.buf.choiceone.net [64.65.211.224]) by svr1.postgresql.org (Postfix) with SMTP id 0E598D1B2D9 for ; Fri, 30 Jul 2004 13:13:43 -0300 (ADT) Received: (qmail 80164 invoked by uid 1013); 30 Jul 2004 16:13:16 -0000 Received: from rod@23net.net by gold.idxwebpro.com by uid 1012 with qmail-scanner-1.20st (clamuko: 0.65. spamassassin: 2.63. Clear:RC:0(64.65.211.226):SA:0(0.2/3.8):. Processed in 1.702471 secs); 30 Jul 2004 16:13:16 -0000 Received: from host-64-65-211-226.buf.choiceone.net (HELO ?192.168.1.5?) (rod@gold.idxwebpro.com@64.65.211.226) by gold.idxwebpro.com with SMTP; 30 Jul 2004 16:13:14 -0000 Message-ID: <410A73AF.1010909@23net.net> Date: Fri, 30 Jul 2004 12:13:35 -0400 From: Rod K User-Agent: Mozilla Thunderbird 0.4 (Windows/20040707) X-Accept-Language: en MIME-Version: 1.0 To: reiner peterke Cc: bedouglas@earthlink.net, pgsql-php@postgresql.org Subject: Re: [0.0] Re: [0.2] getting transactions to work References: <018301c47648$db231990$0301a8c0@Mesa.com> In-Reply-To: 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.0 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200407/55 X-Sequence-Number: 2880 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 >> >