Re: [HACKERS] Allowing same cursor name in nested levels

2011-08-17 Thread Jeevan Chalke
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

Re: [HACKERS] Allowing same cursor name in nested levels

2011-08-16 Thread Tom Lane
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