"Pavel Stehule" <[EMAIL PROTECTED]> writes: > if I comprehended it well CURSOR_OPT_SCROLL is set only when SCROLL is cheap > (not when is possible). It's true?
Nope. If you want a scrollable plan you need to make sure you tell the planner about it. SPI_cursor_open is not in charge, it's merely looking at what the planner did. As for that other stuff, when and if we support it, it would be time to add a SPI entry point that supports it. I'm disinclined to add an API on speculation though --- by the time the feature actually exists, we might not like the API anymore anyway. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match