| Lists: | pgsql-bugs |
|---|
| From: | "William ZHANG" <uniware(at)zedware(dot)org> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2970: "FETCH ABSOLUTE -1" from a holdable cursor failed |
| Date: | 2007-02-06 06:28:15 |
| Message-ID: | 200702060628.l166SFg7054170@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2970
Logged by: William ZHANG
Email address: uniware(at)zedware(dot)org
PostgreSQL version: 8.2.2
Operating system: i686-pc-linux-gnu
Description: "FETCH ABSOLUTE -1" from a holdable cursor failed
Details:
DROP TABLE foo;
CREATE TABLE foo(fno INT);
INSERT INTO foo VALUES(generate_series(1,5));
BEGIN TRANSACTION;
DECLARE x SCROLL CURSOR WITH HOLD FOR SELECT fno FROM foo;
-- fetch all the 5 rows.
-- after that, cursor position should be past last row.
FETCH 10 FROM x;
COMMIT WORK;
-- try to fetch the last row.
-- it failed.
FETCH ABSOLUTE -1 FROM x;
CLOSE x;
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "William ZHANG" <uniware(at)zedware(dot)org> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #2970: "FETCH ABSOLUTE -1" from a holdable cursor failed |
| Date: | 2007-02-06 22:50:41 |
| Message-ID: | 25151.1170802241@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg토토 사이트 추천SQL : Postg토토 사이트 추천SQL 메일 링리스트 : 2007-02-06 이후 PGSQL-BUGS 22:50 |
"William ZHANG" <uniware(at)zedware(dot)org> writes:
> Description: "FETCH ABSOLUTE -1" from a holdable cursor failed
This bug seems to have been there since holdable cursors were first
implemented. Fixed for next releases --- thanks for the report!
regards, tom lane