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=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

Re: undefined query!!!!!

--------------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

Re: undefined query!!!!!

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.

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@postgresql.org)