Joseph Shraibman <jks@selectacast.net> writes:
> Tom Lane wrote:
>> I don't see an error if I do it that way, but I do see an error if the
>> cursor hasn't yet fetched all the rows:
> What version are you using? I get the error using exactly what I showed you on 7.1.3.
Hmmm ... I was using current sources. I do replicate your result on
7.1.3, however. It looks like 7.1 holds onto a buffer pin for a
completed scan a little longer than 7.2 does. I believe this is related
to my changes of 2001-06-09 14:16, but don't feel like running it to
ground right now. The bottom line is the same in any case: the open
cursor represents a reference to the relation, which should prevent
us from dropping the relation.
regards, tom lane