undefined query!!!!!

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

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=3Dpgsql.so

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

James

------=_NextPart_000_003E_01C2F569.0958A210
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
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=3Dpgsql.so <B=
R>and I
checked it exists can anyone help? have i given enough info
 James</DIV></BODY></HTML>

------=_NextPart_000_003E_01C2F569.0958A210--

--------------30E04781290CB3FBBDC2E136
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Has PHP been compiled with postgres support ?

Bye, Francesco

jim [at] 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

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<body bgcolor="#FFFFFF">
Has PHP been compiled with postgres support ?
 
Bye, Francesco
jim [at] luckydigital.com wrote:
<blockquote TYPE=CITE><style></style>
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</blockquote>

</body>
</html>

--------------30E04781290CB3FBBDC2E136--

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.

<?php
phpinfo();
?>

Let me know......

brew

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo [at] postgresql.org)

undefined query!!!!!

Re: undefined query!!!!!

Re: undefined query!!!!!