Hi Michael, Thanks for comments!
On Fri, Feb 09, 2007 at 11:31:29AM +0200, Mihail Mihailov wrote:I have recently found out that PHP libpq Version reported by phpinfo() doesn't match the Actual PGSQL Version on the server. I suspect this is the reason why some of postgresql queries do not run via web interface and run without any problem via psql.
Only some PHP queries don't run? What's different about those that run and those that don't?
At first everything seemed to work fine. Connection works, queries run.So far I have found only one query, which worked in postgres 7.4 and doesn't seem to work now. It is a SELECT query with LIMIT and OFFSET clauses. The first query with OFFSET 0 worked, but the second with OFFSET N returned an empty recordset. I suspected that it has to do with php because the same query works fine in psql environment.
Do the queries that don't run fail with an error message? If so, what's the exact message? What do the PostgreSQL logs show for the failed queries? You might need to adjust settings like log_min_error_statement in postgresql.conf to get useful log entries.
Actually, these queries do not fail they just don't return any data. Do you think it's more likely a bug in the script?
If you ever upgrade PHP to use 8.x libraries instead of 7.4 libraries, beware that some prepared queries that used to work might start failing.
So, you think it is not a good idea to make php use the 8.x libpq? Is the 7.4 libpq quite compatible with postgres 8.1? Does it affect the speed? Mihail Mihailov