php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #56439 PDO_PGSQL's cursor 'fetch next 1' is invalid
Submitted: 2005-07-05 17:46 UTC Modified: 2005-07-08 15:06 UTC
From: pecl dot php dot net at sharpdreams dot com Assigned: wez (profile)
Status: Closed Package: PDO_PGSQL (PECL)
PHP Version: 5_1 CVS-2005-07-05 (dev) OS: Win32 (XP)
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: pecl dot php dot net at sharpdreams dot com
New email:
PHP Version: OS:

 

 [2005-07-05 17:46 UTC] pecl dot php dot net at sharpdreams dot com 
Description:
------------
In my pglog:

LOG:  statement: BEGIN
LOG:  statement: DECLARE pdo_pgsql_cursor_04e279d0 CURSOR FOR select * from ticket_topics
LOG:  statement: FETCH NEXT 1 FROM pdo_pgsql_cursor_04e279d0
ERROR:  syntax error at or near "1" at character 12

ref: http://www.postgresql.org/docs/8.0/interactive/sql-fetch.html

"NEXT" does not take an argument; FORWARD does. Also should use BACKWARD and not PRIOR.

Should generate 'FETCH FORWARD 1 FROM pdo_pgsql_cursor_04e279d0'

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-07-08 15:06 UTC] wez@php.net 
This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pecl.php.net.

In case this was a pecl.php.net website problem, the change will show
up on the website in short time.
 
Thank you for the report, and for helping us make PECL better.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri May 09 13:01:28 2025 UTC