Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

pg_prepare() not working

Status
Not open for further replies.

kaancho12

Technical User
Feb 22, 2005
191
i was successful making a postgresql connection in php. when i test the connection status ( pg_connection_status($dbconn);) it says the connection is ok but i am not able to use pg_prepare(), pg_execute()--when tryin to use these commands it gives: Fatal error: Call to undefined function pg_prepare() error
any idea?
ko12
 
Is there any mention of the postgrast functions in your phpinfo() ? If not you may need to activate this

JR
IT = Logic (except for a well known OS where it equals luck) -> Back to the Basics!
 
This is phpinfo() 's result on postgresql. It doesnt show any postgres functions. How do i enable it? i am using redhat linux.

PostgreSQL Support enabled
PostgreSQL(libpq) Version 8.0.3
Multibyte character support enabled
SSL support disabled
Active Persistent Links 0
Active Links 0

Directive Local Value Master Value
pgsql.allow_persistent On On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_notice Off Off
pgsql.log_notice Off Off
pgsql.max_links Unlimited Unlimited
pgsql.max_persistent Unlimited Unlimited

thanks
ko12
 
Well,
I did a simple search in Google and found some helpful information. I suggest that you search for
Call to undefined function pg_prepare()

Cheers

JR
IT = Logic (except for a well known OS where it equals luck) -> Back to the Basics!
 
kaancho12:
Out of curiosity, what version of PHP are you running? According to the PHP online manual, pg_prepare() is only supported in PHP version 5.


Want the best answers? Ask the best questions!

TANSTAAFL!!
 
thanks for the tip JRBeltman . i will look into that.

also, i am using php5. i will have to look into my installation files and modules to see why those commands are not working. otherthan that, simple pgsql commands seem to work with no problems in php.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top