Re: Limit vs setMaxRows issue

On Wed, 21 Jun 2006, Sebastiaan van Erk wrote:

> I'm not 100% sure of what JDBC says about setMaxRows (it's kind of ambiguous
> in the java doc, as usual), but as far as I can tell, if you call setMaxRows
> on the prepared statement there is no way in to ever retrieve more than that
> number of rows. If this is indeed the case, it seems to me that currently
> there is a mismatch between the JDBC api and the postgresql api, and JDBC
> should somehow tell postgres that this is a hard limit and it should not plan
> for a second batch.
>
> Therefore, my question is: is this a bug? It is not feasable for me to add
> LIMIT clauses to all the SQL queries in my code, so if this IS a bug, I hope
> it can be fixed. If it is NOT a bug, is there an alternative workaround that
> does not involve changing all of my sql statements?
>

I'm not sure how you would like the driver to tell the server that it
doesn't want more than setMaxRows rows. The defined API for this is using
LIMIT in your sql query. The driver cannot do this for you (at least
without parsing your query) because the query may already have a LIMIT or
it may be something like an INSERT into a VIEW that has a DO INSTEAD
SELECT rule on it. If you're suggesting that we extended the
frontend/backend protocol to include this extra information than that's
definitely a feature request, not a bug report.

Kris Jurka