Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 890B59FBD88 for ; Thu, 3 May 2007 16:30:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 06777-05 for ; Thu, 3 May 2007 16:29:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web36805.mail.mud.yahoo.com (web36805.mail.mud.yahoo.com [209.191.85.56]) by postgresql.org (Postfix) with SMTP id 924649FB5FB for ; Thu, 3 May 2007 16:29:57 -0300 (ADT) Received: (qmail 44339 invoked by uid 60001); 3 May 2007 19:29:56 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=fRB8Vq0XEZRW2Nsb+IHvwswl34m1xYy/fPFiAn5KzoGgFwWzyrCWnd+7y0LxzJkbADJj/r6Fl6twNEbLmw5VkTSUIZiH3t3C7CPKuxvwtXcNNvjqiEMLrtcF/EmNee2p0Sm1u3GtfTgvQS7bADTJy1JsQDtDlZ7HQ+sxRj84Be8=; X-YMail-OSG: 1u_vxjgVM1lzRl6OcA9JGUoy6xRRPwANzXvzbdcyndy923VQRBa9zyufKpuxDJ8Spb1.nVWrzUwZQ1dCouU4r49CV2wG4VfkalnTV0RwFt_T3TOiTQU- Received: from [208.252.171.18] by web36805.mail.mud.yahoo.com via HTTP; Thu, 03 May 2007 12:29:56 PDT Date: Thu, 3 May 2007 12:29:56 -0700 (PDT) From: Jeff Lanzarotta Reply-To: delux256-postgresql@yahoo.com Subject: Re: php-pgsql no longer works under 8.2 To: Chris Cc: PostgreSQL PHP List In-Reply-To: <753737.9700.qm@web36801.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <355185.43719.qm@web36805.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.129 tagged_above=0 required=5 tests=AWL=0.373, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: * X-Archive-Number: 200705/2 X-Sequence-Number: 3791 If looks like others have had this issue as well, but they were running under Red Hat. Read this article: http://people.planetpostgresql.org/devrim/index.php?/archives/66-Compat-libs-RPM-for-FC5,6-and-RHEL4.html So someone made several compat libs but for Red Hat only... Are there any compat libs out there for SuSE? --- Jeff Lanzarotta wrote: > OK, I finally got back to looking at this... > > After looking into phpinfo() it looks like postgreSQL is not loaded > anymore which is what I figured since I un-installed all the > postgreSQL > related rpms and then compiled and installed from source. > > I really do not want to have to download the php source and compile > it > with pg support if at all possible. There are way to many rpms > related > to php already installed on this system. > > After further investigation, it have found an rpm, > php5-pgsql-5.1.2-29.25.3.i586.rpm, that is for the version of php > that > I have as well as pg 8.2. I am not really sure if this will work, but > I > am trying to install this php5 rpm. When I do, it says that it needs > 'libpg.so.4'. > > Is there a way to generate libpg.so.4 from the postgreSQL source? Am > I > going in the wrong direction with this little project? > > Thanks. > > --- Chris wrote: > > > Jeff Lanzarotta wrote: > > > Hello, > > > > > > I installed PostgreSQL 8.2 from source on openSUSE 10.1 and now > > various > > > php related application no longer work. For example phpMyFAQ... > > > > > > Is there a version of php-pgsql for 8.2? > > > > Not sure if you need to, but did you recompile php to pick up the > new > > > > postgres version? > > > > Is postgres still loaded in php? Check with a phpinfo(); page. > > > > -- > > Postgresql & php tutorials > > http://www.designmagick.com/ > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >