From: shoorf at gmail dot com Operating system: FreeBSD 8.3 amd64 PHP version: 5.3.14 Package: PostgreSQL related Bug Type: Bug Bug description:set timeout not affected
Description: ------------ doesn't work setting statement_timeout to postgres and running pg_sleep in 1 query but it sql query works fine when it runs through psql in console if run 3 separated queries (SET, pg_sleep, RESET), it works fine too Test script: --------------- pg_query($db, 'SET statement_timeout TO 0; SELECT pg_sleep(180); RESET statement_timeout;'); Expected result: ---------------- not timeout Actual result: -------------- if statement_timeout in postgres settings set less than 180 sec, this code give the error: canceling statement due to statement timeout -- Edit bug report at https://bugs.php.net/bug.php?id=62522&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=62522&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=62522&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=62522&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=62522&r=fixed Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=62522&r=needdocs Fixed in release: https://bugs.php.net/fix.php?id=62522&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=62522&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=62522&r=needscript Try newer version: https://bugs.php.net/fix.php?id=62522&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=62522&r=support Expected behavior: https://bugs.php.net/fix.php?id=62522&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=62522&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=62522&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=62522&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=62522&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=62522&r=dst IIS Stability: https://bugs.php.net/fix.php?id=62522&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=62522&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=62522&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=62522&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=62522&r=mysqlcfg