From jim@luckydigital.com Fri Mar 28 08:31:39 2003 X-Original-To: pgsql-php@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CA16447580B for ; Fri, 28 Mar 2003 03:31:39 -0500 (EST) Received: from lucky-server.luckydigital.com (www.luckydigital.com [203.109.157.4]) by postgresql.org (Postfix) with ESMTP id 85EB0474E44 for ; Fri, 28 Mar 2003 03:31:38 -0500 (EST) Received: from jax (203-109-198-1.akl.ihugultra.co.nz [203.109.198.1]) by lucky-server.luckydigital.com (8.12.3/8.12.3/Debian-5) with SMTP id h2S8Vcqb004403 for ; Fri, 28 Mar 2003 20:31:38 +1200 Message-ID: <004101c2f504$74561cb0$c900a8c0@jax> From: "James Cooper" To: Subject: undefined query!!!!! Date: Fri, 28 Mar 2003 20:31:39 +1200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003E_01C2F569.0958A210" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Status: No, hits=1.7 required=5.0 tests=BAYES_30,HTML_20_30,PLING_PLING version=2.50 X-Spam-Level: * X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/48 X-Sequence-Number: 1960 This is a multi-part message in MIME format. ------=_NextPart_000_003E_01C2F569.0958A210 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable dear all=20 I've subscribed in the hope of a simple answer to my dilemma.=20 I run a dev box(mandrake) with php4 and postgres fine=20 I just added postgres support using apt-get on my debian production box=20 after restarting apache I get this=20 Fatal error: Call to undefined function: pg_query()=20 when I try to query?=20 this was added to my php.ini=20 extension=3Dpgsql.so=20 and I checked it exists=20 can anyone help?=20 have i given enough info=20 James ------=_NextPart_000_003E_01C2F569.0958A210 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

dear all

I've= =20 subscribed in the hope of a simple answer to my dilemma.
I run a dev=20 box(mandrake) with php4 and postgres fine
I just added postgres support= =20 using apt-get on my debian production box
after restarting apache I get= this=20

Fatal error: Call to undefined function: pg_query()
when I try = to=20 query?

this was added to my php.ini
extension=3Dpgsql.so
and I=20 checked it exists
can anyone help?
have i given enough info=20


James

------=_NextPart_000_003E_01C2F569.0958A210-- From francesco.piccinini@st.com Fri Mar 28 09:16:48 2003 X-Original-To: pgsql-php@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 390AF47580B for ; Fri, 28 Mar 2003 04:16:48 -0500 (EST) Received: from beta.dmz-eu.st.com (beta.dmz-eu.st.com [164.129.1.35]) by postgresql.org (Postfix) with ESMTP id DB1CC474E44 for ; Fri, 28 Mar 2003 04:16:42 -0500 (EST) Received: from zeta.dmz-eu.st.com (ns2.st.com [164.129.230.9]) by beta.dmz-eu.st.com (STMicroelectronics) with SMTP id 3B2C249D4; Fri, 28 Mar 2003 09:16:42 +0000 (GMT) Received: by zeta.dmz-eu.st.com (STMicroelectronics, from userid 0) id 8D6EA61D6; Fri, 28 Mar 2003 09:16:30 +0000 (GMT) Received: from agx003.agr.st.com (localhost [127.0.0.1]) by zeta.dmz-eu.st.com (STMicroelectronics) with ESMTP id 05012184A; Fri, 28 Mar 2003 09:16:30 +0000 (GMT) Received: from st.com (pic.rdd.agr.st.com [164.130.35.126]) by agx003.agr.st.com (8.9.3 (PHNE_24419+JAGae58098)/8.9.3) with ESMTP id KAA15182; Fri, 28 Mar 2003 10:16:29 +0100 (MET) Message-ID: <3E8412A4.753B4F63@st.com> Date: Fri, 28 Mar 2003 10:15:16 +0100 From: Francesco Piccinini X-Mailer: Mozilla 4.76 [en] (X11; U; SunOS 5.8 sun4u) X-Accept-Language: en MIME-Version: 1.0 To: jim@luckydigital.com Cc: pgsql-php@postgresql.org Subject: Re: undefined query!!!!! References: <004101c2f504$74561cb0$c900a8c0@jax> Content-Type: multipart/alternative; boundary="------------30E04781290CB3FBBDC2E136" X-Spam-Status: No, hits=-23.7 required=5.0 tests=BAYES_20,EMAIL_ATTRIBUTION,HTML_40_50,PLING_PLING, QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/49 X-Sequence-Number: 1961 --------------30E04781290CB3FBBDC2E136 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Has PHP been compiled with postgres support ? Bye, Francesco jim@luckydigital.com wrote: > dear all > > I've subscribed in the hope of a simple answer to my dilemma. > I run a dev box(mandrake) with php4 and postgres fine > I just added postgres support using apt-get on my debian production > box > after restarting apache I get this > > Fatal error: Call to undefined function: pg_query() > when I try to query? > > this was added to my php.ini > extension=pgsql.so > > and I checked it exists > can anyone help? > have i given enough info > > > James --------------30E04781290CB3FBBDC2E136 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Has PHP been compiled with postgres support ?
 

Bye, Francesco

jim@luckydigital.com wrote:

dear all

I've subscribed in the hope of a simple answer to my dilemma.
I run a dev box(mandrake) with php4 and postgres fine
I just added postgres support using apt-get on my debian production box
after restarting apache I get this

Fatal error: Call to undefined function: pg_query()
when I try to query?

this was added to my php.ini
extension=pgsql.so

and I checked it exists
can anyone help?
have i given enough info
 

James

--------------30E04781290CB3FBBDC2E136-- From brew@theMode.com Fri Mar 28 13:14:37 2003 X-Original-To: pgsql-php@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 718D247633C for ; Fri, 28 Mar 2003 08:14:37 -0500 (EST) Received: from themode.com (themode.com [161.58.169.198]) by postgresql.org (Postfix) with ESMTP id 4299047580B for ; Fri, 28 Mar 2003 08:14:31 -0500 (EST) Received: from localhost (mode@localhost) by themode.com (8.12.6) id h2SDDxW4051482; Fri, 28 Mar 2003 08:13:59 -0500 (EST) Date: Fri, 28 Mar 2003 08:13:58 -0500 (EST) From: brew@theMode.com X-X-Sender: mode@themode.com To: pgsql-php@postgresql.org Cc: James Cooper Subject: Re: undefined query!!!!! In-Reply-To: <004101c2f504$74561cb0$c900a8c0@jax> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=-12.0 required=5.0 tests=BAYES_10,IN_REP_TO,NO_REAL_NAME,PLING_PLING,USER_AGENT_PINE autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/50 X-Sequence-Number: 1962 James...... > Fatal error: Call to undefined function: pg_query() > when I try to query? I think you need another package, too, possibly php4-pgsql, which contains the php functions for postgreSQL. apt-get install php4-pgsql Be assured that I'm running postgreSQL, apache and php4 using off the shelf packages in Debian (stable version) on my development laptop and it works fine. If you really get stuck I can check exactly what packages I've loaded, but I think you've almost got it running. You can check that postgreSQL support (plus lots of other information about your php) with phpinfo. Let me know...... brew