From: Michael Fuhr <mike@fuhr.org>
To: Mihail Mihailov <Mihail.Mihailov@uta.fi>
Cc: pgsql-php@postgresql.org
Subject: Re: phpinfo(): postgresql versions' mismatch
Date: Sun, 11 Feb 2007 20:13:52 -0700
Message-ID: <20070212031352.GA11669@winnie.fuhr.org> (raw)
In-Reply-To: <20070209195346.qlm86chc1u88g84g@imp1.uta.fi>
References: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi>
<20070209145731.GA28879@winnie.fuhr.org>
<20070209195346.qlm86chc1u88g84g@imp1.uta.fi>
On Fri, Feb 09, 2007 at 07:53:46PM +0200, Mihail Mihailov wrote:
> > 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.
Have you turned on statement logging in the database to verify that
PHP is sending the query you think it is? Have you looked for
errors in the database logs? What does the PHP code that fetches
the results look like?
> 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?
Impossible to say without more information. A self-contained test
case might be useful.
> > 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?
I didn't mean to suggest not using libpq 8.x; I was suggesting that
you review your queries to make sure you're not depending on implicit
type casts that PDO's emulated prepared statements might be making
that will no longer be made with the "real" prepared statements
that PDO uses when linked against libpq 8.x.
--
Michael Fuhr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: mike@fuhr.org, Mihail.Mihailov@uta.fi
Subject: Re: phpinfo(): postgresql versions' mismatch
In-Reply-To: <20070212031352.GA11669@winnie.fuhr.org>
References: <20070209113129.he36qgs4vthc0o4c@imp3.uta.fi> <20070209145731.GA28879@winnie.fuhr.org> <20070209195346.qlm86chc1u88g84g@imp1.uta.fi> <20070212031352.GA11669@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox