#45625 [Opn->Csd]: Oops

From: Date: Fri, 25 Jul 2008 14:58:14 +0000
Subject: #45625 [Opn->Csd]: Oops
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-127263@lists.php.net to get a copy of this message 
 ID:               45625
 User updated by:  srabot at steek dot com
-Summary:          Problem with temp tables and cursors
 Reported By:      srabot at steek dot com
-Status:           Open
+Status:           Closed
 Bug Type:         PostgreSQL related
 Operating System: Debian Etch stable
 PHP Version:      5.2CVS-2008-07-25 (CVS)
 New Comment:

My mistake.

MOVE query was not nescessary.


Previous Comments:
------------------------------------------------------------------------

[2008-07-25 13:15:08] srabot at steek dot com

Description:
------------
I create a temp table in postgres to store big amount of data and avoid
LOCKS. Just after I declare a cursor on my table to fetch results.

After a certain amount of MOVE / FETCH I get strange behaviour.

I run :
 * PHP 5.2.0-8+etch11 CLI
 * Postgresql 8.3.3


Reproduce code:
---------------
http://absynthe.pastebin.com/f3a50f01f

Expected result:
----------------
I expect pg_affected_rows($move) to return the same value as $offset.



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=45625&edit=1

Thread (2 messages)

« previous php.bugs (#127263) next »