Michael Meskes <meskes@postgresql.org> writes:
> Is limit ignored in a cursor definition?
Yes. Seems to me we discussed that and decided it was a feature,
not a bug. Check the archives if you want to know why; I don't
recall.
If we do believe that, though, probably DECLARE CURSOR ... LIMIT
ought to give an error, instead of silently ignoring the limit
as it does now.
regards, tom lane