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
