| From: | Tzahi Fadida <tzahi_ml(at)myrealbox(dot)com> | 
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org | 
| Subject: | SPI bug. | 
| Date: | 2005-04-30 01:25:12 | 
| Message-ID: | 000001c54d23$75adb680$0b00a8c0@llord | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Hi,
While trying to determine if SPI_cursor_move can rewind
(and receiving a great help from the guys at the irc), we
found out that since the count parameter is int
and FETCH_ALL is LONG_MAX then setting
the count parameter to FETCH_ALL to rewind
will not work on 64bit systems.
On my pIII 32 bit system it works since int size=long size.
I am using 8.0.2 (i.e. the repositioning bug is already fixed here).
I think the solution can be either changing the FETCH_ALL to
INT_MAX or changing the interface parameter count and subsequent usages
to long.
(FETCH_ALL at parsenodes.h)
Regards,
	tzahi.
WARNING TO SPAMMERS:  see at
http://members.lycos.co.uk/my2nis/spamwarning.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2005-04-30 01:57:23 | Re: Feature freeze date for 8.1 | 
| Previous Message | Sergey E. Koposov | 2005-04-30 00:01:53 | Re: performance of bitmap scans in nested loop joins |