Re: PDOStatement:closeCursor

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Yonatan Ben-Nes <yonatan(at)epoch(dot)co(dot)il>
Subject: Re: PDOStatement:closeCursor
Date: 2006-12-17 14:48:06
Message-ID: 458558A6.1080302@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2006-12-17 18:18:53 Creating an Application
Previous Message macgillivary 2006-12-17 14:14:17 Re: Performance of outer joins?