Thread: PDOStatement:closeCursor

PDOStatement:closeCursor

From
"Yonatan Ben-Nes"
Date:
Hi all,

I know that it's also related to PHP but sadly no one knew anything there so I try here... :)

At the PHP manual of PDOStatement::closeCursor it's written that "This method is useful for database drivers that do not support executing a PDOStatement object when a previously executed PDOStatement object still has unfetched rows. If your database driver suffers from this limitation, the problem may manifest itself in an out-of-sequence error.".
Anyone know if the PostgreSQL driver suffer from this problem or not?

Thanks a lot in advance,
 Ben-Nes Yonatan

Re: PDOStatement:closeCursor

From
Hannes Dorbath
Date:
It's always good to close your cursors once you don't need them anymore,
but PostgreSQL doesn't force you to or blocks if you don't.

I really wonder why people use senseless things like PDO. Ah yes.. it's
all about design patterns, right. Let's write a wrapper for the sole
purpose of having written a wrapper. Sounds like a great pattern.

Yonatan Ben-Nes wrote:
> I know that it's also related to PHP but sadly no one knew anything
> there so
> I try here... :)
>
> At the PHP manual of
> PDOStatement::closeCursor<http://il.php.net/manual/en/function.pdostatement-closecursor.php>it's
>
> written that "This method is useful for database drivers that do not
> support executing a PDOStatement object when a previously executed
> PDOStatement object still has unfetched rows. If your database driver
> suffers from this limitation, the problem may manifest itself in an
> out-of-sequence error.".
> Anyone know if the PostgreSQL driver suffer from this problem or not?


--
Best regards,
Hannes Dorbath