I've checked the script.
It was a bug in the script. Now all the queries work fine.
Sorry for disturbing.
Mihail
Quoting Michael Fuhr <mike@fuhr.org>:
> 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
>
--
Mihail Mihailov, lehtori
Käännöstiede (venäjä)
Kieli- ja käännöstieteiden laitos
33014 Tampereen yliopisto
puh. (03) 3551 6123
sähköposti: mihail.mihailov@uta.fi
