Received: from web13008.mail.yahoo.com (web13008.mail.yahoo.com [216.136.174.18]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7AL0WP87454 for ; Fri, 10 Aug 2001 17:00:32 -0400 (EDT) (envelope-from bmatzelle@yahoo.com) Message-ID: <20010810210023.10193.qmail@web13008.mail.yahoo.com> Received: from [146.145.232.35] by web13008.mail.yahoo.com; Fri, 10 Aug 2001 14:00:23 PDT Date: Fri, 10 Aug 2001 14:00:23 -0700 (PDT) From: "Brent R. Matzelle" Subject: RE: pg_connect vs. pg_pconnect To: "Pgsql-php \(E-mail\)" In-Reply-To: <59358A738F45D51186A30008C74CE2500A084B@slc-exc1.ctron.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200108/12 X-Sequence-Number: 507 --- "Hunter, Ray" wrote: > I took the advise of Brent Matzelle about 'not mixing > connections' and > switched to using pg_connect. This has solved all my > problems. I am > currently using php4.0.4pl1-9 and postgres 7.0.3 on Redhat > 7.1. > > I have no connections that are persisent and found that even > with all my > queries I can use the same connection. I am glad that it is working correctly. Also, I also have had problems with connections when trying to use pg_pconnect() while specifying a remote database host. This is true with several of the PHP *_pconnect() functions that I have tested. So my rule of thumb is use pg_pconnect() only if the database is located on the localhost, otherwise use pg_connect(). Brent __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/