On Tue, Aug 16, 2011 at 7:25 PM, Tom Lane wrote:
> Jeevan Chalke writes:
> > 1. I have two functions func1 and func2.
> > 2. func1 calls func2
> > 3. Both has cursor with same name, say mycursor
> > 4. Somehow I forgot closing it
> > 5. executing func1 throws an error 'cursor "mycursor" already
Jeevan Chalke writes:
> 1. I have two functions func1 and func2.
> 2. func1 calls func2
> 3. Both has cursor with same name, say mycursor
> 4. Somehow I forgot closing it
> 5. executing func1 throws an error 'cursor "mycursor" already in use'
> Is this expected behavior???
Yes ... or at least, i
Hi Tom,
While going through few test-cases, I found that we cannot have two opened
cursors with same name even though they are in two different functions. Here
is what I mean:
1. I have two functions func1 and func2.
2. func1 calls func2
3. Both has cursor with same name, say mycursor
4. Somehow
