From:             srabot at steek dot com
Operating system: Debian Etch stable
PHP version:      5.2CVS-2008-07-25 (CVS)
PHP Bug Type:     PostgreSQL related
Bug description:  Problem with temp tables and cursors

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 bug report at http://bugs.php.net/?id=45625&edit=1
-- 
Try a CVS snapshot (PHP 5.2): 
http://bugs.php.net/fix.php?id=45625&r=trysnapshot52
Try a CVS snapshot (PHP 5.3): 
http://bugs.php.net/fix.php?id=45625&r=trysnapshot53
Try a CVS snapshot (PHP 6.0): 
http://bugs.php.net/fix.php?id=45625&r=trysnapshot60
Fixed in CVS:                 http://bugs.php.net/fix.php?id=45625&r=fixedcvs
Fixed in release:             
http://bugs.php.net/fix.php?id=45625&r=alreadyfixed
Need backtrace:               http://bugs.php.net/fix.php?id=45625&r=needtrace
Need Reproduce Script:        http://bugs.php.net/fix.php?id=45625&r=needscript
Try newer version:            http://bugs.php.net/fix.php?id=45625&r=oldversion
Not developer issue:          http://bugs.php.net/fix.php?id=45625&r=support
Expected behavior:            http://bugs.php.net/fix.php?id=45625&r=notwrong
Not enough info:              
http://bugs.php.net/fix.php?id=45625&r=notenoughinfo
Submitted twice:              
http://bugs.php.net/fix.php?id=45625&r=submittedtwice
register_globals:             http://bugs.php.net/fix.php?id=45625&r=globals
PHP 4 support discontinued:   http://bugs.php.net/fix.php?id=45625&r=php4
Daylight Savings:             http://bugs.php.net/fix.php?id=45625&r=dst
IIS Stability:                http://bugs.php.net/fix.php?id=45625&r=isapi
Install GNU Sed:              http://bugs.php.net/fix.php?id=45625&r=gnused
Floating point limitations:   http://bugs.php.net/fix.php?id=45625&r=float
No Zend Extensions:           http://bugs.php.net/fix.php?id=45625&r=nozend
MySQL Configuration Error:    http://bugs.php.net/fix.php?id=45625&r=mysqlcfg

  • #45625 [NEW]: Problem with temp tables and cursors srabot at steek dot com

Reply via email to