Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fADLoum52579 for ; Tue, 13 Nov 2001 16:50:57 -0500 (EST) (envelope-from martin@bugs.unl.edu.ar) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 68D9B2AB3E for ; Tue, 13 Nov 2001 18:49:45 -0300 (GMT) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 350272AB48; Tue, 13 Nov 2001 18:49:43 -0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: pgsql-php@postgresql.org Subject: Re: db connections in session variables Date: Tue, 13 Nov 2001 18:49:41 -0300 X-Mailer: KMail [version 1.3] References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20011113214943.350272AB48@bugs.unl.edu.ar> X-Virus-Scanned: by AMaViS snapshot-20011106 X-Archive-Number: 200111/2 X-Sequence-Number: 649 On Mar 13 Nov 2001 17:36, you wrote: > I was wondering if it were possible to store a database connection in a > session variable. No! Because the persistent connection gets opened with one child, and when you go for the next page you have very high probabilities (unless you have a very poor http configuration) of caching a new child, and not the old one. The problem comes here, just because the pconnect was done against the old child, and the new one doesn't know a thing about the pconnect you did before, so you'll allways (or almost always) an error of "wrong connection id". Hope I was clear. > I have tried these 2 methods: > > $conn = pg_pconnect("server", "5432", "db"); > session_start(); > session_register('conn'); > > $conn = pg_pconnect("server", "5432", "db"); > session_id($conn); > session_start(); > > both of them register a session with the value of "Resource id #1" but > don't act as a db connection. I am just trying to clean up some code so I > don't have to do a new database connection on every page that I create. > > Then if you are able to do this, where would you close the connection? > > I guess in ASP, it is possible to store db connections in a session > variable. I have never done it there either but someone told me that you > can. > > Tim. > > Timothy P. Maguire > Web Developer II > Harte-Hanks > 978 436 3325 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------